To execute the SQL query using a input value and fetch other columns of a table

Question

Hi Team - I am new to Azure Logic Apps. My intention is to get an input value from user and pass it in request payload to run a select statement in SQL server database table and fetch other required columns.
For Ex: I am getting input of patientgovtidnum from the user and pass this value in http request payload and in execute SQL query action, I am running a select statement to fetch other few details like patient_fullname etc.
I have created a flow for the same and configured all required information. When I tried to test my flow using test payload json parameter, it throws 400 error. Please find attached my complete code and also the error for your kind reference.
Could you please assist me to fix this error.
Azure_LogicApps_Code.txtAzure_LogicApps_Logs.txt

Answer 1

Hi @Sambathkumar, Vinodhkumar (Cognizant),

I have tried below approach and it worked for me:

Initially, I have below sql table ouput for the below query :

SELECT sch_id, stdnt_name FROM rithadmin WHERE aad_num =  009;

Then created a parameter:

stuaadnum with value 009

Now to get/reproduce your error used same design:

Error:

To solve this issue:

Initially clicked on Dynamic values:

Then pressed on stuaadnum as below:

Now it becomes like this:

SELECT sch_id, stdnt_name FROM rithadmin WHERE aad_num =@{parameters('stuaadnum')} 

Output:

Body :

This is how parameters are used in SQL query Action.

---

If this answer was helpful, please click "Accept the answer" and mark Yes, as this can help other community members.

If you have any other questions or are still experiencing issues, feel free to ask in the "comments" section, and I'd be happy to help.