CODEWITHSUNDEEP
azureazure-data-lakeu-sqldata-lake
Fariha Abbasi
Fariha Abbasi

Reputation: 145

How to Modify Json Extractor?

as Json Extractor works with valid Json formats. I have a problem in which I want Json without starting and ending square '[]' brackets.

My data is always in following format:

{
------
-----
-----
}
{
------
-----
-----
}
{
------
-----
-----
}

I won't be having the starting square bracket and the ending square bracket, More over, i won't be having the comma's between the two objects, can I modify the Json Extractor to work with this kind of problem.

If yes, how can we do that?

Thanks in advance .

Upvotes: 1

Views: 93

Answers (1)

candidson
candidson

Reputation: 526

This question is more a C# Programming Question than U-SQL.

Modifying the extractor in such a way that it reads the "wrongly" formatted json, won't be straightforward, since the JSON Extractor uses the newtonsoft json library to deserialize the string.

You might end up rewriting the extractor almost entirely.

A good starting point would be the Git Project:

https://github.com/Azure/usql/tree/master/Examples/DataFormats/Microsoft.Analytics.Samples.Formats/Json

But before all that, you might wanna check how you get the data

Upvotes: 2

Related Questions