JSON object to array of nested JSON

SARASWAT CHETAN 91 Reputation points
2020-11-06T08:34:18.233+00:00

I have a JSON object in cosmos DB(source) which I need to transform into an array of nested JSON objects(similar to source objects)in Cosmos DB(sink). Using the derived column I am facing an error during typecast of complex json to array. Could I get an assistance into this.

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,612 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,568 questions
{count} votes

Accepted answer
  1. MarkKromer-MSFT 5,211 Reputation points Microsoft Employee
    2020-11-18T07:36:59.573+00:00

    To generate arrays in your data, you will use an Aggregate transformation with the collect() function.

    We have an example video of this here: https://www.youtube.com/watch?v=zneE18EHJSE


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.