+38I have a json array in the structure
[{"name":"A","content":"X"},{"name":"B","content":"Y"},{"name":"C","content":"Z"}]
how do I extract it as the name/content (key/value) pair so that end up with a feature containing the following attributes:
A: X
B: Y
C: Z
In the actual data there are about 40 attributes, so an automatic flatenning of some sort would be prefered.
Best answer by takashi
PythonCaller (the json module)
import json
def processFeature(feature):
for m in json.loads(feature.getAttribute('_json')):
feature.setAttribute(m['name'], m['content'])
XMLXQueyrExtractor (XML Input: None (File is specified in query))
for $m in jn:members(fme:get-json-attribute('_json'))
return fme:set-attribute($m('name'), $m('content')) The XQuery processor "Zorba" bundled with FME supports the JSONiq extension. See these links to learn more about JSONiq.
Hi @jdh
Try using the JSONFragmenter with the following set up:
You can either read in the JSON file directly or set the source attribute to that containing the json string. Set the flatten query result to Yes and then you will have to type out the attributes you would like to expose. This will give you the following result:
+38Hi @jdh
Try using the JSONFragmenter with the following set up:
You can either read in the JSON file directly or set the source attribute to that containing the json string. Set the flatten query result to Yes and then you will have to type out the attributes you would like to expose. This will give you the following result:
Not three features each with attributes name, content.
Not three features each with attributes name, content.
Ah I see, I think a couple more steps are required here.
1. Use a StringConcatenator after the JSONFragmenter to create a new attribute combining name and content
@Value(name):@Value(content)
This should give you the desired result:
PythonCaller (the json module)
import json
def processFeature(feature):
for m in json.loads(feature.getAttribute('_json')):
feature.setAttribute(m['name'], m['content'])
XMLXQueyrExtractor (XML Input: None (File is specified in query))
for $m in jn:members(fme:get-json-attribute('_json'))
return fme:set-attribute($m('name'), $m('content')) The XQuery processor "Zorba" bundled with FME supports the JSONiq extension. See these links to learn more about JSONiq.