How to eliminate leading apostrophe from values when updating columns via API
I currently have a C# application that updates a few smartsheets and am struggling with leading apostrophes in most columns I'm updating. All of the columns are marked as Numeric/Text, and all data types of values being pushed are varchar/strings. However it seems that if the value being pushed does not contain any letters (for example, 56%, 489349343, 345,444 are all examples I've tried), the value gets a leading apostrophe added to it in Smartsheet.
Has anyone else experienced this or come up with a solution. Poking around I found that most people just ended up creating "helper" columns with formulas to remove the apostrophe, but I'd prefer to just not have it in the first place.
Any help would be appreciated. Thank you!