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.
Writer
Get Started. Write Away!
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.
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
sergey
4_Saravanaprakash T
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー