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

Vishwas Patel 1 Reputation point
2022-09-15T12:36:58+00:00

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?

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
364 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,133 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. JananiRamesh-MSFT 27,176 Reputation points
    2022-09-16T18:25:32.233+00:00

    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.

    1 person found this answer helpful.

  2. Vishwas Patel 1 Reputation point
    2022-10-26T06:17:40.13+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.