Can't extend/project when field name has period

[hairyhenderson]

Given some JSON like this:

[
    {
        "labels": {
            "foo.bar.baz/qux": 42
        }
    }
]

I expect to be able to grab the innermost field like this (or with some other syntax):

parse-json
| extend "quux"="labels.foo.bar.baz/qux"

But it's silently missed.

Here it is in the Infinity datasource:

Looking at get_single_value (

uql/src/parser/utils.ts

Line 5 in 3882e4d

export const get_single_value = (input: any, query: string): string | number | any[] => {

) it seems that it's using Lodash's get, which can work around the issue by taking an array-type argument:

> _.get({"l": {"a.b": 42}}, "l.a.b")
undefined
> _.get({"l": {"a.b": 42}}, ["l", "a.b"])
42

I wonder if the fix is as simple as changing get_single_value's query type from string to any?

[yesoreyeram]

What about extend "quax"="labels['foo.bar.baz/qux']" as a workaround? Haven't tested btw.

[hairyhenderson]

@yesoreyeram ah! that works! I guess some documentation is missing somewhere 😅