GraphQL- Shopify Pagination

Hi everyone,

I’m building an ADF pipeline to pull all orders from Shopify’s GraphQL API into an Azure SQL database, and I’m stuck on the pagination logic.

What I’ve tried so far

1. Use a Lookup activity to run the first GraphQL query (no after cursor) and extract

 Store endCursor in a pipeline variable afterCursor.

2. Until loop

Condition: @equals( variables('hasNextPage'), false )

• Copy (or Lookup) activity using a dynamic body that injects after:$afterCursor when it’s non-empty

• Set variable → capture the new endCursor and hasNextPage from the JSON

• Write out the nodes array to SQL

First-page query (Lookup):

@concat(
  '{',
    '"query":"query GetOrders($first:Int!,$filter:String){',
      'orders(first:$first, sortKey:CREATED_AT, reverse:true, query:$filter){',
        'nodes{',my fields....',
        '} ',
        'pageInfo{hasNextPage endCursor}',
      '}',
    '}",',
    '"variables":{',
      '"first":250,',
 
      concat(
        '"filter":"created_at:>',
        variables('lastOrderDate'),
        '"'
      ),
    '}',
  '}'
)

Loop query (Copy or Lookup inside Until):

@concat(
  '{',
    '"query":"query GetOrders($first:Int!,$after:String,$filter:String){',
      'orders(first:$first',
        if(
          empty(variables('afterCursor')),
          '',
          concat(', after:\"', variables('afterCursor'), '\"')
        ),
      ', sortKey:CREATED_AT, reverse:true, query:$filter){',
        'nodes{…} pageInfo{hasNextPage endCursor}',
      '} }",',
    '"variables":{',
      '"first":250',
      
      if(
        empty(variables('afterCursor')),
        '',
        concat(', "after":"', variables('afterCursor'), '"')
      ),
      
      concat(
        ', "filter":"created_at:>',
        coalesce(variables('lastOrderDate'),'1990-01-01T00:00:00Z'),
        '"'
      ),
    '}',
  '}'
)

Where I’m stuck

• I can extract the first endCursor outside the loop, but once inside the Until, I don’t know how to capture and reuse each subsequent endCursor that the Copy activity returns.

• Copy activitys output only exposes metrics (rowsCopied, throughput, etc.), not the JSON body.

Can anyone advise:

1. A simpler pattern for Shopify GraphQL pagination in ADF?

2. How to “read” the next endCursor inside the loop (from a Copy or Lookup) so I can feed it back into the next iteration?

Thanks in advance for any guidance!