I have a complicated json object that I would like to count the number of elements in one of it's child objects. Given the size and complexity of the original json, I would like to avoid flattening it and using the listElementCounter.
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.
- 7843 replies
Try using the XMLXQueryExtracter with the JSONiq extension. This may be a kind of hack, but works.
Example:
A Complex JSON Text (value of a feature attribute called "_json")
{
"a" : 100,
"b" : {
"c" : [
{"x" : 1},
{"x" : 2},
{"x" : 3}
],
"d" : 200
}
}XQuery expression that returns the number of elements in the array "c".
jn:size(fme:get-json-attribute("_json")("b")("c"))XMLXQueryExtractor Parameters
+11- Contributor
- 155 replies
Great, tnx for the info @Takashi Iijima; Was looking for the same thing today 😃
+20- Enthusiast
- 154 replies
What if the element attribute "x" has duplicated values and I want to count unique Xs only?
- 7843 replies
What if the element attribute "x" has duplicated values and I want to count unique Xs only?
Hi @Renato Salvaleon , if I understand your requirement correctly, this expression returns your desired result.
count(
distinct-values(
for $e in jn:members(fme:get-json-attribute("_json")("b")("c"))
return $e("x")
)
)
+20- Enthusiast
- 154 replies
Hi @Renato Salvaleon , if I understand your requirement correctly, this expression returns your desired result.
count(
distinct-values(
for $e in jn:members(fme:get-json-attribute("_json")("b")("c"))
return $e("x")
)
)
Thanks @Takashi Iijima that got me the values I was looking for. It also saved me a good bit of process time by taking away four transformers and exposing my list attributes and exploding the features.