Python get_columns response.

MikeG_O

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?

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

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)

or

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

MikeG_O

Thanks that worked.