usql icon indicating copy to clipboard operation
usql copied to clipboard

Unable to read array objects those are not in Key/Value pair using JSONTUPLE

Open GauravSagne opened this issue 7 years ago • 3 comments

Hi Team,

Could someone share the knowledge on how to read array object having values in it using Newtonsoft.Json assembly. As I understood, JsonTuple creates Key/Value pairs from the array and doeesn't work on array objects with values only. Ex. [ "Name" : "", "Skills" : ["Java",".Net"] ] In nutshell, JsonTuple () has capabilities to create SQL.MAP only.

Please suggest how read the array 'Skills' to explode the array elements.

Thanks Gaurav

GauravSagne avatar Feb 15 '18 14:02 GauravSagne

Hi @MikeRys , Can I seek you help in this please. Thanks Gaurav

GauravSagne avatar Feb 20 '18 13:02 GauravSagne

Hi Gaurav,

Can you post an example of the JSON document you are trying to parse accompanied by an example of the desired output?

tayganr avatar Feb 22 '18 17:02 tayganr

Hi Gaurav,

Have you been able to figure this out? I have a similar problem and I am curious what was your solution.

Thanks, Cristian

ChrisJr avatar Aug 21 '18 12:08 ChrisJr