Obtain data from an XML

Help Studio
1

Hi everyone,

I got the response from an API on XML format and I use the “Deserialize XML” activity, then the output for this activity is something like:

20.5677 31/01/2025 20.4497 01/02/2025 20.4497 02/02/2025 20.4497 03/02/2025 20.4497 04/02/2025 20.6068 05/02/2025 ]

So I want to get the value from the node “dato” whith a particular input string in the node “fecha”.

I’m using the following activity:

image

But it always gets only the first value of the node “dato”.

Any suggestions ??

2

Sorry, the response from the Deserialize activity is like the following image:

A snippet of XML data displaying a series of daily exchange rates for Mexican Pesos to US Dollars from January 1, 2025, to January 7, 2025. (Captioned by AI)
A snippet of XML data displaying a series of daily exchange rates for Mexican Pesos to US Dollars from January 1, 2025, to January 7, 2025. (Captioned by AI)467×521 6.99 KB

3

Try this

//Obs[fecha=‘01/02/2025’]/dato

1 Like
Forum Engagement Daily Reports
4

Thanks it works perfectly !!

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.