Can you use the API to call and get just the first row ID?

Lucas Rayala

I have 10,000K line database and I need just the row ID for the first row -- currently I'm grabbing the entire JSON table to then query for the ID, but that takes a bit of time. Is there a re way to just ask for that first row ID?

You can do this for columns like this:

first_column = []
first_column.append(ss.Sheets.get_columns(sheet_id, include_all=True).data[0].id)

But you can't do the same thing for a row, such as this:

first_row = []
first_row.append(ss.Sheets.get_rows(sheet_id, include_all=True).data[0].id)

Any thoughts?

Jeff Reisman

@Lucas Rayala

In the Get Sheet method, you can pass a rowNumbers query parameter - a comma-separated list of row numbers to include in the result, filtering out the other rows.

Smartsheet API Guide - Get Sheet

Maybe try that and see if it works how you'd expect.

Jeff Reisman

@Lucas Rayala

In the Get Sheet method, you can pass a rowNumbers query parameter - a comma-separated list of row numbers to include in the result, filtering out the other rows.

Smartsheet API Guide - Get Sheet

Maybe try that and see if it works how you'd expect.

Lucas Rayala

Thanks! I'll look into that -- I picked through the json schema and figured out that I can also use:

header_row = ss.Sheets.get_sheet(sheet_id).rows[0].id