I have a field payload containing the following JSON: {
"cacheStats": {
"lds:UiApi.getRecord": {
"hits": 0,
"misses": 1
}
} I can normally use spath to retrieve the hits and misses values: cacheRecordHit=spath(payload,"cacheStats.someCacheProperty.hits") But it seems the period and possibly the colon of the lds:UiApi.getRecord property are preventing it from navigating the JSON, such that: | eval cacheRecordHit=spath(payload,"cacheStats.lds:UiApi.getRecord.hits") returns no data. I have tried the solution in this answer: | spath path=payload output=convertedPayload
| eval convertedPayload=replace(convertedPayload,"lds:UiApi.getRecord","lds_UiApi_getRecord")
| eval cacheRecordHit=spath(convertedPayload,"cacheStats.lds:UiApi.getRecord.hits")
| stats count,sum(hits) but hits still returns as null. Appreciate any insights. 🤝
... View more