Skip to main content

🗓️ 25032024 1812
📎 #elasticsearch

es_api_cheatsheet

Get Mapping​

GET /{index_name}/_mapping

GET /{index1},{index2}/_mapping

New index​

PUT /otc_user_alert_index

{
  "mappings": {
    "properties": {
      "user_id": {
        "type": "long"
      },
      "created_date": {
        "type": "date",
        "format": "epoch_millis"
      },
      "modified_date": {
        "type": "date",
        "format": "epoch_millis"
      },
      "country_id": {
        "type": "keyword"
      },
      "handled": {
        "type": "boolean"
      },
      "occurrences": {
        "type": "nested",
        "properties": {
          "id": {
            "type": "long"
          },
          "created_date": {
            "type": "date",
            "format": "epoch_millis"
          },
          "modified_date": {
            "type": "date",
            "format": "epoch_millis"
          },
          "handle_type": {
            "type": "integer"
          },
          "type": {
            "type": "integer"
          },
          "metadata": {
            "type": "text"
          }
        }
      }
    }
  }
}

Nested Query​

GET /my-index-000001/_search

{
  "query": {
	"bool": {
		"must": [
			{
				"nested": {
					"path": "occurrences",
					"query": {
						"bool": {
							"must": [
								"terms": {
									"occurrences.type"
								}
							]
						}
					}
				}
			}
		]
	}
  }
}

Query with script​

POST /.../my-index/update/90000460211

{
  "script": {
    "source": "if (ctx._source.occurrences == null) { ctx._source.occurrences = []; } boolean updated = false; for (item in ctx._source.occurrences) { if (item.id == params.occurrence.id) { item.putAll(params.occurrence); updated = true; break; } } if (!updated) { ctx._source.occurrences.add(params.occurrence); }",
    "params": {
      "occurrence": {
        "id": 15,
        "created_date": 1683602203000,
        "modified_date": 1683602203000,
        "user_id": 90000460211,
        "handle_type": 2,
        "type": 1,
        "metadata": "230509111336868",
        "assigneeId": 564563454,
        "handlerId": 123
      }
    }
  },
  "scripted_upsert": true,
  "upsert": {}
}

Nested​

Query with ID​

{
  "query": {
    "bool": {
      "filter": {
        "ids": {
          "values": ["17052708"]
        }
      }
    }
  }
}

Query with ID

References