Forum Discussion
Trigger external process after Stored Procedure completion in Fabric Warehouse
Hello, in Microsoft Fabric Warehouse is it possible to trigger an external process (API/pipeline/integration flow) after a stored procedure finishes or after an insert/update in a table? Are event-based triggers supported, or what architecture is recommended (Pipeline, Eventstream, Activator)?
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
4 Replies
- tayloramy
Super User
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.
hello , Thanks for your reply. Is it possible to do this directly, without using pipelines?
R1k91as 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
