Force decimal numbers type when creating tables trhough API's bulk import
I'm importing data trough API's bulk import, automaticaly creating tables. I've ran into serious problem: when table is created and incoming data has some integer values (say, "total": 500), the type of a column will be set as 'Positive Number'. But if in later imports to this already exising tables "total" becomes decimal ("total": 550.6), request fails with "Bad request" error, because decimal value in being inserted into integer column.
I don't see a way to force Zoho to create numeric columns with 'Decimal Number' type instead of 'Positive Number', even setting "total" to 500.00 in first request doesn't do the trick (I'm using JSON format).
Please, advise.
I don't see a way to force Zoho to create numeric columns with 'Decimal Number' type instead of 'Positive Number', even setting "total" to 500.00 in first request doesn't do the trick (I'm using JSON format).
Please, advise.