Need Help Processing API XML response

Need help APIs
1

Hi Bubble Experts,

I am trying to process an API XML response which has the following format using the Bubble API Connector:

<Name>Apples</Name>
<Amount currencyID=“USD”>1000</Amount>

SS1
SS1558×360 13.7 KB

My key problem is that Bubble’s auto XML to JSON converter is not able to correctly extract out the “1000” value from the 2nd row. Instead, they return “USD” as the data response.

SS2
SS2814×548 19.1 KB

The other data response which is the name of the item ‘Apples’ can be correctly retrieved.

Does anyone know of a way to solve this and enable the integer value 1000 to be extracted?

Thanks!

2

Is that actual data you got from an API response or is that just you testing it? The quotes around the USD aren’t the standard " "double quotes like I did, you have curly/smart quotes “ ”

1 Like
3

It’s the actual double quotes, just that the forum text converts it for some reason

<Name>Apples</Name>
<Amount currencyID="USD">1000</Amount>