Need Help Processing API XML response

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>

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.

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!

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

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

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