How to manage(api) static lookup map for a field in an Index pattern

OpenSearch Dashboards
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
2.11

Describe the issue:
Manual entry of static lookup key/values per IndexPattern is huge effort. Looking to use bulk/centralised management of reference data. Or even an API instead of the Dashboards UI Console. We have up to 200 of key values pairs to enter for a static lookup field and there are several index patterns with the same field requiring a static lookup. This is hard to manage using just the UI.

Proposal: Allow independent management (bulk/api upload) of static lookup key/value maps (independent of IndexPatterns). Allow IndexPattern fields to reference one of these static lookup maps.

Ideally the static lookup map would be reuseable across other index patterns.

Configuration:

Relevant Logs or Screenshots:

image
image824×1094 51.8 KB

2

Maybe you can try using saved objects API of OSD to create index pattern:

curl -X POST api/saved_objects/index-pattern/my-pattern  -H 'osd-xsrf: true' -H 'Content-Type: application/json' -d '
{
  "attributes": {
    "title": "my-pattern-*"
  }
}'
3

Thanks Gaobinlong, I should have mentioned that I am using Opensearch in AWS (ver 2.7 currently). I did try but I cant seem to access the saved_objects endpoint via devtools.

Is it intended to be available via devtools? Is it available directly in ver 2.7 supported by AWS?