Scripted field issue

[Eric_Yin (Eric Yin Z)]

Dear ELK developers,

I would like to ask if there is any feature to involve putting the scripted field by txt or by other format to import the scripted field since we have thounsands of KPIs and we involve thounsands of formula(scripted fields) to calculate based on those fields.

May I know where the scripted field in kibana page stored? it is stored into the ES DB or stored into some configuration file, I failed to find my added scripted field on the backend server. Please kindly adivse

[bhavyarm]

Hi Eric,

Scripted fields are stored in index patterns in .kibana index.

Thanks,
Bhavya

[Eric_Yin (Eric Yin Z)]

Hello,

Thanks for your reply.
curl -XGET 'http://127.0.0.1:9200/.kibana/_search?pretty'
I can find the scripted field with other field/dashboard definition from .kibana. May I know how to update this index by add new scripted field from the backend restful API? Is there any example?

{"name":"test_scripted_field","type":"number","count":0,"scripted":true,"script":"doc['EUtranCellFDD.pmRrcConnMax'].value","lang":"painless","indexed":false,"analyzed":false,"doc_values":false,"searchable":true,"aggregatable":true}

I just would like to read an formula text and tranform it into the .kibana automatically instead of add them mannually one by one. I guess if I create a new index paterns, there might be a way to copy the pervious index configuration(dashabord,scripted field ..) into a new one through restful API. Kindly advice, thank you very much