Hello Member, I have built a logic app scenario pulling data from SAP Tables and placing it under "compose" with input json(xml(body('Send_message_to_SAP'))) and trying to parse JSON and loading into CSV but not getting output exactly required. This output will be formatted for Email to business further. Any help will be highly appreciated. Regards, Amit L

Hi @amitlalazure503 Welcome to Microsoft Q&A! Thanks for posting the question. The return type will be an object from Send message to SAP action. Compose and Parse JSON action are used for different scenarios in which you are working with JSON format. If the output is JSON object from send message to SAP action then you can use Parse JSON action to create user-friendly fields or tokens for those properties. In the example, they have initialized the variable with JSON object but you can use the output of your action to the Content parameter of Parse JSON action. Please refer to the parse json document for detailed steps on how to use Parse JSON action and use the parse json output to send an email. Feel free to get back to me if you need any assistance.

Logic Apps data in csv or text format

Accepted answer

MayankBargali-MSFT 70,731 Reputation points

2021-01-27T07:14:31.39+00:00

Hi @amitlalazure503

Welcome to Microsoft Q&A! Thanks for posting the question.

The return type will be an object from Send message to SAP action. Compose and Parse JSON action are used for different scenarios in which you are working with JSON format. If the output is JSON object from send message to SAP action then you can use Parse JSON action to create user-friendly fields or tokens for those properties. In the example, they have initialized the variable with JSON object but you can use the output of your action to the Content parameter of Parse JSON action. Please refer to the parse json document for detailed steps on how to use Parse JSON action and use the parse json output to send an email.

Feel free to get back to me if you need any assistance.
Please sign in to rate this answer.
amitlalazure503 26 Reputation points

2021-01-28T06:29:48.113+00:00

Hi @MayankBargali-MSFT
Thank you! And, appreciated for picking up my Question here.
I tried to use Parse JSON here but it's failing while fetching the output, I just need the header under WA section to show in my Email further.

{
"body": {
"RFC_READ_TABLEResponse": {
"@xmlns": "http://Microsoft.LobServices.Sap/2007/03/Rfc/",
"DATA": {
"TAB512": {
"@xmlns": "http://Microsoft.LobServices.Sap/2007/03/Types/Rfc/",
"WA": "001AMIT 11 vhcalnplci_NPL_00 73.111.216.71-serverbook E20210128062208"
}
},
"FIELDS": {

] }, "OPTIONS": "" } }

}
61324-image.png

amitlalazure503 26 Reputation points

2021-01-28T07:00:03.813+00:00

Tried this as well. But no luck

amitlalazure503 26 Reputation points

2021-01-28T07:05:14.85+00:00

It worked by selecting Compose! Thank you again by the way!

MayankBargali-MSFT 70,731 Reputation points

2021-01-28T09:00:58.933+00:00

Hi @amitlalazure503

Glad to know that the issue is resolved now. Feel free to reach out to us in Microsoft Q&A if you need any assistance in the future.

amitlalazure503 26 Reputation points

2021-01-28T17:27:16.547+00:00

Thanks, now I'm stuck on the new problem! this flow picks the first record only. Need to validate how I can generate the array flow, documented scenarios are hard to find btw. just feedback.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Logic Apps data in csv or text format

0 additional answers

Your answer