Azure Logic Apps: Read XML from file and Write a JSON with data

0
votes

I'm new in it and trying to understand Azure Logic Apps. I would like to create a LogicApp that:

Looks for new XML-Files

and for each file:

Read the XML

Check if Node "attachment" is present

and for each Attachment:

Read the Filename

Get the File from FTP and do BASE64-encoding

End for each Attachment.

Write JSON File (I have a schema)

DO HTTP-Post to API with JSON file as "application/json"

Is this possible with the Logic-Apps?

1
jsonxmlapiazureazure-logic-apps

1 Answers

0
votes

Yes, you can.

  • Check if a node is present, with xpath expression (e.g. xpath(xml(item()),'string(//Part/@ref)'))
  • For Get File from FTP, use the action FTP - Get File Content
  • Write JSON File, use the action Data Operations - Compose. If you need transformations, you have to use an Integration Account and Maps.
  • Do HTTP Post to API, use de action HTTP