How to Run Synapse pipeline from webactivity Rest api call?

Anonymous

how can run trigger synapse pipeline from web activity with rest api ?

1 answer

MartinJaffer-MSFT 26,031 Reputation points

2021-11-12T20:58:09.747+00:00
Hello anonymous user and welcome to Microsoft Q&A. You can find the details for this call at:
https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/pipeline/create-pipeline-run

POST https://{workspaceName}.dev.azuresynapse.net/pipelines/{pipelineName}/createRun?api-version=2020-12-01

The authentication can be done different ways. If you use Managed Identity , the Resource : https://management.azure.com/ . You may need to grand the Data Factory RBAC roles on itself or the resource group. It will need the Microsoft.DataFactory/factories/pipelines/createrun/action ability. The role Data Factory Contributor has this, but is overkill.
Please sign in to rate this answer.
Anonymous

2021-11-13T00:59:24.467+00:00

ho do i get the referencePipelineRunId? is it mandatory ? and what should i give in body ?

Anonymous

2021-11-13T01:28:33.877+00:00

how can i delete this question ?

Karthikeya Gadamsetty 20 Reputation points

2023-02-23T09:21:23.06+00:00

Hi Martin,

To test a use case we are invoking Synapse pipelines using web activity in Synapse workspace. The web activity makes an API call to a pipeline which is already present. As we understand the URL that needs to be passed to web activity as per Microsoft portal is (Synapse end point is edited for privacy reasons. However the end point can be picked from synapse workspace under properties.

https://synapse end point/pipelines/pipeline1/createRun?api-version=2019-06-01-preview

Or

https://management.azure.com/synapse end point/pipelines/pipeline1/createRun?api-version=2019-06-01-preview

We are receiving below error:

Troubleshoot activity failures

{ "errorCode": "2108", "message": "Invoking Web Activity failed with HttpStatusCode - '404 : NotFound', message - 'The requested resource does not exist on the server. Please verify the request server and retry'", "failureType": "UserError", "target": "Web1", "details": [] }

Can someone guide us how to build or create a url to execute a pipeline in web activity. Also authentication we are using managed identity and are passing https://management.azure.com/ under Resource

MartinJaffer-MSFT 26,031 Reputation points

2023-03-21T19:31:09.71+00:00

@Karthikeya Gadamsetty

This thread has aged, if you still need help, please open a new question thread.
Sign in to comment