KQL parse string to json

Question

I'm having troubles to understand the following. Why can't I convert directly using parse_json() func but have to use tostring() first?

Data types

Data type returned == string

Why can't I use the parse_json() function like this directly:

But have to apply the tostring func() first ?

Not working:

|extend x = gettype(parse_json(Properties_d.requestbody))

Working:


|extend x = gettype(parse_json(tostring(Properties_d.requestbody)))

Is it becuase:

Yoni L. · Accepted Answer

this is explicitly explained in the documentation:

enter image description here

Donate For Us