Logic Apps Invoking Azure Synapse REST API

Question

Hello,
Logic Apps provides HTTP option to invoke REST API (we could use it for Synapse), unfortunately they don’t have connector like Azure Data factory. The following REST API to run the pipeline expects a token,

Pipeline - Create Pipeline Run - REST API (Azure Synapse) | Microsoft Learn (in order to run this Pipeline, it needs a Token but could not find out a way to get token).

Some links are there for Powershell to get token. So far did not get any concrete step/direction.

Referred So far,

How to start Synapse Pipeline from Rest API - Microsoft Tech Community

Kindly assist.

Answer 1

Hello Himanshu,
We could generate a token and when we use the token and invoke the REST API (Synapse Pipeline), we get the following error now.
{
"code": "InvalidTokenAuthenticationAudience",
"message": "Token Authentication failed with SecurityTokenInvalidAudienceException - IDX10214: Audience validation failed. Audiences: 'System.String'. Did not match: validationParameters.ValidAudience: 'System.String' or validationParameters.ValidAudiences: 'System.String'."
}

Kindly check

Answer 2

Thanks Himanshu. Can you please share how to register the application to provide the client id and secrets , as mentioned here.

URL: https://login.microsoftonline.com/common/oauth2/authorize
METHOD: POST
HEADERS: Content-Type = application/x-www-form-urlencoded
BODY: grant_type=client_credentials&client_id={id}&client_secret={secret}&resource=https://management.azure.com

Is there any documentation that explains about registering and getting the right details ?

Answer 3

Hello @Anonymous ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is how to get the bearer token , please do let us know if its not accurate.
I think the steps are well called out in the below post .

https://learn.microsoft.com/en-us/answers/questions/705328/get-bearer-token-for-azure-management-api-using-da.html

Please do let me if you have any queries.
Thanks
Himanshu

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators