# Microsoft Sql connector

**URL:** https://community.parabola.io/t/microsoft-sql-connector/3060
**Category:** Ask a question
**Created:** [October 31, 2024, 7:50pm UTC](https://community.parabola.io/t/microsoft-sql-connector/3060 "2024-10-31T19:50:16Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Harika\_Kakkireni1](https://avatars.discourse-cdn.com/v4/letter/h/4bbf92/32.png) [@Harika\_Kakkireni1](https://community.parabola.io/u/Harika_Kakkireni1)
#### Post date: [October 31, 2024, 7:50pm UTC](https://community.parabola.io/t/microsoft-sql-connector/3060/1 "2024-10-31T19:50:16Z")

</div>

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

---

<div class="post-metadata">

### Author: ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)
#### Post date: [November 1, 2024, 9:36pm UTC](https://community.parabola.io/t/microsoft-sql-connector/3060/2 "2024-11-01T21:36:32Z")

</div>

Hi @Harika_Kakkireni1 👋

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 `{}`.