How to extract specific values from an XML response in an AppSheet Webhook

Hi, I'm working with a webhook in AppSheet to integrate with a SOAP service. I get a response in XML format, but I'm having trouble accessing the specific "GuideNumber" value within the response. Here's an example of the response I get:
Msant77s_0-1726111122669.png

 


 



Msant77s_0-1726111023550.png

 


Msant77s_2-1726110783032.png

Is there any way to access this value without having to use an appscript??
Directly with the webhook return values? I've tried many ways and always get a conversion error

 


0 3 171
3 REPLIES 3

I suppose you have read the Webhooks return value limitations ..

TeeSee1_0-1726118348850.png

 

Hi, thanks for the answer!....Yes, I've read it!
But I've been getting return values ​​in XML for a while now!
It's just that this has a different or nested structure, something similar to what happens with nested JSON!


@Msant77s wrote:

But I've been getting return values ​​in XML for a while now!


Exactly why the bot is failing. A response has to be in a JSON format for AppSheet to be able to parse as  the document says. There is no way around it now AFIK.

 

Top Labels in this Space