Forum Discussion
Solved
API Pagination + Throttling + Dynamic data source issue
Hi there, Where to start... 🙂 (Said laughing and crying at the same time..help..please!!) I want to create a sales report using the DEAR Inventory API v2: https://dearinventory.docs.apiary.io/#int...
Take a look at this blog for how to use the query option available in web.contents
Take a look at this blog for how to use the query option available in web.contents
Thank you blopez11 for pointing me in the right direction, turns out I had the brackets in the wrong place. Ended up being:
Source = Json.Document(Web.Contents(“https://inventory.dearsystems.com",[RelativePath="/externalapi/v2/salelist,Query=[Number.ToText(page),limit=1000],
Headers=[#"api-auth-accountid"="xxxxxxxxxxxxxxxxxxxxxxxxxxx", #"api-auth-applicationkey"="xxxxxxxxxxxxxxxxxxxxxxxxxxx”]]))