Shopify Admin API Pagination, Power BI - Unable to retrieve response header

Retired Boards Appdev Graphql Basics And Troubleshooting

Topic summary

  • Main issue: Paginating Shopify Admin REST API results in Power BI’s Power Query requires the “Link” response header (with next/previous cursors), but Power Query isn’t exposing that header.

  • Context: Shopify’s cursor-based pagination provides next/previous page URLs in the HTTP response headers. The poster attempted to read headers via Power Query’s Value.Metadata M function, which returns date/server/status code but not the “Link” header.

  • Additional reports: Multiple participants confirm the same problem and suspect the “Link” header isn’t passed through to Power Query, blocking pagination.

  • Outcomes: No solution, workaround, or confirmed method to access the “Link” header in Power Query was shared.

  • Status: Unresolved/ongoing. Key open question: How to retrieve the Shopify “Link” response header in Power Query to enable cursor-based pagination.

Summarized with AI on January 3. AI used: gpt-5.
1

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?

2

Hi!

Did you ever find a solution to this? I am about ready to give up on this because I cant figure it out. Running into the same issue because the link header is not passed to PowerQuery which is whats needed to paginate results…

3

@EIVapeDenny @PeterPLSMYEX
Did either of you have any luck with this? I’m currently in the same boat.