topic Re: How to parse simple XML-response from PostXML/PostText in ThingWorx Developers

How to parse simple XML-response from PostXML/PostText

Pasi_Ojala — Wed, 13 Sep 2017 08:30:04 GMT

Hi!

I'm trying to post a device serialnumber to remote URL (not Thingworx) with PostXML-function and get a response with some device details (see below).

By using var xmlDocument = Resources["ContentLoaderFunctions"].PostText(params) I get the following response nicely as string:

<?xml version="1.0" encoding="UTF-8"?>

</DeviceData>

<Description1 Lang="EN">Development engine</Description1>

</ItemData>

</Device>

</Devices>

But if I try to do anything with PostXML (e.g. xmlDocument to Infotable) it seems that I do not get any XML data to Thingworx. I wonder, whether PostXML can be used in a case like this to get result as XML object? Am I missing something in PostXML usage?

Quite a simple result so I could even use some sort of light-weight parser inside service? Any hints?

Br,

Pasi

Re: How to parse simple XML-response from PostXML/PostText

PaiChung — Wed, 13 Sep 2017 12:49:00 GMT

Should work, if this is what you get back when you do PostText, then your PostXML should be able to get this back as an XML object.

So if you had var myXML = Resources.["ContentLoaderFunctions"].PostXML

Then you should be able to get information from myXML.Devices.Total

Re: How to parse simple XML-response from PostXML/PostText

Pasi_Ojala — Thu, 14 Sep 2017 07:55:52 GMT

PostText delivers the content nicely. PostXML just like you said, but myXML.Devices.Total is empty. Any idea where to start hunting the reason for this behavior? Could it be that content-type is a problem for Thingworx? Using Postman I see that the content-type for response is text/xml; charset=utf-8.

Re: How to parse simple XML-response from PostXML/PostText

PaiChung — Thu, 14 Sep 2017 13:00:39 GMT

Do you have the UTF-8 option configured in the Java opts?

Re: How to parse simple XML-response from PostXML/PostText

Pasi_Ojala — Fri, 15 Sep 2017 09:34:34 GMT

You mean in the tomcat/catalina startup?

Re: How to parse simple XML-response from PostXML/PostText

CarlesColl — Fri, 15 Sep 2017 10:14:55 GMT

Hi Pasi,

Don't lose time with PostXML, use PostText and then if you want you can try to parse to XML the content you receive with new XML(postTextResult); or alike.

Just my recommendation,

Carles.

Re: How to parse simple XML-response from PostXML/PostText

Pasi_Ojala — Fri, 15 Sep 2017 17:30:38 GMT

Thanks. I will check the encoding issue first and if it does not help, continue with building the case with posttext.