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

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?

Find more posts tagged with

API and Developers

Accepted answers

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.

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.