Time taken by GetSheets and GetSheetCSV API

kc_0112

I am looking to fetch data from smartsheet that contain 2k rows and 20 columns. I want to specifically get a column from it and for 1k rows. I know you can only retrive the whole sheet.

Can you please tell for my usecase for 2k*20 cells what will be the API time taken?

Genevieve P.

Hi @kc_0112

I just tested in Postman with Get Sheet for a sheet that has over 2,000 rows and 20 columns. It took less than 3 seconds. Here's more information: https://smartsheet.redoc.ly/tag/sheets#operation/getSheet

I would expect it to take a similar time to when you load it in the UI - depending on the complexity of the content in those cells it may take a little longer.

Cheers,

Genevieve