Does the Apps Script parser JSON.parse() incorrectly remove leading zeros from string object keys?

Question

Does the Apps Script parser JSON.parse() incorrectly remove leading zeros from string object keys?

I am facing an issue with my Apps Script Web App where JSON data is being manipulated when I try to parse it. Specifically, keys with leading zeros are being altered (e.g "0123" becomes "123") during the JSON.parse() function call. It seems like the function is interpreting my string as an integer but still treating it as a string. Can anyone confirm if this behavior is expected?

To demonstrate the problem, consider the following script:

function jsontest() {
  var json = '{"0123":"foo", "bar":"0123", "foobar":123}';
  var test = JSON.parse(json);
  var check = ("0123" in test);
  var check2 = ("123" in test);

  Logger.log(test);
  Logger.log(JSON.stringify(test));
  Logger.log(check);
  Logger.log(check2);
}

The result logged is as follows:

[17-06-07 15:22:56:241 CDT] {123=foo, bar=0123, foobar=123}
[17-06-07 15:22:56:241 CDT] {"123":"foo","bar":"0123","foobar":123}
[17-06-07 15:22:56:242 CDT] false
[17-06-07 15:22:56:243 CDT] true

javascript json google-apps-script

Answer 1

Answer №1

When working with Google Apps Script, the JSON.parse() function has a behavior where it removes single and double quotations. Additionally, if the keys contain numbers, they are automatically converted to numbers. For example, "0123" is changed to the number 123. One way to avoid this conversion is by using the eval() function. When eval() is used, the quotations are removed without altering the strings.

While this approach may not be considered the best practice, it is one option to consider.

Sample :

var json = '{"0123":"foo", "bar":"0123", "foobar":123}';

var test1 = JSON.parse(json);
var test2 = eval("json=" + json);

Logger.log("%s, %s", test1, JSON.stringify(test1));
Logger.log("%s, %s", test2, JSON.stringify(test2));

Result :

{123=foo, bar=0123, foobar=123}, {"123":"foo","bar":"0123","foobar":123}
{bar=0123, foobar=123.0, 0123=foo}, {"0123":"foo","bar":"0123","foobar":123}

By incorporating the changes suggested in the sample script above, your modified script would look like this:

Modified script :

function jsontest() {
  var json = '{"0123":"foo", "bar":"0123", "foobar":123}';
  
  var test = eval("json=" + json); // <-- Added
//  var test = JSON.parse(json);
  
  var check = ("0123" in test);
  var check2 = ("123" in test);
  
  Logger.log(test);
  Logger.log(JSON.stringify(test));
  Logger.log(check);
  Logger.log(check2);
}

Result :

{bar=0123, foobar=123.0, 0123=foo}
{"0123":"foo","bar":"0123","foobar":123}
true
false

Answer 2

When working with Google Apps Script, the JSON.parse() function has a behavior where it removes single and double quotations. Additionally, if the keys contain numbers, they are automatically converted to numbers. For example, "0123" is changed to the number 123. One way to avoid this conversion is by using the eval() function. When eval() is used, the quotations are removed without altering the strings.

While this approach may not be considered the best practice, it is one option to consider.

Sample :

var json = '{"0123":"foo", "bar":"0123", "foobar":123}';

var test1 = JSON.parse(json);
var test2 = eval("json=" + json);

Logger.log("%s, %s", test1, JSON.stringify(test1));
Logger.log("%s, %s", test2, JSON.stringify(test2));

Result :

{123=foo, bar=0123, foobar=123}, {"123":"foo","bar":"0123","foobar":123}
{bar=0123, foobar=123.0, 0123=foo}, {"0123":"foo","bar":"0123","foobar":123}

By incorporating the changes suggested in the sample script above, your modified script would look like this:

Modified script :

function jsontest() {
  var json = '{"0123":"foo", "bar":"0123", "foobar":123}';
  
  var test = eval("json=" + json); // <-- Added
//  var test = JSON.parse(json);
  
  var check = ("0123" in test);
  var check2 = ("123" in test);
  
  Logger.log(test);
  Logger.log(JSON.stringify(test));
  Logger.log(check);
  Logger.log(check2);
}

Result :

{bar=0123, foobar=123.0, 0123=foo}
{"0123":"foo","bar":"0123","foobar":123}
true
false

Does the Apps Script parser JSON.parse() incorrectly remove leading zeros from string object keys?

Answer №1

Similar questions

Having difficulty interpreting the json data retrieved from the specified url

The Facebook Comments feature on my React/Node.js app is only visible after the page is refreshed

Adding text with jQuery

View real-time data in Vuejs 3 as it executes

Converting data from a JSON-like file format into valid JSON using JavaScript

What is the best way to connect information from an HTML input field to a JavaScript object with the help of AngularJS?

What is the best way to transform api.Response into a data frame or json format using Python?

Struggling to grasp the syntax, trying to invoke a JavaScript function using an input button

Please ensure there is space reserved for the header above the content

Dealing with an Undefined Property: Troubleshooting Guide

The submission of the form with the ID "myForm" using document.getElementById("myForm").submit() is

Authenticating the Gmail API using a specified user ID

Analyzing and inserting elements into an array of objects

Acquiring variables from a JQuery Ajax request while invoking a JavaScript file

Managing numerous invocations of an asynchronous function

I am trying to figure out how to properly utilize server-only functions within Next.js middleware

Derive Schema from deeply nested JSON string column using Pyspark

The design of Foundation's 4 form dropdown is not displaying correctly on Internet Explorer versions 8 and below

Unlocking the Secrets: Deserializing a Confidential Discriminated Union using Newtonsoft.Json in F#

A guide to decoding ElasticSearch JSON data using PHP