Rest API as a data source and output in azure sql database

Punit Parmar 21

Hello,

i am using web activity as a source to call rest api in adf, also my transformation is debugging properly but in my out as a SQL database it is reading only the object data not the array in it.

Please tell me how i can achieve.

Regards

Pedro Fiadeiro 216 Reputation points

2021-01-27T14:08:35.487+00:00

I'm afraid that without more detail such as an example of the data you get back on the API request or how you have your pipeline setup, you won't really get much help
MartinJaffer-MSFT 26,091 Reputation points

2021-01-27T18:17:28.883+00:00

Hello @Punit Parmar and welcome to Microsoft Q&A.

I think you need to use the collection reference feature found in the copy activity mapping. Without knowing more, I can't say for sure it will solve your issue. Only 1 collection reference can be used at a time. The collection reference is like a flatten / unroll .

If you would like more assistance, please share the mapping or an example of how it looks in the source and how you want it to look in the destination. Don't forget to redact / scrub if necessary.
MartinJaffer-MSFT 26,091 Reputation points

2021-02-03T21:46:58.637+00:00

@Punit Parmar Did you find a solution on your own? We haven't heard back from you. If you found your own solution, could you please share it here with the community?

Share via

Rest API as a data source and output in azure sql database

Your answer