Hi, is it supported to use JSONEXTRACTSCALAR function in the transformConfigs?

Hi No that is not supported but you can use

jsonPath

function which does a similar thing. If you require a specific result data type you can use its variations such as

jsonPathLong

,

jsonPathDouble

etc.

@User Thanks. Another question, does jsonPath supports regular expression?

Not sure. You can test out here - https://jsonpath.herokuapp.com we use jayway jsonpath in our code.

Got it. Thanks, Kartik.