Use Case: Read data from SQL server, transform each row by passing it to Azure Function and then load them into Cosmos DB.
- SQL Server with Integration Run time is done.
- Azure Function to transform each row is complete.
- Cosmos DB sink is also ready.
EDIT HERE (Added points) 4. Transformed data should be upserted back to the SQL server against each row that was read in the first step.
5. Transformed data should also be saved onto a CSV file in Blob Storage.
I'm unable to figure out how to load the response ( JSON Object) from the Azure function into the cosmos sink.
Read Data from SQL using Lookup activity ----> Use a ForEach iteration to iterate through each row -----> Add Azure function as an activity inside ForEach Iteration and pass each item() ----> Azure Function is responding back with transformed data as JSON object -----> ???? (I'm stuck here) How do I now load it back into the Cosmos Sink.
Can someone guide me out here?