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