How to remove unnecessary \\u0027 from my json object?

remove escape characters from json
powershell convert to json u0027
convertto json replace
json u0026
powershell escape json

I am trying to perform a simple convert operation on my string. The objective is to convert my string to json format.

string clientID= newClient.GetClientId();
string clientSecret = "ZDUyYTYyMjYtMTcyNC00ODkxLWI2NmMtMDlhZjA3MDdiOGQ2";
var stringObject= "{ clientID:"+ "'"+clientID+"', clientSecret:"+"'"+clientSecret+"'}" ;
var json= new JavaScriptSerializer().Serialize(stringObject);

However when i print the json ..The output shows something like this:

"{ clientID:\u0027YmY3NjZkM2ItZDg3MC00ZjQwLTk1NjktNTE0N2M1YzExOWMx\u0027, clientSecret:\u0027ZDUyYTYyMjYtMTcyNC00ODkxLWI2NmMtMDlhZjA3MDdiOGQ2\u0027}\"

How do i remove unnecessary \u0027 ?

First step is to model a class that matches the JSON structure you need. In this case a class with 2 string properties will do:

public class FooType 
{
   public string clientID {get;set;}
   public string clientSecret {get;set;}
}

Next we need to instantiate this class and set its properties:

var foo = new FooType { 
    clientID = newClient.GetClientId(),
    clientSecret = "ZDUyYTYyMjYtMTcyNC00ODkxLWI2NmMtMDlhZjA3MDdiOGQ2",
};

then we can Serialize that into JSON:

var json= new JavaScriptSerializer().Serialize(foo);

The result in json will be:

{"clientID":"42","clientSecret":"ZDUyYTYyMjYtMTcyNC00ODkxLWI2NmMtMDlhZjA3MDdiOGQ2"}

Notice how the values are enclosed in double quotes, not in single ones and that no extra care is needed for escaping, removing or replacing chars. That is all handled by serializers because that is their main responsibility.

Although your code using the JavaScriptSerializer will still work, it is stated in the documentation that you better switch to Json.NET for serializing JSON. Your approach will be the same.

How to remove escape characters from JSON, How to remove escape characters from JSON ⏩ Post By ✅ Julie Marulappa out how I would go about removing the escape characters from my JSON below. The $ZCONVERT function should be used to decode JSON strings (properties of a JSON object). $toJSON() escaped forward slash unnecessarily in 2016.1. JSON_REMOVE () – Remove Data from a JSON Document in MySQL. In MySQL, the JSON_REMOVE () function removes data from a JSON document and returns the result. You provide the JSON document as the first argument, followed by the path to remove data from. You can provide multiple paths if required.

Using JObject from Newtonsoft.JSON.Linq will address the issue for someone trying to convert string directly..

   JObject json = JObject.Parse(str);

This is the sample code:

using System.Web;
using Newtonsoft.Json.Linq;

namespace MyTestProjectConsole
{
    public class Test1Json
    {
        public void ConvertJson()
       {
            string clientID = "aa";
            string clientSecret = "bb";
            var stringObject = "{ clientID:" + "'" + clientID + "', clientSecret:" + "'" + clientSecret + "'}";
            var json = JObject.Parse(stringObject);
            Console.WriteLine(json);
        }

        public static void Main()
        {
            Test1Json obj = new Test1Json();
            obj.ConvertJson();
            Console.ReadKey();
        }
    }
}

This generates the following output in console:

{
  "clientID": "aa",
  "clientSecret": "bb"
}

Solved: Remove backslash from Json Object, Solved: [Thread Edited By Adobe] /*Don't forget to meet and greet your fellow peers virtually by telling them about yourself here . Go ahead - 190832. Keys must be strings, and values must be a valid JSON data type (string, number, object, array, boolean or null). Keys and values are separated by a colon. Each key/value pair is separated by a comma.

You can replace your json text string with this function that removes those characters:

var json= new JavaScriptSerializer().Serialize(stringObject);
json = System.Text.RegularExpressions.Regex.Unescape(json);

ECMAScript Language Specification, 11.4.1 The delete Operator; 11.4.2 The void Operator; 11.4.3 The typeof Operator 15.12.1 The JSON Grammar; 15.12.2 parse ( text [ , reviver ] ); 15.12.3 stringify additional array manipulation functions, support for the JSON object encoding necessary distinctions when forming words or phrases in certain languages. And, once they're written, if you decide at some point to change the data structure of either your Schedule object or the Alarms (such as shortening the names of all your keys to have a smaller memory footprint of the JSON object), you only need to change the coding within the object itself, not in any of the front ends as long as you leave the method signatures themselves untouched.

Geotab Community Question: Problem with API Get() in my , JsonSerializerException\u0027 was thrown." The authObj parameter holds the object returned from the API var json = JSON.parse(this. UpvoteUpvoted​Remove Upvote Reply. Integration User (Geotab Inc.) 2 years ago. It looks like there's unnecessary conversions and additions to the request and  Without digging into all the different ways that you can use this to tweak an ARM template to your heart’s satisfaction, it’s reasonable to assume that at some point you’d like to convert your newly modified object back into a plain ole’ JSON file with the intention of submitting it back into Azure, and that’s when things go awry.

Removing parameters outputted in JSON response. How to remove , When I make a GET request, the data is returned in JSON format. it the response body as a value let responseData = pm.response.json() // delete unwanted properties parse the string back into a JSON object let dataJson  the_coder_in_me Web Developer, I have been working with several aspects of computer security including identity access management, cryptocurrencies and payment processing 13

c#, O primeiro passo é modelar uma classe que corresponde à estrutura JSON que você precisa. Neste caso, uma classe com 2 propriedades de cadeia vai fazer: JSON objects are surrounded by curly braces {}. JSON objects are written in key/value pairs. Keys must be strings, and values must be a valid JSON data type (string, number, object, array, boolean or null). Keys and values are separated by a colon. Each key/value pair is separated by a comma.

Comments
  • Just make a class Foo with 2 string properties: clientID and clientSecret, assign the values to an instance of Foo and then serialize that instance of Foo, instead of serializing a string
  • JSON uses double quotes, not single quotes. Plus, clientID and clientSecret should be encased in double quotes as well.
  • \u0027 is an apostrophe character you are adding yourself to the string. Use a proper JSON serialize like JSON.NET and serialize the class like @rene said.
  • Thanks..I applied this and it works.. However, I was still wondering if there is a method to convert the string directly into json format.
  • @the_coder_in_me you would have to write your own serializer logic then. The problems you had with your approach are only the tip of the iceberg of the issues you will face when writing your own serializer logic, assuming you want a specification compliant output: json.org