LogicApps - Creation an Array with the content of an XML file

Canlers, Marc 1

Hello everybody,

i have to create a sFTP triggered logicapps.
Once a XML file arrives, i need to get the content and create array or variables using the informations from the XML.

For example (in french)
<?xml version="1.0" encoding="ISO-8859-1"?>
<entete><origine>XXXXX</origine><dateCreation>XXXXXX</dateCreation></entete><paramDefaut><contenu><texte>XXXXX</texte></contenu></paramDefaut><listeDestinataires><destinataire id="XXXXX"><contact>XXXXX</contact></destinataire></listeDestinataires>

for exemple: $phonenumber = <contact>

i can only use xpath but i don't find the good expression, using triggerbody or body.

Do you have a clear solution ?

Regards
Marc

MayankBargali-MSFT 70,526 Reputation points

2020-08-24T11:45:41.193+00:00

Hi @Canlers, Marc

I am looking into this and will keep you posted
MayankBargali-MSFT 70,526 Reputation points

2020-08-26T11:31:47.537+00:00

Hi @Canlers, Marc

Can you provide more details on your setup?
I believe you are using this action and this will return the binary data. If your ask is only how you can create the array from XML content then you can leverage the maps to transform the content.

MayankBargali-MSFT 70,526

For example, I have created below .liquid file to transform my XML

XML file:

 <employees>
  <employee>
    <firstname>Jane</firstname>
     <supervisor>be131</supervisor>
     <contact>123</contact>
   </employee>
   <employee>
      <firstname>William</firstname>
      <room>14a</room>
      <contact>1231111</contact>
   </employee>
 </employees>

Liquid File:

{
"ContactNumber":
        [{% JSONArrayFor item in content -%}
            "{{item.employee.contact}}"
        {% endJSONArrayFor -%}],
"FirstNames" : 
        [{% JSONArrayFor item in content -%}
            "{{item.employee.firstname}}"
        {% endJSONArrayFor -%}],
}

MayankBargali-MSFT 70,526 Reputation points

2020-08-27T12:09:05.513+00:00

Hi @Canlers, Marc

Just want to touch base and see if you got a chance to look into my previous comment.

Share via

LogicApps - Creation an Array with the content of an XML file

Your answer