Iam trying to create a ADF dataflow to extract data from API using graphql query. It has nested structures and I believe copy activity does not support nested structures. I tried using dataflow but receiving errors. Below is the query I am trying to pass from Rest body. When I try to do the import projection it fails.

{ “query”: “query($startTime: Long!, $endTime: Long!) { agentSession(from: $startTime, to: $endTime, pagination: { cursor: “0” }) { agentSessions { agentId teamId siteId channelInfo { channelId channelType totalDuration connectedDuration activities { nodes { id startTime endTime}} } } pageInfo { endCursor hasNextPage } }}”, “variables”: { “startTime”:1704088615000 , “endTime”:1719813415000 } }

Appreciate your response.

Kind Regards
Suresh