interactive icon indicating copy to clipboard operation
interactive copied to clipboard

JSON data type not showing up in query results when using Kusto

Open claudiaregio opened this issue 3 years ago • 2 comments

Steps to reproduce:

I connected to a VSCode internal table and queried for a specific event. The columns I was after contained JSON as a data type and all showed up as null making it a dead end for my analysis

Can provide code example on request

image

claudiaregio avatar Jul 25 '22 20:07 claudiaregio

Reach out to the ADS team about this.

AbhitejJohn avatar Jul 26 '22 17:07 AbhitejJohn

A code sample or other repro would be helpful.

jonsequitur avatar Aug 01 '22 19:08 jonsequitur

#!csharp

#i "nuget:https://api.nuget.org/v3/index.json" #r "nuget:Microsoft.DotNet.Interactive.Kql,-""

#!kql

#!connect kql --kernel-name test --cluster "https://help.kusto.windows.net" --database "Samples"

#!kql

#!kql-test

print dynamic({'hello':123})

This prints out the following: print_0 null

Should have been: print_0 { "hello": 123 }

torshy avatar Feb 02 '23 11:02 torshy

Any news on this ? Would really have use in this if/when it gets fixed :smile:

ludwhe avatar Jun 23 '23 13:06 ludwhe