XML Helper
The XML Helper converts XML to dictionaries or vice versa. It connects XML based APIs to the integration platform.
XML helper
To convert a dictionary to XML, e.g. for use in the REST helper, use the Convert dictionary to XML action. Just reference the object directly, without {{}}
XML Helper Convert dictionary to XML
<?xml version="1.0" encoding="utf-8"?>
<Example id="somevalue" type="text">
<Content>Some Text</Content>
</Example>
You need to include the attributes in the dictionary with an
@ prefix, e.g.:{
"Example": {
"@id": "somevalue",
"@type": "text",
"Content": "Some Text",
}
}
To retrieve and XML file or endpoint, just include the internal Locoia reference or the external URL, like in the below screenshot the VAT-ID check of the EU commission. If your endpoint requires authentication, please create this first and then select it under Connector Auth.
Note: Since XML responses are sometimes "not so clean", please reference data as per the below. This is the better approach compared to JSONPath-notation.
myOldErp["users"]["first_name"]
If a XML only contains one entry of an object it will be outputes as a dictionary in JSON. However, if it has multiple entries of an object it will be outputed as a list of dictionaries. To check the output type dynamically in a flow you you use the Jinja
mapping test, e.g.:{% if dic1 is mapping %}"Dict"{% else %}"List"{% endif %}
Sometimes you may want to drop the namespaces of an existing XML. This can be done with the Drop Namespaces action.
Last modified 1yr ago