excel web query to get cin7 api

hi, we need to 2 sets of data from cin7 api into excel. read only, products (all active) and sales (for date range)
you will:
-check cin7 api docs
-be skilled in web query
we need the data pulled stored in respective tab. ie [products] [sales]
thanks