My requirement is to extract data from GraphQL API and load into Azure SQL database which works fine for less volume of data.
When the data volume increases the GraphQL API returns a token as "next" which when called in the right way would allow me to access the next page of data. I understand this is cursor pagination where we need to store the primary key value to a context variable and request again to get the next page of data.
I have mapped the next token to a variable but unable to use it as a Query parameter in tRestClient within a loop to get the next set of data.
Could someone explain to me as what's the best way to implement it.
