Hi All, i have been banging my head against this for a while. Im trying to parse an api call response I get ( XML returned) . I have tried Flattening it. I have tried Fragmenting it, I have tried swearing at it. None of the things I have tried have worked. I don't really understand how this data is structured. Its nested I think, with something like tuples??? there is a Name, Number and Text for each attribute?? Any help or direction appreciated. Happy to learn. I'm trying to return the "number" value of NZTM 2000 Northing and NZTM 2000 Easting as attributes... Many Thanks for your suggestions.
Solved
Parse XML response (Tuple??)
+5- Contributor
- 7 replies
Best answer by ebygomm
If you are just trying to get those two values - NZTM 2000 Northing and NZTM 2000 Easting i would probably use the XMLXQueryExtractor
for $ x in //CustomField
where $x[matches(Name,"NZTM 2000.*")]
return
{fme:set-attribute($x/Name,$x/Number/text())}Expose NZTM 2000 Easting, NZTM 2000 Northing under Expose Attributes
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.
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.
+44- Influencer
- 3422 replies
- Best Answer
If you are just trying to get those two values - NZTM 2000 Northing and NZTM 2000 Easting i would probably use the XMLXQueryExtractor
for $ x in //CustomField
where $x[matches(Name,"NZTM 2000.*")]
return
{fme:set-attribute($x/Name,$x/Number/text())}Expose NZTM 2000 Easting, NZTM 2000 Northing under Expose Attributes
+60- 2937 replies
This can de done by the XmlFragmenter.
Fragment path: Response/CustomFields/CustomField
Enable Flattening = Yes
Expose attributes: UUID, Name Number.
Then filter only the features with the oordinates, rename the Number attributes, and merge them together with an aggregator.
+5- Contributor
- 7 replies
If you are just trying to get those two values - NZTM 2000 Northing and NZTM 2000 Easting i would probably use the XMLXQueryExtractor
for $ x in //CustomField
where $x[matches(Name,"NZTM 2000.*")]
return
{fme:set-attribute($x/Name,$x/Number/text())}Expose NZTM 2000 Easting, NZTM 2000 Northing under Expose Attributes
Many Thanks @ebygomm just what i needed and i learnt about the xmlxQueryExtractor and syntax at the same time, great!!.I do like learning new stuff!!
I appreciate your help
and thanks for your idea too @nielsgerrits .
Steve