Copy const response = await fetch ( '<Your-Host-IP>:3000/datasources/v1/create' , {
method : 'POST' ,
headers : {
"Content-Type" : "application/json"
} ,
body : JSON .stringify ({
"dataset_id" : "obsrv-telemetry-events" ,
"ingestion_spec" : {
"type" : "kafka" ,
"spec" : {
"dataSchema" : {
"dataSource" : "obsrv-telemetry-events" ,
"dimensionsSpec" : {
"dimensions" : [
{
"type" : "string" ,
"name" : "fromDate"
} ,
{
"type" : "string" ,
"name" : "toDate"
} ,
{
"type" : "string" ,
"name" : "tes"
} ,
{
"type" : "string" ,
"name" : "uid"
} ,
{
"type" : "string" ,
"name" : "mobile"
} ,
{
"type" : "string" ,
"name" : "ip"
} ,
{
"type" : "string" ,
"name" : "ipv6"
} ,
{
"type" : "boolean" ,
"name" : "flags_ex_processed"
} ,
{
"type" : "boolean" ,
"name" : "flags_pp_validation_processed"
} ,
{
"type" : "boolean" ,
"name" : "flags_pp_duplicate_skipped"
} ,
{
"type" : "boolean" ,
"name" : "flags_device_denorm"
} ,
{
"type" : "boolean" ,
"name" : "flags_user_denorm"
} ,
{
"type" : "boolean" ,
"name" : "flags_loc_denorm"
} ,
{
"type" : "string" ,
"name" : "derivedlocationdata_district"
} ,
{
"type" : "string" ,
"name" : "derivedlocationdata_from"
} ,
{
"type" : "string" ,
"name" : "derivedlocationdata_state"
} ,
{
"type" : "string" ,
"name" : "mid"
} ,
{
"type" : "string" ,
"name" : "type"
} ,
{
"type" : "string" ,
"name" : "actor_type"
} ,
{
"type" : "string" ,
"name" : "actor_id"
} ,
{
"type" : "string" ,
"name" : "edata_type"
} ,
{
"type" : "string" ,
"name" : "edata_query"
} ,
{
"type" : "string" ,
"name" : "edata_filters_slug"
} ,
{
"type" : "boolean" ,
"name" : "edata_filters_isTenant"
} ,
{
"type" : "string" ,
"name" : "edata_filters_make_type"
} ,
{
"type" : "string" ,
"name" : "edata_topn[*]_id"
} ,
{
"name" : "edata_items"
} ,
{
"type" : "array" ,
"name" : "userdata_subject"
} ,
{
"type" : "string" ,
"name" : "userdata_district"
} ,
{
"type" : "string" ,
"name" : "userdata_usersubtype"
} ,
{
"type" : "array" ,
"name" : "userdata_grade"
} ,
{
"type" : "string" ,
"name" : "userdata_usersignintype"
} ,
{
"type" : "string" ,
"name" : "userdata_usertype"
} ,
{
"type" : "string" ,
"name" : "userdata_userlogintype"
} ,
{
"type" : "string" ,
"name" : "userdata_state"
} ,
{
"type" : "string" ,
"name" : "@timestamp"
} ,
{
"type" : "string" ,
"name" : "devicedata_statecustomcode"
} ,
{
"type" : "string" ,
"name" : "devicedata_country"
} ,
{
"type" : "string" ,
"name" : "devicedata_iso3166statecode"
} ,
{
"type" : "string" ,
"name" : "devicedata_city"
} ,
{
"type" : "string" ,
"name" : "devicedata_countrycode"
} ,
{
"type" : "string" ,
"name" : "devicedata_state"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_idisk"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_webview"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_os"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_scrn"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_sims"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_cpu"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_id"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_camera"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_edisk"
} ,
{
"type" : "string" ,
"name" : "devicedata_devicespec_make"
} ,
{
"type" : "string" ,
"name" : "devicedata_statecode"
} ,
{
"type" : "string" ,
"name" : "devicedata_districtcustom"
} ,
{
"type" : "string" ,
"name" : "devicedata_statecustomname"
} ,
{
"type" : "string" ,
"name" : "devicedata_userdeclared_district"
} ,
{
"type" : "string" ,
"name" : "devicedata_userdeclared_state"
} ,
{
"type" : "string" ,
"name" : "context_cdata[*]_id"
} ,
{
"type" : "string" ,
"name" : "context_cdata[*]_type"
} ,
{
"type" : "string" ,
"name" : "context_env"
} ,
{
"type" : "string" ,
"name" : "context_channel"
} ,
{
"type" : "string" ,
"name" : "context_pdata_id"
} ,
{
"type" : "string" ,
"name" : "context_pdata_pid"
} ,
{
"type" : "string" ,
"name" : "context_pdata_ver"
} ,
{
"type" : "string" ,
"name" : "context_sid"
} ,
{
"type" : "string" ,
"name" : "context_did"
} ,
{
"type" : "string" ,
"name" : "context_rollup_l1"
} ,
{
"type" : "string" ,
"name" : "object_id"
} ,
{
"type" : "string" ,
"name" : "object_type"
} ,
{
"type" : "string" ,
"name" : "object_version"
} ,
{
"type" : "string" ,
"name" : "ver"
}
]
} ,
"timestampSpec" : {
"column" : "arrival-time" ,
"format" : "auto"
} ,
"metricsSpec" : [
{
"type" : "doubleSum" ,
"name" : "eid" ,
"fieldName" : "eid"
} ,
{
"type" : "doubleSum" ,
"name" : "syncts" ,
"fieldName" : "syncts"
} ,
{
"type" : "doubleSum" ,
"name" : "ets" ,
"fieldName" : "ets"
} ,
{
"type" : "doubleSum" ,
"name" : "edata_duration" ,
"fieldName" : "edata_duration"
} ,
{
"type" : "doubleSum" ,
"name" : "edata_size" ,
"fieldName" : "edata_size"
} ,
{
"type" : "doubleSum" ,
"name" : "edata_filters_make_vers" ,
"fieldName" : "edata_filters_make_vers"
} ,
{
"type" : "doubleSum" ,
"name" : "devicedata_firstaccess" ,
"fieldName" : "devicedata_firstaccess"
}
] ,
"granularitySpec" : {
"type" : "uniform" ,
"segmentGranularity" : "DAY" ,
"queryGranularity" : "HOUR" ,
"rollup" : false
}
} ,
"tuningConfig" : {
"type" : "kafka" ,
"maxRowsPerSegment" : 50000 ,
"logParseExceptions" : true
} ,
"ioConfig" : {
"type" : "kafka" ,
"topic" : "obsrv-telemetry-events" ,
"consumerProperties" : {} ,
"taskCount" : 1 ,
"replicas" : 1 ,
"taskDuration" : "PT8H" ,
"useEarliestOffset" : false ,
"completionTimeout" : "PT8H" ,
"inputFormat" : {
"type" : "json" ,
"flattenSpec" : {
"useFieldDiscovery" : true ,
"fields" : [
{
"type" : "path" ,
"expr" : "$.eid" ,
"name" : "eid"
} ,
{
"type" : "path" ,
"expr" : "$.syncts" ,
"name" : "syncts"
} ,
{
"type" : "path" ,
"expr" : "$.ets" ,
"name" : "ets"
} ,
{
"type" : "path" ,
"expr" : "$.edata.duration" ,
"name" : "edata_duration"
} ,
{
"type" : "path" ,
"expr" : "$.edata.size" ,
"name" : "edata_size"
} ,
{
"type" : "path" ,
"expr" : "$.edata.filters.make.vers" ,
"name" : "edata_filters_make_vers"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.firstaccess" ,
"name" : "devicedata_firstaccess"
} ,
{
"type" : "path" ,
"expr" : "$.flags.ex_processed" ,
"name" : "flags_ex_processed"
} ,
{
"type" : "path" ,
"expr" : "$.flags.pp_validation_processed" ,
"name" : "flags_pp_validation_processed"
} ,
{
"type" : "path" ,
"expr" : "$.flags.pp_duplicate_skipped" ,
"name" : "flags_pp_duplicate_skipped"
} ,
{
"type" : "path" ,
"expr" : "$.flags.device_denorm" ,
"name" : "flags_device_denorm"
} ,
{
"type" : "path" ,
"expr" : "$.flags.user_denorm" ,
"name" : "flags_user_denorm"
} ,
{
"type" : "path" ,
"expr" : "$.flags.loc_denorm" ,
"name" : "flags_loc_denorm"
} ,
{
"type" : "path" ,
"expr" : "$.derivedlocationdata.district" ,
"name" : "derivedlocationdata_district"
} ,
{
"type" : "path" ,
"expr" : "$.derivedlocationdata.from" ,
"name" : "derivedlocationdata_from"
} ,
{
"type" : "path" ,
"expr" : "$.derivedlocationdata.state" ,
"name" : "derivedlocationdata_state"
} ,
{
"type" : "path" ,
"expr" : "$.mid" ,
"name" : "mid"
} ,
{
"type" : "path" ,
"expr" : "$.type" ,
"name" : "type"
} ,
{
"type" : "path" ,
"expr" : "$.actor.type" ,
"name" : "actor_type"
} ,
{
"type" : "path" ,
"expr" : "$.actor.id" ,
"name" : "actor_id"
} ,
{
"type" : "path" ,
"expr" : "$.edata.type" ,
"name" : "edata_type"
} ,
{
"type" : "path" ,
"expr" : "$.edata.query" ,
"name" : "edata_query"
} ,
{
"type" : "path" ,
"expr" : "$.edata.filters.slug" ,
"name" : "edata_filters_slug"
} ,
{
"type" : "path" ,
"expr" : "$.edata.filters.isTenant" ,
"name" : "edata_filters_isTenant"
} ,
{
"type" : "path" ,
"expr" : "$.edata.filters.make.type" ,
"name" : "edata_filters_make_type"
} ,
{
"type" : "path" ,
"expr" : "$.edata.topn[*].id" ,
"name" : "edata_topn_id"
} ,
{
"type" : "path" ,
"expr" : "$.edata.items" ,
"name" : "edata_items"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.subject[*]" ,
"name" : "userdata_subject"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.district" ,
"name" : "userdata_district"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.usersubtype" ,
"name" : "userdata_usersubtype"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.grade[*]" ,
"name" : "userdata_grade"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.usersignintype" ,
"name" : "userdata_usersignintype"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.usertype" ,
"name" : "userdata_usertype"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.userlogintype" ,
"name" : "userdata_userlogintype"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.state" ,
"name" : "userdata_state"
} ,
{
"type" : "path" ,
"expr" : "$.@timestamp" ,
"name" : "@timestamp"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.statecustomcode" ,
"name" : "devicedata_statecustomcode"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.country" ,
"name" : "devicedata_country"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.iso3166statecode" ,
"name" : "devicedata_iso3166statecode"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.city" ,
"name" : "devicedata_city"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.countrycode" ,
"name" : "devicedata_countrycode"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.state" ,
"name" : "devicedata_state"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.idisk" ,
"name" : "devicedata_devicespec_idisk"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.webview" ,
"name" : "devicedata_devicespec_webview"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.os" ,
"name" : "devicedata_devicespec_os"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.scrn" ,
"name" : "devicedata_devicespec_scrn"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.sims" ,
"name" : "devicedata_devicespec_sims"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.cpu" ,
"name" : "devicedata_devicespec_cpu"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.id" ,
"name" : "devicedata_devicespec_id"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.camera" ,
"name" : "devicedata_devicespec_camera"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.edisk" ,
"name" : "devicedata_devicespec_edisk"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.make" ,
"name" : "devicedata_devicespec_make"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.statecode" ,
"name" : "devicedata_statecode"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.districtcustom" ,
"name" : "devicedata_districtcustom"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.statecustomname" ,
"name" : "devicedata_statecustomname"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.userdeclared.district" ,
"name" : "devicedata_userdeclared_district"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.userdeclared.state" ,
"name" : "devicedata_userdeclared_state"
} ,
{
"type" : "path" ,
"expr" : "$.context.cdata[*].id" ,
"name" : "context_cdata_id"
} ,
{
"type" : "path" ,
"expr" : "$.context.cdata[*].type" ,
"name" : "context_cdata_type"
} ,
{
"type" : "path" ,
"expr" : "$.context.env" ,
"name" : "context_env"
} ,
{
"type" : "path" ,
"expr" : "$.context.channel" ,
"name" : "context_channel"
} ,
{
"type" : "path" ,
"expr" : "$.context.pdata.id" ,
"name" : "context_pdata_id"
} ,
{
"type" : "path" ,
"expr" : "$.context.pdata.pid" ,
"name" : "context_pdata_pid"
} ,
{
"type" : "path" ,
"expr" : "$.context.pdata.ver" ,
"name" : "context_pdata_ver"
} ,
{
"type" : "path" ,
"expr" : "$.context.sid" ,
"name" : "context_sid"
} ,
{
"type" : "path" ,
"expr" : "$.context.did" ,
"name" : "context_did"
} ,
{
"type" : "path" ,
"expr" : "$.context.rollup.l1" ,
"name" : "context_rollup_l1"
} ,
{
"type" : "path" ,
"expr" : "$.object.id" ,
"name" : "object_id"
} ,
{
"type" : "path" ,
"expr" : "$.object.type" ,
"name" : "object_type"
} ,
{
"type" : "path" ,
"expr" : "$.object.version" ,
"name" : "object_version"
} ,
{
"type" : "path" ,
"expr" : "$.ver" ,
"name" : "ver"
}
]
}
} ,
"appendToExisting" : false
}
} ,
"datalake_ingestion_spec" : {
"dataset" : "sb-telemetry.1_DAY" ,
"schema" : {
"table" : "sb-telemetry.1_DAY" ,
"partitionColumn" : "syncts" ,
"timestampColumn" : "date" ,
"primaryKey" : "mid" ,
"columnSpec" : [
{
"type" : "string" ,
"column" : "eid"
} ,
{
"type" : "string" ,
"column" : "ver"
} ,
{
"type" : "long" ,
"column" : "syncts"
} ,
{
"type" : "long" ,
"column" : "ets"
} ,
{
"type" : "string" ,
"column" : "flags.ex_processed"
} ,
{
"type" : "string" ,
"column" : "flags.pp_validation_processed"
} ,
{
"type" : "string" ,
"column" : "flags.pp_duplicate_skipped"
} ,
{
"type" : "string" ,
"column" : "flags.device_denorm"
} ,
{
"type" : "string" ,
"column" : "flags.user_denorm"
} ,
{
"type" : "string" ,
"column" : "flags.loc_denorm"
} ,
{
"type" : "string" ,
"column" : "derivedlocationdata.district"
} ,
{
"type" : "string" ,
"column" : "derivedlocationdata.from"
} ,
{
"type" : "string" ,
"column" : "derivedlocationdata.state"
} ,
{
"type" : "string" ,
"column" : "mid"
} ,
{
"type" : "string" ,
"column" : "type"
} ,
{
"type" : "string" ,
"column" : "actor.type"
} ,
{
"type" : "string" ,
"column" : "actor.id"
} ,
{
"type" : "string" ,
"column" : "edata.type"
} ,
{
"type" : "long" ,
"column" : "edata.duration"
} ,
{
"type" : "array" ,
"column" : "userdata.subject"
} ,
{
"type" : "string" ,
"column" : "userdata.district"
} ,
{
"type" : "string" ,
"column" : "userdata.usersubtype"
} ,
{
"type" : "array" ,
"column" : "userdata.grade"
} ,
{
"type" : "string" ,
"column" : "userdata.usersignintype"
} ,
{
"type" : "string" ,
"column" : "userdata.usertype"
} ,
{
"type" : "string" ,
"column" : "userdata.userlogintype"
} ,
{
"type" : "string" ,
"column" : "userdata.state"
} ,
{
"type" : "string" ,
"column" : "@timestamp"
} ,
{
"type" : "string" ,
"column" : "devicedata.statecustomcode"
} ,
{
"type" : "string" ,
"column" : "devicedata.country"
} ,
{
"type" : "string" ,
"column" : "devicedata.iso3166statecode"
} ,
{
"type" : "string" ,
"column" : "devicedata.city"
} ,
{
"type" : "string" ,
"column" : "devicedata.countrycode"
} ,
{
"type" : "string" ,
"column" : "devicedata.state"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.idisk"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.webview"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.os"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.scrn"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.sims"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.cpu"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.id"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.camera"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.edisk"
} ,
{
"type" : "string" ,
"column" : "devicedata.devicespec.make"
} ,
{
"type" : "string" ,
"column" : "devicedata.statecode"
} ,
{
"type" : "long" ,
"column" : "devicedata.firstaccess"
} ,
{
"type" : "string" ,
"column" : "devicedata.districtcustom"
} ,
{
"type" : "string" ,
"column" : "devicedata.statecustomname"
} ,
{
"type" : "string" ,
"column" : "devicedata.userdeclared.district"
} ,
{
"type" : "string" ,
"column" : "devicedata.userdeclared.state"
} ,
{
"type" : "array" ,
"column" : "context.cdata.id"
} ,
{
"type" : "array" ,
"column" : "context.cdata.type"
} ,
{
"type" : "string" ,
"column" : "context.env"
} ,
{
"type" : "string" ,
"column" : "context.channel"
} ,
{
"type" : "string" ,
"column" : "context.pdata.id"
} ,
{
"type" : "string" ,
"column" : "context.pdata.pid"
} ,
{
"type" : "string" ,
"column" : "context.pdata.ver"
} ,
{
"type" : "string" ,
"column" : "context.sid"
} ,
{
"type" : "string" ,
"column" : "context.did"
} ,
{
"type" : "string" ,
"column" : "context.rollup.l1"
} ,
{
"type" : "string" ,
"column" : "object.id"
} ,
{
"type" : "string" ,
"column" : "object.type"
} ,
{
"type" : "string" ,
"column" : "object.version"
} ,
{
"type" : "json" ,
"column" : "object.rollup"
} ,
{
"type" : "string" ,
"column" : "obsrv.meta.source.connector"
} ,
{
"type" : "string" ,
"column" : "obsrv.meta.source.id"
}
]
} ,
"inputFormat" : {
"type" : "json" ,
"flattenSpec" : {
"fields" : [
{
"type" : "path" ,
"expr" : "$.['eid']" ,
"name" : "eid"
} ,
{
"type" : "path" ,
"expr" : "$.['date']" ,
"name" : "date"
} ,
{
"type" : "path" ,
"expr" : "$.['ver']" ,
"name" : "ver"
} ,
{
"type" : "path" ,
"expr" : "$.['syncts']" ,
"name" : "syncts"
} ,
{
"type" : "path" ,
"expr" : "$.['ets']" ,
"name" : "ets"
} ,
{
"type" : "path" ,
"expr" : "$.flags.['ex_processed']" ,
"name" : "flags.ex_processed"
} ,
{
"type" : "path" ,
"expr" : "$.flags.['pp_validation_processed']" ,
"name" : "flags.pp_validation_processed"
} ,
{
"type" : "path" ,
"expr" : "$.flags.['pp_duplicate_skipped']" ,
"name" : "flags.pp_duplicate_skipped"
} ,
{
"type" : "path" ,
"expr" : "$.flags.['device_denorm']" ,
"name" : "flags.device_denorm"
} ,
{
"type" : "path" ,
"expr" : "$.flags.['user_denorm']" ,
"name" : "flags.user_denorm"
} ,
{
"type" : "path" ,
"expr" : "$.flags.['loc_denorm']" ,
"name" : "flags.loc_denorm"
} ,
{
"type" : "path" ,
"expr" : "$.derivedlocationdata.['district']" ,
"name" : "derivedlocationdata.district"
} ,
{
"type" : "path" ,
"expr" : "$.derivedlocationdata.['from']" ,
"name" : "derivedlocationdata.from"
} ,
{
"type" : "path" ,
"expr" : "$.derivedlocationdata.['state']" ,
"name" : "derivedlocationdata.state"
} ,
{
"type" : "path" ,
"expr" : "$.['mid']" ,
"name" : "mid"
} ,
{
"type" : "path" ,
"expr" : "$.['type']" ,
"name" : "type"
} ,
{
"type" : "path" ,
"expr" : "$.actor.['type']" ,
"name" : "actor.type"
} ,
{
"type" : "path" ,
"expr" : "$.actor.['id']" ,
"name" : "actor.id"
} ,
{
"type" : "path" ,
"expr" : "$.edata.['type']" ,
"name" : "edata.type"
} ,
{
"type" : "path" ,
"expr" : "$.edata.['duration']" ,
"name" : "edata.duration"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.['subject'][*]" ,
"name" : "userdata.subject"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.['district']" ,
"name" : "userdata.district"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.['usersubtype']" ,
"name" : "userdata.usersubtype"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.['grade'][*]" ,
"name" : "userdata.grade"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.['usersignintype']" ,
"name" : "userdata.usersignintype"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.['usertype']" ,
"name" : "userdata.usertype"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.['userlogintype']" ,
"name" : "userdata.userlogintype"
} ,
{
"type" : "path" ,
"expr" : "$.userdata.['state']" ,
"name" : "userdata.state"
} ,
{
"type" : "path" ,
"expr" : "$.['@timestamp']" ,
"name" : "@timestamp"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['statecustomcode']" ,
"name" : "devicedata.statecustomcode"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['country']" ,
"name" : "devicedata.country"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['iso3166statecode']" ,
"name" : "devicedata.iso3166statecode"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['city']" ,
"name" : "devicedata.city"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['countrycode']" ,
"name" : "devicedata.countrycode"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['state']" ,
"name" : "devicedata.state"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['idisk']" ,
"name" : "devicedata.devicespec.idisk"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['webview']" ,
"name" : "devicedata.devicespec.webview"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['os']" ,
"name" : "devicedata.devicespec.os"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['scrn']" ,
"name" : "devicedata.devicespec.scrn"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['sims']" ,
"name" : "devicedata.devicespec.sims"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['cpu']" ,
"name" : "devicedata.devicespec.cpu"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['id']" ,
"name" : "devicedata.devicespec.id"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['camera']" ,
"name" : "devicedata.devicespec.camera"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['edisk']" ,
"name" : "devicedata.devicespec.edisk"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.devicespec.['make']" ,
"name" : "devicedata.devicespec.make"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['statecode']" ,
"name" : "devicedata.statecode"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['firstaccess']" ,
"name" : "devicedata.firstaccess"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['districtcustom']" ,
"name" : "devicedata.districtcustom"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.['statecustomname']" ,
"name" : "devicedata.statecustomname"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.userdeclared.['district']" ,
"name" : "devicedata.userdeclared.district"
} ,
{
"type" : "path" ,
"expr" : "$.devicedata.userdeclared.['state']" ,
"name" : "devicedata.userdeclared.state"
} ,
{
"type" : "path" ,
"expr" : "$.context.cdata[*].['id']" ,
"name" : "context.cdata.id"
} ,
{
"type" : "path" ,
"expr" : "$.context.cdata[*].['type']" ,
"name" : "context.cdata.type"
} ,
{
"type" : "path" ,
"expr" : "$.context.['env']" ,
"name" : "context.env"
} ,
{
"type" : "path" ,
"expr" : "$.context.['channel']" ,
"name" : "context.channel"
} ,
{
"type" : "path" ,
"expr" : "$.context.pdata.['id']" ,
"name" : "context.pdata.id"
} ,
{
"type" : "path" ,
"expr" : "$.context.pdata.['pid']" ,
"name" : "context.pdata.pid"
} ,
{
"type" : "path" ,
"expr" : "$.context.pdata.['ver']" ,
"name" : "context.pdata.ver"
} ,
{
"type" : "path" ,
"expr" : "$.context.['sid']" ,
"name" : "context.sid"
} ,
{
"type" : "path" ,
"expr" : "$.context.['did']" ,
"name" : "context.did"
} ,
{
"type" : "path" ,
"expr" : "$.context.rollup.['l1']" ,
"name" : "context.rollup.l1"
} ,
{
"type" : "path" ,
"expr" : "$.object.['id']" ,
"name" : "object.id"
} ,
{
"type" : "path" ,
"expr" : "$.object.['type']" ,
"name" : "object.type"
} ,
{
"type" : "path" ,
"expr" : "$.object.['version']" ,
"name" : "object.version"
} ,
{
"type" : "path" ,
"expr" : "$.object.['rollup']" ,
"name" : "object.rollup"
} ,
{
"type" : "path" ,
"expr" : "$.obsrv_meta.source.['connector']" ,
"name" : "obsrv.meta.source.connector"
} ,
{
"type" : "path" ,
"expr" : "$.obsrv_meta.source.['connectorInstance']" ,
"name" : "obsrv.meta.source.id"
}
]
}
}
}
} ,
"datasource" : "obsrv-telemetry-events" ,
"datasource_ref" : "obsrv-telemetry-events" ,
"published_date" : "2023-03-27T11:40:43.269Z" ,
"status" : "Live" ,
"metadata" : {
"rollup" : false ,
"granularity" : "day"
}
}) ,
});
const data = await response .json ();