when you have escape characters in the string the liquid template fails

I came across a scenario, where I got bad request error when I have double quotes(“) in my incoming string property while performing json to json transforming using liquid template. When there is not double quotes it works as expected.   My Liquid Template: performing a simple append of first name and last name {    “fullName”:… Read more

Logic apps Service bus connector not honoring Maximum message count

You might come across a scenario where you dont receive the batch of messages configured under maximum message count property in your logic app service bus connector setting. In this example, i have configured the maximum message count as 20 but still I recieved only 1 or 2 messages every time even when i had… Read more

Original Run Vs Resubmitted Run in Logic apps

In Logic app, you would often come across a scenario to differentiate between the original run and if the run is resubmitted via the Logic app portal(or Rest API) the Resubmitted Runs reuse Client Tracking ID of the Original Run, so they can be correlated. So IF RUNID= ClientTrackingID THEN Original RUN IF RUNID ≠… Read more

Logic App: Json serialization issue when receiving message from Service Bus

When parsing message received by logic App from Service, got the error “ InvalidJSON. The ‘content’ property of actions of type ‘ParseJson’ must be valid JSON. The provided value ‘@string3http://schemas.microsoft.com/2003/10/Serialization/�>{ “Field1”: “Test1”, “Field2”: “Test2”, “Field3”: “Test3″ }’ cannot be parsed: ‘Unexpected character encountered while parsing value: @. Path ”, line 0, position 0.’.” We have the… Read more

xml resultset from SQL store procedure is splitt into multiple nodes in Logic Apps

I have a stored procedure which returns an XML  result set. when I execute the stored procedure, the output is a single XML as below. CREATE PROCEDURE [dbo].[TESTSP] AS BEGIN SELECT * from testtable FOR XML AUTO END   The output is a single xml object as below. <testtable ID=”1″ Detail=”testdata  ” /><testtable ID=”1″ Detail=”testdata … Read more

Logic Apps : Blob name is null or empty

Recently when working with Azure blob Storage Action :  Extract Archive to Folder I faced the error “Blob name is null or empty”. Host { “api”: { “runtimeUrl”: “https://logic-apis-westeurope.azure-apim.net/apim/azureblob” },     Method : post Path : /datasets/default/extractFolderV2 Queries: { “destination“: “/testoutput“, “source“: “/test/shashiwebsite_201506011619.zip” } Output Body : { “status”: 400, “message”: “Blob name is… Read more