Extracting Data from XML in Workflow Action

Ask us anything How do I?
1

Hi all

I have a workflow that is calling an external API and receiving an XML response. I’m trying to figure out how I extract certain fields from the XML response and save each of them as a variable. You can see the XML response is just a big blob of text. The values I need are inside the tags <Zip5>, <City> and <State>. I’ve been playing around with various Formulas but can’t figure out the right one to use. Any suggestions please?

I think I need to first use createObject()?

image
image1730×1434 283 KB

2

Neat Problem! I made a quick video showing how to parse XML in weweb (using JS instead of the formula)

We work on problems like this part of our “hardest 5%” in our daily office hours and forum at Statechange Pro.

2 Likes
3

Amazing stuff thanks @raydeck! Thanks for going to all the effort to record a video, really appreciate it!

This worked perfectly for me! Thanks again. I will be checking our your office hours, thanks.

4

Also, adding to the roadmap that we need to interpret XML automatically :laughing:

In the meantime, @raydeck’s solution is the best way to go :raised_hands:

2 Likes
5

Hi!

We have update for this feature?

Thanks for all!