Logic Apps data in csv or text format

amitlalazure503 26 Reputation points
2021-01-26T21:35:32.35+00:00

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.

60620-image.png

Any help will be highly appreciated.

Regards,
Amit L

SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
120 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,964 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,288 questions
0 comments No comments
{count} votes

Accepted answer
  1. MayankBargali-MSFT 69,946 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.


0 additional answers

Sort by: Most helpful