apirestazureazure-data-factorycortana-intelligence

Using Azure Data Factory to get data from a REST API


Is it possible to use Azure Data Factory to get data from a REST API and insert it to a Azure database table?


Solution

  • Data factory offers a generic HTTP connector and a specific REST connector, allowing you to do retrieve data from HTTP endpoints by using GET or POST methods.

    Example: HTTP Linked Service

    {
        "name": "HttpLinkedService",
        "properties":
        {
            "type": "Http",
            "typeProperties":
            {
                "authenticationType": "Anonymous",
                "url" : "https://en.wikipedia.org/wiki/"
            }
        }
    }