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?
