Azure Synapse Pipeline Rest api with parameter return value

Vedantham, Anand Kumar 0 Reputation points
2023-07-25T16:03:55.54+00:00

Hi,

I am trying to get the return value from Azure Synapse Pipeline with rest api call as response.

I am passing input parameters to the Synapse pipeline, I have a lookup component which is calling the stored procedure and I need to pass the return value of stored procedure as output return value from pipeline.

I am looking for the pipeline return value as response with Synapse pipeline rest api.

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.
5,297 questions
{count} votes

1 answer

Sort by: Most helpful
  1. QuantumCache 20,356 Reputation points
    2023-07-25T22:56:24.9733333+00:00

    Hello @Vedantham, Anand Kumar Welcome to Q&A forum.

    Did you try the Set-Variable-->'Pipeline Return Value' ? of Type 'Expression' ?

    User's image


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.