Shopify Admin API Pagination - Unable to retrieve response header

[PeterPLSMYX]

I am attempting to paginate the Shopify Admin API via Power Query. However, in order to paginate the Shopify API, I need the link to next page. These are provided in the header response: "When you send a request to a REST endpoint that supports cursor-based pagination, the response body returns the first page of results, and a response header returns links to the next page and the previous page of results (if applicable). You can use the links in the response header to iterate through the pages of results." 

I have tried the: Value.Metadata M-function without any luck. This provides the date, server and status code and other meta data without providing the link to next page. 

Does anyone know how to obtain this information in the response header in Power Query? 

[ltopchyi]

Hi @PeterPLSMYX 

If you concider to switch to a ready solution where pagination is realized, you can take a look at this Power BI Connector. 

Cheers,

Liuba

[Anonymous]

Hi @PeterPLSMYX ,

I suggest you to refer to blog as below to learn more details about how to make a paginated request and iterate through the pages.

For reference:

Make paginated requests to the REST Admin API

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.