Defining an array of json docs in Elasticsearch Painless Lab

Question

I'm trying to define some docs in ES Painless Lab, to test some logic in Painless Lab, before running it on the actual index, but can't figure out how to do it, and the docs are not helping either. There is very little documentation on the actual syntax and it's not much help for someone with no Java background.

If I try to define a doc like this:

def docs = [{ "id": 1, "name": "Apple" }];

I get an error:

Unhandled Exception illegal_argument_exception

invalid sequence of tokens near ['{'].

Stack:
[
  "def docs = [{ \"id\": 1, \"name\": \"Apple ...",
  "          ^---- HERE"
]

If I want to do it the Java way:

String message;
JSONObject json = new JSONObject();

json.put("test1", "value1");

message = json.toString();

I'm also getting an error:

Unhandled Exception illegal_argument_exception

invalid declaration: cannot resolve type [JSONObject]

Stack:
[
  "... ring message;\nJSONObject json = new JSONObject();\n ...",
  "                             ^---- HERE"
]

So what's the proper way to define an array of json objects to play with in Painless Lab?

orszaczky · Accepted Answer · 2021-09-15 10:45:01Z

0

After more experimenting, I found out that the docs can be passed in the parameters tab as:

{
  "docs": [
    { "id": 1, "name": "Apple" },
    { "id": 2, "name": "Pear" },
    { "id": 3, "name": "Pineapple" }
  ]
}

and then access it from the code as

def doc = params.docs[1];
return doc["name"];

I'd be still interested how to define an object or array in the code itself.

answered Sep 15, 2021 at 10:45

orszaczky

16.2k10 gold badges51 silver badges57 bronze badges

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

1 Comment

Val Over a year ago

Here you can find sample code for arrays and maps/objects

Collectives™ on Stack Overflow

Defining an array of json docs in Elasticsearch Painless Lab

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related