Multiple Collection Reference from API JSON with an API Source GET

Lucas GAURICHON 1 Reputation point


I'm having difficulties to map an API JSON with Multiple Collection Reference.

Here under the information on my Source which is an API JSON from SAP ByDesign :



Do you know how can I succeed to map with it with two loops : one on "results" and the other on "salesorderitem" ?

Thank You for your help.


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,045 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Lucas GAURICHON 1 Reputation point

    Thank You Martin.

    Sorry for my late answer, I was off for a few days.

    Concerning the first option, when I'm trying to select the SalesOrderItem as Array, I'm getting all the SalesOrderItem but only for the first "results". Thus, I'm not able to get a table with all the SalesOrderItems from all results and chain the two tables together with a key from "results".

    Concerning the second option, how can I use the Data Flows Flatten Transformation withouth having a first copy of the data in Azure ?

    Thank you very much for your precious help :)

    0 comments No comments