|
Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Ability to set cell data type when importing via an API

Answered
Request Demo
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
0

Comments

3 comments

Date Votes
  • Mike Davis
    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
  • Integration User - DR
    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
  • Mike Davis
    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

Please sign in to leave a comment.