XML and SQL stored procedure in Logic Apps
Share
Services
We have introduced some new XML support in the Logic Apps feature of Azure App Service. We have two new workflow functions of @xml() and @xpath() so that you can work with XML natively within a workflow. @xml() will convert a string or JSON object to XML. For example, if the body of your trigger is a JSON object of:{"foo": "bar"}@xml(triggerBody()) will become <foo>bar</bar>@xpath takes XML and executes an XPath query. Full documentation and examples for both of these functions (and others) can be found on the [Workflow definition language](https://msdn.microsoft.com/library/azure/mt643789.aspx) page.In addition, the SQL Azure connector supports executing a stored procedure. Executing a stored procedure will return the following to the Logic Apps engine:
* ResultSets: An array of tables for each statement result in the stored procedure. (For example, if you have three SELECT \* in the stored procedure, you will have three tables in the ResultSets array.)
* ReturnCode: The integer returned if you specify a return value in the stored procedure.
* OutputParameters: The value of a parameter that you mark as "out" in your stored procedure.
* App Service
* Features
* [ App Service](https://azure.microsoft.com/en-gb/products/app-service/)
What else is happening at Microsoft Azure?
Read update
Services
Share
Generally Available: Storage account default maximum request rate limit increase to 40,000 requests per second
December 12th, 2024
Services
Share
Read update
Services
Share
Generally Available: Regional Disaster Recovery by Azure Backup for AKS
November 22nd, 2024
Services
Share
Generally Available: Enhancements on Azure Container Storage for performance, scalability, and operational insights
November 19th, 2024
Services
Share