How to pass parameters in bulk in SQL stored procedure connector in logic app?

Question

While migrating from biztalk to logic app, we have certain stored procedure having 100+ input parameters. In Biztalk, we could send such data to stored procedure via xml schemas but stored procedure of sql connector in logic app only accept it as key values and passing data in each field seems hectic. Is their some way to reuse those xml schemas in logic app to send these parameters in 1 go via xml file?

Answer 1

Hi @Vishwas Patel Thanks for reaching out. BizTalk works on WCF contract for SQL and can convert xml to stored proc params in the background which Logic app can't. As of today we don't have a way to pass parameter to sql acion as xml unless it gets directly passed to stored procedure.

you can leave your feedback in our feedback forum https://feedback.azure.com/d365community/forum/79b1327d-d925-ec11-b6e6-000d3a4f06a4. so that other users who are in need to similar feature can upvote it and PG can take it forward.

Let me know incase of further queries, I would be happy to assist you.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

Answer 2

I finally got a way to pass multiple parameters in 1 go by keeping the database name dynamic, which gives body as parameter name and we can pass the parameters as json object(by converting xml to json), directly to the body.