I have an API call that returns XML as a response, however, I don't know how to use this response in Flutterflow. I would like to know if there is any way to transform the response from this call into JSON.
If anyone can help me, I would be very grateful.
Below are the call and response XML;
API URL:
https://api.lomadee.com/api/lomadee/reportTransaction?publisherId=22972277&token=dGhlcmFwbGFjZS5hcHBAZ21haWwuY29tOkBDZHYzMDExMDA=&startDate=01082022&endDate=01102022&eventStatus=1
XML response
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<result xmlns="urn:lomadee">
<details>
<timestamp>2023-11-15 14:54:59</timestamp>
<code>200</code>
<elapsedTime>0</elapsedTime>
<message>Success</message>
<status>Success</status>
</details>
<item>
<date>22/08/2022</date>
<currency>BRL</currency>
<commission>12.66</commission>
<site>
<siteId>34387067</siteId>
<siteName>Instagram: blelbee</siteName>
</site>
<advertiser>
<advertiserId>6342</advertiserId>
<advertiserName>Swift</advertiserName>
</advertiser>
<events>
<event>
<eventId>26520</eventId>
<eventName>Vendas Swift</eventName>
<eventType>Sale</eventType>
<commission>12.66</commission>
<gmv>258.33</gmv>
</event>
</events>
<application>
<applicationId>7897</applicationId>
<applicationName>Lomadeezador Widget Dashboard</applicationName>
</application>
<gmv>258.33</gmv>
<transactionCode>1256183243808</transactionCode>
<transactionId>40803804</transactionId>
<statusId>1</statusId>
<statusName>APPROVED</statusName>
<processedDate>31/08/2022</processedDate>
<clickDate>22/08/2022</clickDate>
<checkoutDate>22/08/2022</checkoutDate>
</item>
<item>
<date>24/08/2022</date>
<currency>BRL</currency>
<commission>6.24</commission>
<site>
<siteId>34160826</siteId>
<siteName>Theraplace</siteName>
</site>
<advertiser>
<advertiserId>5632</advertiserId>
<advertiserName>Americanas</advertiserName>
</advertiser>
<events>
<event>
<eventId>25632</eventId>
<eventName>Livros</eventName>
<eventType>Sale</eventType>
<commission>6.24</commission>
<gmv>180.40</gmv>
</event>
</events>
<application>
<applicationId>8118</applicationId>
<applicationName>Publisher Plugin</applicationName>
</application>
<gmv>180.40</gmv>
<transactionCode>02-968745858:296874585801:5710793201</transactionCode>
<transactionId>40811453</transactionId>
<statusId>1</statusId>
<statusName>APPROVED</statusName>
<processedDate>31/08/2022</processedDate>
<clickDate>24/08/2022</clickDate>
<checkoutDate>24/08/2022</checkoutDate>
</item>
<item>
<date>22/09/2022</date>
<currency>BRL</currency>
<commission>6.92</commission>
<site>
<siteId>34160826</siteId>
<siteName>Theraplace</siteName>
</site>
<advertiser>
<advertiserId>6342</advertiserId>
<advertiserName>Swift</advertiserName>
</advertiser>
<events>
<event>
<eventId>26520</eventId>
<eventName>Vendas Swift</eventName>
<eventType>Sale</eventType>
<commission>6.92</commission>
<gmv>133.50</gmv>
</event>
</events>
<application>
<applicationId>7897</applicationId>
<applicationName>Lomadeezador Widget Dashboard</applicationName>
</application>
<gmv>133.50</gmv>
<transactionCode>1263482656342</transactionCode>
<transactionId>42679220</transactionId>
<statusId>1</statusId>
<statusName>APPROVED</statusName>
<processedDate>31/10/2022</processedDate>
<clickDate>22/09/2022</clickDate>
<checkoutDate>22/09/2022</checkoutDate>
</item>
</result>