Azure Data Factory Rest Linked Service sink returns Array Json

MarkV 0 Reputation points
2023-04-12T20:27:38.3333333+00:00

I am developing a data copy from a DB source to a Rest API sink. The issue I have is that the JSON output gets created with an array object. I was curious if there is any options to remove the array object from the output. So I do not want: [ {id:1,value:2}, {id:2,value:3} ] Instead I want {id:1,value:2} {id:2,value:3}

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,451 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,717 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 31,561 Reputation points Microsoft Employee
    2023-04-13T16:49:13.8466667+00:00

    Hi MarkV , Welcome to Microsoft Q&A platform and thankyou for posting your question here. As per my understanding, you want to convert your array of jsons into json . Please let me know if that is not the ask.

    You can try using flatten transformation in mapping dataflow in order to do so. It is used to take array values inside hierarchical structures such as JSON and unroll them into individual rows.

    To know more about the flattening transformation and its implementation , kindly check out the below resources: Flatten transformation in mapping data flow Flatten transformation in ADF How to flatten the nested json using mapping dataflow Hope it helps. Kindly accept the answer .