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

Unable to locate the reverse for 'my_views_name' without any arguments in Django. Bridging server-side code with client-side JavaScript using jQuery

Querying with Spring JPA - Dynamically passing the index for JSON_REMOVE function

What is the best way to toggle between rendering two components or updating two outlets based on a route in React Router?

"Reasons Why I'm Unable to Retrieve the Length of an Array

The onInvoke hook in Zone.js is receiving an inaccurate currentZone value

Tips for bringing a particular tab into focus when a page initially loads

Dealing with asynchronous tasks in JavaScript

Troubleshooting Problem with Retrieving Files Using jQuery Ajax

Issues with HTML marquee not functioning properly post fadeIn()

I'm interested in querying my mongodb collection data based on a particular field

`Error encountered when JSONP script is returning incorrect MIME Type`

Retrieving JSON data by key through ajax does not show the expected output

What is the best way to showcase a circular dot to indicate active status in a React component

What is the best way to locate the key with the greatest value in an array that is less than or equal to a certain

Handling Errors in Asynchronous Functions with JavaScriptLet's explore the best practices for

Utilizing window.matchMedia in Javascript to retain user selections during page transitions

Is it possible to include numbers and commas in JQuery Validation?

Exploring creative solutions for generating PDFs with Node JS

Top method for combining several external JavaScript libraries into a single one using webpack

tips on assigning a unique ID to an item in a firebase database collection