How to Run Synapse pipeline from web activity Rest api call, referring to a Synapse pipeline in the same workspace? ?

Question

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

Answer 1

Hi Karthikeya Gadamsetty,

Thank you for posting query in Microsoft Q&A Platform.

This error can occur if the REST API URL is incorrect or pipeline which you are trying is not published.

Below is the documentation link for REST API for Synapse pipeline run. Please check it.

https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/pipeline/create-pipeline-run?tabs=HTTP

Your REST API URL should be as below.

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

Please replace your workspace name and pipeline name in above URL and make sure its POST method.

Also, please make sure the pipeline which you are trying to run, is exists and published to workspace.

Hope this helps.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.