Share via

How to access REST end point hosted in APIM using service principal authentication in synapse?

Deba Nayak 61 Reputation points
2023-04-27T09:16:32.47+00:00

Hi,

I am trying to access an API endpoint hosted on Azure APIM using principal service authentication. I have created the app registration, secrets and received the required API permission.

In the REST API linked service I selected the authentication type as Service principal and provided the credentials. I am unsure about the AAD resource, but I am getting a successful test connection.

MicrosoftTeams-image

I am getting successful connections at the DataSource level as well. But when I try to data preview in the activity level, I get the error message "The property 'servicePrincipalId' is invalid or missing."

Not sure what is the issue here. Kindly help!

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,920 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,694 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Konstantinos Passadis 19,166 Reputation points MVP
    2023-04-27T09:48:42.1766667+00:00

    Hello @Deba Nayak !

    I will suggest to go over here

    https://learn.microsoft.com/en-us/rest/api/apimanagement/apimanagementrest/api-management-rest

    Make sure you read and understand the Authentication

    Please mark the answer as Accepted in case you found it helpful!

    BR

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.