How to Iterate array of primitives in JSONata

Question

I would like to know how to iterate an array of primitives such as array of int or if it is as a simple array of string.

{
   "printers":[
      "HP-1234",
      "HP-Inkjet"
   ]
}

I would like to iterate the array and do some thing like this:

for( String obj:printers) {
    if(obj.contains("HP")) {
        //do something here
    }
}

How can i do this using JSONata?

Any help will be appreciated!

What is the exact data type of printers? org.json.JSONArray? javax.json.JsonArray? Something else? — mingos
– mingos, Commented Jan 25, 2018 at 0:20
I would like to iterate it through JSONata as I am using the jsonata.js for querying the json scripts — user1477232
– user1477232, Commented Jan 25, 2018 at 9:01

user1477232 · Accepted Answer · 2018-01-25 01:14:48Z

2

I figured out the solution which is as follows:

$map(printers, function($v, $i, $a) {
    $v~>$string()~>$contains("HP")?"HP Priter":$v
})

But since Am invoking the jasonata.js through Nashorn using java, I am not able to get the proper result.

This is what i have done:

        Object resultjson = inv.invokeMethod(expr, "evaluate", inputjson);        
        engine.put("resultjson", resultjson);
        Object result = engine.eval("JSON.stringify(resultjson);");
        System.out.println("Result:" + result);

The output am getting is Result: [object Object] Looking out for pointers to get the result in json format.

Note: I am using jsonata-es5.js as it is compatible with Nashorn

edited Jan 25, 2018 at 1:14

answered Jan 25, 2018 at 1:08

user1477232

4571 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Andrew Coleman Over a year ago

The expression printers.($contains("HP") ? "HP-Printer" : $) will do the same. Note that the dot . operator is an implicit map function.

user1477232 Over a year ago

Thanks a lot Andrew ! This helps. I have a question. Not on this expression but on another expression. Is it possible to convert a string which has a number to number using JSONata? For this JSON "printerId":"0000" when i try printerId~>$number() i get cannot convert a value to number. I understand this is because am trying to convert a string to number, but if i want to do is it possible?

Andrew Coleman Over a year ago

Ah right, $number() doesn't tolerate the leading zeros. Raise an issue on GitHub - this could almost certainly be fixed.

Collectives™ on Stack Overflow

How to Iterate array of primitives in JSONata

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related