Problem with base.query()

I have a problem with one of our tables.
We have a python script which was running smothly, but now with 1 table is not running anymore also with only a rudimentary sql statement as follows:

sql = “select * from D.Flow
dflow_queryset = base.query(sql)

I am getting following error message:

Traceback (most recent call last):
File “”, line 168, in
dflow_queryset = base.query(sql)
File “/usr/local/lib/python3.7/site-packages/seatable_api/”, line 842, in query
converted_results = convert_db_rows(metadata, results)
File “/usr/local/lib/python3.7/site-packages/seatable_api/”, line 127, in convert_db_rows
is_sm_structure, column_options = is_single_multiple_structure(column)
File “/usr/local/lib/python3.7/site-packages/seatable_api/”, line 105, in is_single_multiple_structure
options = column.get(‘data’, {}).get(‘options’, [])
AttributeError: ‘NoneType’ object has no attribute ‘get’

When I choose another table the query works.
When I run the sql in the SQL plugin works too…

Can you give me any hint what it could be the problem?

Thank you

I have found the problem
The API-Sql problem occurs when there is a multi-select column without values to select.
For example I have added a multi-select column “test” without values


Now the SQL failes

After adding a value


the base.query(sql) works again


Thanks for reporting. We will look at this issue.

@gino909 Thanks for reporting the issue and your patience.

But I think your patience has paid off: Can you test again? SeaTable 3.3 / an update of your SeaTable Server to 3.3 should solve the issue.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.