Ability to set cell data type when importing via an API
已回答Hi, I am using the spreadsheets/v1/spreadsheets/{Id}/sheets/{Id}/data API to import the data to sheet from the external data source.
I am setting the data in the body of the POST call in JSON format. The import is successful, but he data types are not correct. Some of the dates and the numbers are recognized text.
Is there a way to explicitly set the cell type via the API?
Thanks
I am setting the data in the body of the POST call in JSON format. The import is successful, but he data types are not correct. Some of the dates and the numbers are recognized text.
Is there a way to explicitly set the cell type via the API?
Thanks
0
-
Hello, and welcome to the Community!
At this time, there's not an explicit way to control the format via the API. However, once you format the cells in in the Spreadsheet, it will keep the formatting upon any further updates.
I've shared your feedback with our Product Team and will keep you updated here with any new developments. Let me know if you have any further questions for me as well. Thanks again and have a super day. Cheers!0
Thanks. Currently in the API, I am passing all values as strings. Is there a way I can pass numbers and strings in JSON? Would the API accept it.? 0
Just wanted to revisit this post. In order to help expedite and better understand your question, a representative of our Product Team who works with integrations should have reached out to you. If no one has reached out, let me know. In the meantime, let me know if you have any other questions.
Thanks, and talk to you soon.0请先登录再写评论。
评论
3 条评论