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