Error with Azure Synapse HTTP linked service

Waris Souran 0 Reputation points
2023-03-27T09:29:00.0066667+00:00

I'm attempting to create an HTTP linked service from the Anonymous website, but my Synapse Analytics does not support it. My Synapse isn't letting me create a pipeline to retrieve data from the HTTP website. Several of the websites I tried didn't work. Kindly address this problem. I have a difficulty. for example this URL: https://dummy.restapiexample.com/api/v1/employees and about the Access Control I am added in Azure Center for SAP Solutions service role, Contributor and User Access Administrator

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,858 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,471 Reputation points Microsoft Employee
    2023-03-27T19:56:05.3633333+00:00

    Hello @Waris Souran ,

    Thanks for the question and using MS Q&A platform.

    I did tried to setup the same with the API https://dummy.restapiexample.com/api/v1/employees and I was able to make it work .

    Please select the file type as "JSON" and

    User's image

    http

    Himanshu
    Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues. 


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.