Link Search Menu Expand Document Documentation Menu
Documentation

You're viewing version 2.17 of the OpenSearch documentation. This version is no longer maintained. For the latest version, see the current documentation. For information about OpenSearch version maintenance, see Release Schedule and Maintenance Policy.

Create or update stored script

Introduced 1.0

Creates or updates a stored script or search template.

For additional information about Painless scripting, see:

Path parameters

Parameter Data type Description
script-id String Stored script or search template ID. Must be unique across the cluster. Required.

Query parameters

All parameters are optional.

Parameter Data type Description
context String Context in which the script or search template is to run. To prevent errors, the API immediately compiles the script or template in this context.
cluster_manager_timeout Time Amount of time to wait for a connection to the cluster manager. Defaults to 30 seconds.
timeout Time The period of time to wait for a response. If a response is not received before the timeout value, the request fails and returns an error. Defaults to 30 seconds.

Request body fields

Field Data type Description
script Object Defines the script or search template, its parameters, and its language. See Script object below.

Script object

Field Data type Description
lang String Scripting language. Required.
source String or Object Required.

For scripts, a string with the contents of the script.

For search templates, an object that defines the search template. Supports the same parameters as the Search API request body. Search templates also support Mustache variables.

Example request

The following example requests uses an index called books with the following documents:

{"index":{"_id":1}}
{"name":"book1","author":"Faustine","ratings":[4,3,5]}
{"index":{"_id":2}}
{"name":"book2","author":"Amit","ratings":[5,5,5]}
{"index":{"_id":3}}
{"name":"book3","author":"Gilroy","ratings":[2,1,5]}

Creating a painless script

The following request creates the Painless script my-first-script. It sums the ratings for each book and displays the sum in the output.

PUT _scripts/my-first-script
{
  "script": {
      "lang": "painless",
      "source": """
          int total = 0;
          for (int i = 0; i < doc['ratings'].length; ++i) {
            total += doc['ratings'][i];
          }
          return total;
        """
  }
}

The example above uses the syntax of the Dev Tools console in OpenSearch Dashboards. You can also use a curl request.

The following curl request is equivalent to the previous Dashboards console example:

curl -XPUT "http://opensearch:9200/_scripts/my-first-script" -H 'Content-Type: application/json' -d'
{
  "script": {
      "lang": "painless",
      "source": "\n          int total = 0;\n          for (int i = 0; i < doc['\''ratings'\''].length; ++i) {\n            total += doc['\''ratings'\''][i];\n          }\n          return total;\n        "
  }
}'

See Execute Painless stored script for information about running the script.

Creating or updating a stored script with parameters

The Painless script supports params to pass variables to the script.

The following request creates the Painless script multiplier-script. The request sums the ratings for each book, multiplies the summed value by the multiplier parameter, and displays the result in the output:

PUT _scripts/multiplier-script
{
  "script": {
      "lang": "painless",
      "source": """
          int total = 0;
          for (int i = 0; i < doc['ratings'].length; ++i) {
            total += doc['ratings'][i];
          }
          return total * params['multiplier'];
        """
  }
}

Example response

The PUT _scripts/my-first-script request returns the following field:

{
  "acknowledged" : true
}

To determine whether the script was successfully created, use the Get stored script API, passing the script name as the script path parameter.

350 characters left

Have a question? .

Want to contribute? or .