how we read data from REST API Collecation in Azure Data Factory RRS feed

  • Question

  • Hi All,

    i Have try to read sample API-https://gorest.co.in/public-api/users

    inside this API we have collection- but using REST link service  i create copy Activity to try read data and put in a blob file but i got only first row not all data

    Tuesday, December 24, 2019 11:59 AM

All replies

  • Hi Manish,

    Using a copy activity in ADF you can copy data from a REST API to blob storage. You can set up a REST API linked service to do so.

    Hope this helps.

    Thursday, December 26, 2019 6:15 AM
  • Thanks a lot for replay,

    i am able to Connect REST API and get a JSON file in Data Lake,

    but how i load this data in SQL, because i have 2 Column in JSON is ARRAY Type.

    i try to MAP Arrya type to string in Data Factory Copy data mapping TAB but it will error out,

    i want to know it is possible in ADF or not.

    see below mapping , it is error out

    • Edited by manish0000 Tuesday, December 31, 2019 5:15 AM image missing
    Tuesday, December 31, 2019 5:13 AM
  • Hey Manish,

    You can have an azure function activity or a custom activity in ADF to read data from the REST API, process it and then write to a SQL Sink.

    Hope this helps.

    Thursday, January 2, 2020 11:15 AM
  • Hi Manish,

    Just wanted to check - was the above suggestion helpful to you? If yes, please consider upvoting and/or marking it as answer. This would help other community members reading this thread.
    Thursday, January 9, 2020 10:01 AM