Problem with base.query()

Hi
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 “index.py”, line 168, in
dflow_queryset = base.query(sql)
File “/usr/local/lib/python3.7/site-packages/seatable_api/main.py”, line 842, in query
converted_results = convert_db_rows(metadata, results)
File “/usr/local/lib/python3.7/site-packages/seatable_api/utils.py”, 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/utils.py”, 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

Hi
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

grafik

Now the SQL failes

After adding a value

grafik

the base.query(sql) works again

Regards

Thanks for reporting. We will look at this issue.