Hi Team, Is there a way to send in dynamic query to pull data using sql connector?
Would also be helpful to know if there is a way to be able to execute stored procedures? Or make use of Common table expressions or declare some constants to be used in select query
Welcome to the community. Unfortunately, our Pull from MS SQL step cannot make dynamic requests since it is a “source” step.
Instead, it may be worth investigating if they offer a REST API to send queries in a cURL format.
If they do, you can use other steps to target or create dynamic data and pass the request through an Enrich with API step. Since this is a “transform” step, it can take inputs from previous steps and insert them as variables into your requests by referencing the column name in curly brackets {}.
