Google Apps Script JSON properties with null value

[Admin Oregon Gutter]

Currently, when Google Apps Script returns a JSON object with a null value to Javascript, the property is dropped from the return. Those null values are important for my checks because they are null values from database checks.

1) Is this intended?

2) How do I get it to return null values?

Sample Google Apps Script:

function returnTest() {

  var returnData = {

    fakeNumber:1234,

    nullValue:null,

    undefinedValue:undefined

    }

    return returnData;

}

Javascript log of returnData: 

{  fakeNumber:1234 }

[dimud...@gmail.com]

Tested your function (executed directly in the IDE) using `console.log()` and got back the expected value:

{ fakeNumber: 1234, nullValue: null, undefinedValue: undefined }

Are you performing some transformation on the returnData object before logging it?

[Admin Oregon Gutter]

It works when called in Google Apps Script. The problem is when it is passed back to Javascript. 

Google Log: { FakeNumber:1234,  nullValue:null, undefinedValue:undefined }

JavaScript Log: { FakeNumber:1234 } 

Expected JavaScript: { FakeNumber:1234,  nullValue:null, undefinedValue:undefined }

Javascript functions:

function getResults() {

  google.script.run.withSuccessHandler(consoleLogResults).withFailureHandler(consoleLogResults).returnTest();
}

function consoleLogResults(returnData) {

  console.log(returnData);

}

[dimud...@gmail.com]

Ohh...so you're passing an object from Apps Script to client-side Javascript.

 
You can try stringifying the return data and then parsing it on the client-side. You'll still lose the undefined keys (JSON.stringify() strips them out, undefined is not supported in JSON) but the nullValue key should pass through:

// Apps Script
function returnTest() {
    return JSON.stringify({

        fakeNumber: 1234,

        nullValue: null,

        undefinedValue: undefined 

    });
}
.
.
.
// Client-side Javascript
function consoleLogResults(returnData) {

    console.log(JSON.parse(returnData));
} 

[Admin Oregon Gutter]

Yes, I am passing an object back to JavaScript. 

I used to get null values in my return and it seems like it has changed in the last week.

I was wondering if this was an intended change and how I can fix it without sifting through all of my code. Also, if it is an intended change, where can I find this info?

Any thoughts?

[Stanislav Tvarůžek]

The same issue here. After spending some time figuring out why my add-on stopped working as there was no change done, yap, null properties are removed from response... 

I raised an issue, please mark it / comment there:

https://issuetracker.google.com/issues/209024267