Shopify API, Orders Limit, Help With Pagination

unknownb — Thu, 09 Nov 2023 09:45:10 GMT

Hello,

Similar to a post here: https://community.qlik.com/t5/New-to-Qlik-Sense/REST-connection-api-limit/m-p/2038360#M224175

We've added our REST to the shopify URL using the below method

https://xxx.myshopify.com/admin/api/2023-10/orders.json?status=any&fields=name,number,order_number,created_at,total_price,total_discounts,total_tax,cancelled_at,contact_email,currency,current_subtotal_price,current_total_discounts,current_total_price,current_total_tax,order_status_url,total_line_items_price,billing_address,customer,line_items

With a header of 'X-Shopify-Access-Token' being set and our token.

However, the API is limited by shopify and it only pulls back 250 records. If you have more than 250 orders, which we have, we need to paginate to pull all orders through.
---
Using Postman, we can achieve this as in the response headers we get;

Key = Link
Value =
"<https://xxxxxx.myshopify.com/admin/api/2023-10/orders.json?fields=name%2Cnumber%2Corder_number%2Ccreated_at%2Ctotal_price%2Ctotal_discounts%2Ctotal_tax%2Ccancelled_at%2Ccontact_email%2Ccurrency%2Ccurrent_subtotal_price%2Ccurrent_total_discounts%2Ccurrent_total_price%2Ccurrent_total_tax%2Corder_status_url%2Ctotal_line_items_price%2Cbilling_address%2Ccustomer%2Cline_items&page_info=eyJzdGF0dXMiOiJhbnkiLCJsYXN0X2lkIjo1NTMzMTIwNzU4MDY4LCJsYXN0X3ZhbHVlIjoiMjAyMy0xMC0xOSAxMToxMzowNy4xMTQyMjUiLCJkaXJlY3Rpb24iOiJuZXh0In0 >; rel="next""

So we would use that URL in the Link value and it would pull the remaining orders.

We are struggling on how we can acheive this through the Qlik Sense Data Connector?

We've tried setting up Pagination Type has 'Next URL' with 'Link' in the 'Next URL Path' and the other methods.

Are we missing something?

Re: Shopify API, Orders Limit, Help With Pagination

unknownb — Sat, 11 Nov 2023 23:12:35 GMT

Anyone able to lay a hand at this?

Re: Shopify API, Orders Limit, Help With Pagination

Tami — Wed, 06 Nov 2024 22:41:25 GMT

Has anyone been able to solve using pagination. We are looping through to handle but the pagination method appears to be simpler approach.

topic Re: Shopify API, Orders Limit, Help With Pagination in App Development

Shopify API, Orders Limit, Help With Pagination

Re: Shopify API, Orders Limit, Help With Pagination

Re: Shopify API, Orders Limit, Help With Pagination