Hi All, i am reading data from a webservice (creator - xml templater - httpCaller) and the data i receive back is not in the format i expected..... Do i need to play with encoding or something else here ?i have truncated the xml to just a small section included below.i receive:<DocumentElement><Results_x0020_for_x0020__x0027_Index_x003D_survey_x0026_StreetName_x003D_KASHMIR_x0020_RD_x0026_StreetNo_x003D_31_x0027_><Global_x0020_Council_x0020_ID>20060926T154516_3_Rodney</Global_x0020_Council_x0020_ID><Asset_x0020_No.>36848</Asset_x0020_No.><Contract_x0020_No.>3853</Contract_x0020_No.><Contractor>Project Max</Contractor><Date_x0020_Inspected>26/09/2006</Date_x0020_Inspected><Completion_x0020_Status>IC</Completion_x0020_Status>i was expecting more like this below , ie without the "_x0020_" etc valuesDocumentElement>…<Resultsfor'Index=survey&StreetName;=KASHMIR RD&StreetNo;=31’><Global Council ID>20060926T154516_3_Rodney</Global Council ID><Asset No.>36848</Asset No.><Contract No.>3853</Contract No.><Contractor>Project Max</Contractor><Date Inspected>26/09/2006</Date Inspected><Completion Status>IC</Completion Status>Any hints or suggestions on how to remedy this ?Thanks Steve

Solved

xml formatting or encoding

10 years ago
May 25, 2016 2:01 PM UTC
8 replies
133 views

goatboy

Hi All, i am reading data from a webservice (creator - xml templater - httpCaller) and the data i receive back is not in the format i expected..... Do i need to play with encoding or something else here ?

i have truncated the xml to just a small section included below.

i receive:

<DocumentElement>
<Results_x0020_for_x0020__x0027_Index_x003D_survey_x0026_StreetName_x003D_KASHMIR_x0020_RD_x0026_StreetNo_x003D_31_x0027_>
<Global_x0020_Council_x0020_ID>20060926T154516_3_Rodney</Global_x0020_Council_x0020_ID>
<Asset_x0020_No.>36848</Asset_x0020_No.>
<Contract_x0020_No.>3853</Contract_x0020_No.>
<Contractor>Project Max</Contractor>
<Date_x0020_Inspected>26/09/2006</Date_x0020_Inspected>
<Completion_x0020_Status>IC</Completion_x0020_Status>

i was expecting more like this below , ie without the "_x0020_" etc values

DocumentElement>
…
<Resultsfor'Index=survey&StreetName;=KASHMIR RD&StreetNo;=31’>
<Global Council ID>20060926T154516_3_Rodney</Global Council ID>
<Asset No.>36848</Asset No.>
<Contract No.>3853</Contract No.>
<Contractor>Project Max</Contractor>
<Date Inspected>26/09/2006</Date Inspected>
<Completion Status>IC</Completion Status>

Any hints or suggestions on how to remedy this ?

Thanks Steve

Best answer by jdh

Try a StringReplacer

Text to Match: _x00([0-9a-z]*)_

Replacement Text: %\\1

Followed by a TextDecoder with the Encoding Type set to URL (Percent Encoding)

View original

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

takashi
10 years ago
May 25, 2016 2:38 PM UTC

Hi @goatboy, how about using the StringPairReplacer?

Replacement Pairs: _x0020_ " " _x0026_ & _x0027_ ' _x003D_ =

Note: The resulting text will not be a valid XML document any longer. i.e. XML transformers cannot be used to parse that.

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Upvote

goatboy
Author
10 years ago
May 25, 2016 8:02 PM UTC

Hi @goatboy, how about using the StringPairReplacer?

Replacement Pairs: _x0020_ " " _x0026_ & _x0027_ ' _x003D_ =

Note: The resulting text will not be a valid XML document any longer. i.e. XML transformers cannot be used to parse that.

Thanks @takashi . Any idea why the feed would be coming thru with these codes? I am hoping to avoid replacing strings. As you mentioned, i am still keen to use the XML tools to parse the data later in the workbench.