I tipi di file classici non potranno più essere utilizzati a partire da gennaio 2021. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Ability to set cell data type when importing via an API

Con risposta
Richiedi una 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

Commenti

3 commenti

Data Voti
  • Mike
    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
    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

Accedi per aggiungere un commento.