GraphQL pagination in ADF

Shopify Apps
1

Hi friends,

I want to retrieve all my customer data from Shopify and copy them into SQL Server. To do so I’m using ADF (Azure Data Factory) but I have issues with pagination. I can just get thee first 250 customer in the first page but it doesn’t show the following pages.

here is my query:

{
    "query": "query ($cursor: String)
                { customers(first:  250, after: $cursor)
                    { edges
                        { node
                            {id
                            firstName
                            numberOfOrders
                            phone
                            productSubscriberStatus
                            statistics
                                { predictedSpendTier }
                            }
                        }
                    pageInfo { endCursor hasNextPage } } }"
}

and for the pagination rules I’ve defined:
QueryParameters $cursor Body data.customers.pageInfo.endcursor

I will appreciate it if you could help.