Nov 23, 2016 10:19 AM
So, here’s another in my long line of small issued in the API. I have simple formula fields in my table that add other columns together. It’s literally field a = field x + field y + field z. When I return field a, the api doesn’t return “0” properly. Instead, I get the most recent non-zero value in the field.
It should look like: It Looks Like:
0 0
0 0
5 5
0 5
1 1
4 4
0 4
0 4
0 4
I’m using the API to generate simple reporting in Google Sheets, so I have apps script turning the api json object into an array of strings. I’ve verified that there isn’t any weird behavior here with 0 values in my implementation of the apps script. The api only does this on calculated fields.
My only idea so far is that the api is treating the 0 value in the calculated field as empty, but I’m not sure that would cause the behavior or what to do if that is the case. Thanks for any ideas.
Feb 23, 2017 09:44 AM
Update: It isn’t just calculated fields. Any field that returns a numeric value through the api won’t return blank or zero values. Instead, as notated above, the api will return the most recent non-zero value in the field . My work around for the moment is setting all zero values to some variation of 0.00001 as well as setting field defaults to the same.