jvalue | super lightweight C # json parser | JSON Processing library

First of all, sorry because I can't check against a proper vb.net ide actually so some typo can occur, but I think this may solution your problem:

Get the values inside the result case as the structure is defined that way

Closing this issue as I believe I was not scheduling the emails out far enough for me to actually cancel them. SendGrid mentions that cancel requests sent before 10 minutes of the send_at time, are not guarenteed to get cancelled. I also noticed that when using the user/scheduled_sends endpoint, there is a delay in when the cancel call is made, and when the batch_id ends up in the list.

Assuming you are running this code on Windows, then the problem is two-fold:

• you are not telling TStringList.LoadFromFile() what the encoding of the file is. So, unless the file begins with a UTF-8 BOM (which is unlikely with a JSON file), it will be decoded as ANSI, not as UTF-8, thus corrupting any NON-ASCII characters.

• you are converting the decoded text back into bytes without specifying an encoding. The overload of ParseJSONValue() you are using expects UTF-8 encoded bytes, but BytesOf() will encode to ANSI, not to UTF-8, thus corrupting non-ASCII characters even futher.

That is why you are getting garbage text from the JSON.

There are other problems with your code, too. Namely, a memory leak and a double-free, due to you mismanaging the initlal TJSONObject.

Try this instead.

As others have said, a static class is not a good design here.

However, it is possible to map it back to JSON with some simple reflection:

As I explain in the comments this isn't JSON, except at the top level which is an array with a single string value. That specific string could be parsed as a JSON array itself, but its values can't be handled as JSON in any way. They're just strings.

While you could try parsing and splitting that string, it would be a lot safer to find the actual specification of that format and write a parser for it. Or find a library for that API.

You could use the following code for parsing, but it's slow, not very readable and based on assumptions that can easily break - what happens if a value contains a colon?

Try this, it was tested in Visual studio

Type List> for your property AdditionalDataList does not represent your desired json. Common convention is to serialize Dictionary to json object with keys used as names (and not a collection of KeyValuePair, cause as per standard names should be unique):

You definitely don't want to collect, that defeats the point of using spark here. As always with Spark you have a lot of options. You can use RDDs but I don't see a need to switch between modes here. You just want to apply custom logic to some columns and end up with a dataframe with the resulting column alone.

First, define a UDF that you want to apply:

How can I rename the keys that have similar name in .netcore to another name without editing the keys in the large JSON file?

Append some counter to the key when you save it to the dictionary, the code below it's the idx value from Linq's .Select overload: