Invoke REST and store the response into a blob Azure Data Factory

Question

Hello

we have a requirement to invoke a REst API (GET) and then store the response from the API(which is in JSON) into a blob container using Azure data factory.

Is this possible using Copy Activity? if yes, what should be the source and sink please

thanks

Answer 1

Hi @Biju Mathew

Yes it's possible in copy activity. You need to use REST source and BLOB DELIMITED text as sink. Please check this video for your reference.

https://youtu.be/NLuWVtYy1Rs

Kindly let us know if you have any question.

Thanks

Suba

Answer 2

Hi @MS Prog,

Thank you for posting query in Microsoft Q&A Platform.

You can achieve this using REST connector dataset in Source tab of Copy activity. And then blob connector dataset in sink tab of Copy activity.

Please check below screenshots. Here REST type source and Blob storage type sink used. Please note, make sure to check mappings tab, to import your mappings between source and sink and use them accordingly.

Hope this helps. Please let me know if any further queries.

---

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