I have a simple JSON { "customers": [ { "id": "XYZ-ABC-DEF", "data": { "locations": [ { "location_id": 1, "location_name": "Main", "location_attr": "blue" }, { "location_id": 2, "loca…

[image] bogorad: So it looks like a limitation :frowning: Just stumbled upon your jsonata riddle. Here is the solution I think: customers[][data.locations.location_attr[$="blue"]!=[]] you can check it with following url: https://try.jsonata.org/LimnK1l7D Explanation: It returns all cust…

[image] bogorad: customers.data.locations[location_attr = "blue"] What about this: customers.data.locations[location_attr = "blue"].$$ And possibly: customers.data.locations[location_attr = "blue"].$$.customers.id To only get the id. Please, don't ask for an explanation... but $$ and $ a…

Thanks! Your suggestion looked promising, but matches the whole structure :frowning: I need only the customer with the attribute.

So it looks like a limitation :frowning: I had to get rid of embedded structures and add redundancy to the data.

Thank you so much! So it looks like this '$' is indeed the magic bullet.

Node-RED

Node-RED Forum

JSONata - am I missing something?

General

greengolfer 29 October 2020 20:15 5

Using your json, what exact output do you need?

Topic		Replies	Views
More jsonata array filtering General jsonata	21	430	1 May 2023
[Solved] Jsonata function help General	4	429	26 September 2019
Selec a value from a variable key General	3	295	17 December 2020
Searching for array entries in jsonata General	3	414	19 May 2021
JSON Filtering ID and plot the Values General	8	1185	30 September 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

JSONata - am I missing something?

Related topics