Share via

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

Biju Mathew 481 Reputation points
2023-03-30T01:04:00.18+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Accepted answer
  1. Subashri Vasudevan 11,226 Reputation points
    2023-03-30T05:50:36.2566667+00:00

    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

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2023-03-30T09:31:48.1+00:00

    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.

    User's image

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

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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.