How to create a query that paginates for Shopify API?

[xxyb720]

I am able to get data from Shopify API using basic authentication. Link: https://shopname.myshopify.com/admin/api/2019-10/products.json

However, it doesn't return all the data. After some research I understand that I need to make a paginated request and iterate through the pages. Shopify documentation: https://help.shopify.com/en/api/guides/paginated-rest-results

I tried some codes (mostly using list.generated) I found in this community but none of them work for me. Then I found a post (https://community.powerbi.com/t5/Power-Query/API-calls-with-Pagination/td-p/323080) saying it doesn't seem to be currently possible for Power Query to look at the HTTP "Link" response header. If that's the case, did anyone have a custom data connector for shopify? Or any code that helps to make paginated queries. Thanks in advance!

[ltopchyi]

Hi @xxyb720 

You can take a look a this custom connector for Shopify & Power BI - https://apps.shopify.com/power-bi-connector-1 

Liuba

[v-juanli-msft]

Hi @xxyb720 

You can use the code below to get data from Shopify to Power BI.

http://shopify.topowerbi.com/ 

GET /admin/orders/#[id]/transactions.json.

Please refer to the following thread which connecting to Shopify with Power BI Desktop successfully.

https://community.powerbi.com/t5/Power-Query/API-web-link-to-shopify-only-50-rows-returned-in-query-...

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.