Python get_columns response.

I am trying to find specific columns through the python api.

Running something like

listColumns = smartAPI.Sheets.get_columns(83053825###, include_all=True)

gives me the object and not the Field Name.

[<smartsheet.models.column.Column object at 0x000001FBBBD26C18>, <smartsheet.models.column.Column object at 0x000001FBBBD4D2B0>, <smartsheet.models.column.Column object at 0x000001FBBBD4D860>, <smartsheet.models.column.Column object at 0x000001FBBBD4DCF8>, <smartsheet.models.column.Column object at 0x000001FBBBD101D0>, <smartsheet.models.column.Column object at 0x000001FBBBD10668>, <smartsheet.models.column.Column object at 0x000001FBBBD10B00>, <smartsheet.models.column.Column object at 0x000001FBBBD10F98>, <smartsheet.models.column.Column object at 0x000001FBBBD13470>,

...]

How do I go about finding the Name?

Find more posts tagged with

Accepted answers

Genevieve P.

Hey @MikeG_O

It looks like you may just need to resolve the response (i.e. columns = listColumns.data). Here's the API Documentation and example: List Columns

Let me know if this has helped!

Cheers,

Genevieve

All comments

Genevieve P.

Hey @MikeG_O

It looks like you may just need to resolve the response (i.e. columns = listColumns.data). Here's the API Documentation and example: List Columns

Let me know if this has helped!

Cheers,

Genevieve

smartsheetdev.io

Hi @MikeG_O

Genevieve is correct. You need to access the data.

The options are to loop over listColumns, like the below:

for x in listColumns.data:

print (x.title)

print ([x.title for x in listColumns.data])

MikeG_O

Thanks that worked.

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.