thanks for your response. I built the Graph query in Monday.com API playground. The query works in the body of both web and copy data activities. Unfortunately, the schema column values are repeated from the source, and I need map the column value {text} to their respective columns in Azure SQL table. I have the process working in a pipeline fine by using an initial web activity to then store the cursor into a variable which then an Until activity runs a copy activity with another web activity/set variable to continue to update the cursor until the if condition is met which is cursor results to null.

The problem I have with this method is it takes approximately 15 seconds run the each process and to write the data using the limit to 1 result per cursor (this enables the rows to be wrote separately for the repeated column values). I have a large amount of data to query and write and would take days.

My idea was to use the dataflow so i could call the source API and then flatten the JSON to be able to then re-map the schema before its wrote to the Azure SQL table.

Thanks