Azure synapse copy activity REST source and ADLS Gen2 sink

Question

Greetings Hi, I'm running into an issue with my output json file. In Azure synapse copy data activity I use a REST api source and ADLS Gen2 sink where I create a json file in a container. When I look at the REST api output in Postman I see the json output like below. Postman:

{"data":[{"JsonOutput":"1"}]}

But, in Azure synapse after running the pipeline, If I look at the json file in the container I see the json output like an array below. Synapse:

[{"data":[{"JsonOutput":"1"}]}]

Not sure why the json output is enclosed between [ ], Like an array. In the copy activity sink I have it configured like below.

What might be causing this issue or how to fix it? Also, how to set content-type to application/json when the json file is saved to the container? Thank you.

Answer 1

Hi Raj D, Thank you for posting query in Microsoft Q&A Platform.

In Copy Activity Under Sink tab, for File Pattern option, make sure you select nothing or Set of Objects. Also make sure inside sink dataset you are not importing any schema.

Please note, I see you already selected Set of Objects but may be you have not published that changes. Try to publish changes or run in debug mode and see. I tried at my end with Set of Objects option, its working fine for me without any array symbol. Hope this helps. Please let me know how it goes and if any further queries.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.