Hi all,
I am not sure if Smartsheet recently changed how strings and integers are formatted, but my API script has seemingly randomly began converting certain string values to integers automatically. For example, a string that leads with 0s such as "0450" is now being put into the smartsheet as just 450 and it shows up as a numerical value.
Any ideas on why this might be the case?
I attached a text file with my updateRowToSheet method as well as an example of a string value that is showing up as an integer in smartsheet. I looked at the API documentation https://smartsheet.redoc.ly/tag/cellsObjects and tried adding in columnType and displayValue as types string, but that did not work. All the code in the text file is in python.
Thanks!