Card Order Data via API Response

Terry Seanard

I am trying to identify the order of cards in card view based on the JSON response to a GET request to the API for a sheet. I created a schedule type sheet as a test project. When I change the order of cards (by manually dragging them up and down in card view), there appears to not be any change to the response JSON that indicates card order. Additionally, once I can read the card order from the sheet, I would like to be able to set the card order via an external API call to update the sheet.

At this point, I am uncertain if a) this is just not supported, or b) this is supported and I am looking at the wrong part of the API reference.

The endpoint I am using to get the sheet data

GET: https://api.smartsheet.com/2.0/sheets/{sheetId}

Genevieve P.

Hi @Terry Seanard

As you've found, currently retrieving the location/order of cards in card view is not possible via the Smartsheet API; please submit an Enhancement Request when you have a moment to let our Product team know about your feedback.

Thank you!

Genevieve

Genevieve P.

Hi @Terry Seanard

As you've found, currently retrieving the location/order of cards in card view is not possible via the Smartsheet API; please submit an Enhancement Request when you have a moment to let our Product team know about your feedback.

Thank you!

Genevieve

Jeremy Miedreich

Is there anything like this on the roadmap?

Genevieve P.

Hi @Jeremy Miedreich

I don't know if this functionality is currently on the roadmap; the best way to ensure our Product Team is aware that this is something you'd like to see implemented is to fill out that same form I linked above (here). These submissions go directly to the Product Team and are reviewed regularly.

Cheers!

Genevieve

Madhu Vummidi

Hi @Genevieve P,

is there any update on this? I am looking for data from Gantt View (milestone and task data that lie under a milestone) not sure if that's available?

Genevieve P.

Hi @Madhu Vummidi

This thread is in regard to the order of cards in Card View.

You can use the Get Sheet request to get the rows in a sheet and find the row number in the response. Then you can filter by the milestone's row number to only show tasks after this row number. See the API documentation on Get Sheet and example response here.

Cheers!

Genevieve