How To Call Stored Procedure With MuleSoft

If you would like to understand the basics of MuleSoft, refer to these articles before going next:

• Getting Started MuleSoft
• How To Connect to Azure SQL Database with MuleSoft
• Load Data From S3 Bucket Using MuleSoft S3 Connector

Database Schema and Procs

Stored Proc

Before proceeding further, you must connect to Azure SQL Database and learn how to create and set up a new MuleSoft project. You need to go through this article because I don’t want to do the same duplicate work in this article. Here is the article link:

• How To Connect To Azure SQL Database With MuleSoft

Now let’s pretend the connection is done and the MuleSoft project is setup. Now drag and drop Listener (HTTP) from Mule Palette and provide Display Name, Connector configurations, and Path. I am keeping everything default except changing the port from 8081 to 8082 because 8081 port is already in use for me.

Listener properties

Connector configuration

Now let’s drag and drop the Database> Stored procedure into Message flow from Mule Palette and provide the given properties:

• Display Name – Title of the Database.
• Connector Configuration – Configuration of your Database
• SQL Query Text - Call stored procedure name as we do not use any inline query in this sample.

These are my Connector configuration properties.

All looks good so far. Now let’s drag and drop Transform Message (Core) from Palette to Message flow and setup Output Payload as JSON.

Last but not least, let’s run and deploy the project before testing the output in Postman.

All looks good, the project deployed without any warning or error message. Time to test the output in Postman.

Everything is working perfectly, and the result set is in JSON format.

Conclusion

In this article, we learned how to call SQL Stored Procedure in MuleSoft and get and display data in JSON format.