Skip to main content
  • EN

Hi,

I think I know the answer is "can't do this in FME yet", but thought of asking anyway 🙂 Is there a syntax for constructing a predicate in JSON Query when used in a JSONExtractor or JSONFragmenter transformer? Basically I'm after getting to the data within complex JSON structures quicker and avoid having to fragment/flatten everything and then filter afterwards. Attached is an example: with a predicate, one would be able to get to the proper "Food" object in the array based on the predicate "Type"="Fruit", instead of having to flatten the whole thing, testing and filtering, then exploding again. Assuming this is not really possible, I also wrote a broader post in the Ideas section. Thanks.

That would be helpful to have, but from that documentation it appears that it is a function of a "[JSONata is a lightweight] query and transformation language for JSON data"

So safe would either have to build their own tools/functions/transformers to achieve similar results or license/include that language.

 

Regardless, have a thumbs up on your idea 👍

That would be helpful to have, but from that documentation it appears that it is a function of a "[JSONata is a lightweight] query and transformation language for JSON data"

So safe would either have to build their own tools/functions/transformers to achieve similar results or license/include that language.

 

Regardless, have a thumbs up on your idea 👍

Thanks, you're absolutely right. I thought there was some kind of standard way to do JSON querying. Maybe I should have made reference to JSONPath perhaps...there seems to be definite room for improvement here, especially if you are using FME heavily to interact with web services.

Reply


Community Stats

30,163
Posts
114,501
Replies
37,815
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.