Forum Discussion
Trigger external process after Stored Procedure completion in Fabric Warehouse
Hi OumaimaRassaa,
I would do this with a pipeline.
Have the pipeline run the stored procedure, and then after the stored procedure avtivity add in a Web activity to call whatever API you want to call.
as tayloramy said pipeline is the best way to orchestrate stuff.
as of now warehouse doesn't support sp_invoke_external_rest_endpoint.it is supported in SQL database in Fabric but it would be cumberstone to build a chain of calls like
WH stp -> SQLDB stp with invoke_rest -> WhateverAPI
pipeline is defenetly the tool to choose.sp_invoke_external_rest_endpoint (Transact-SQL) - SQL Server | Microsoft Learn
hello , Thanks for your reply. Is it possible to do this directly, without using pipelines?
as tayloramy said pipeline is the best way to orchestrate stuff.
as of now warehouse doesn't support sp_invoke_external_rest_endpoint.
it is supported in SQL database in Fabric but it would be cumberstone to build a chain of calls like
WH stp -> SQLDB stp with invoke_rest -> WhateverAPI
pipeline is defenetly the tool to choose.
sp_invoke_external_rest_endpoint (Transact-SQL) - SQL Server | Microsoft Learn