Error in downloadTableColumns for file view
Description
The example for downloadTableColumns was:
results = syn.tableQuery('SELECT * FROM syn12345 LIMIT 100 OFFSET 100')
file_map = syn.downloadTableColumns(results, ['foo', 'bar'])
Following the example, I see:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
>>> table = syn.tableQuery("SELECT * FROM syn12137225 WHERE ((\"study\"='iPSC') AND (\"assay\"='rnaSeq'))")
Create CSV FileHandle [####################]100.00% 2554/2554 Done...
Downloading [####################]100.00% 343.5kB/343.5kB (180.0kB/s) Job-61017986152845219822443712.csv Done...
>>>
>>> table.headers
[{'id': '2510', 'name': 'id', 'columnType': 'ENTITYID'}, {'id': '23543', 'name': 'name', 'columnType': 'STRING'}, {'id': '60120', 'name': 'consortium', 'columnType': 'STRING'}, {'id': '59617', 'name': 'grant', 'columnType': 'STRING'}, {'id': '37438', 'name': 'study', 'columnType': 'STRING'}, {'id': '37283', 'name': 'assay', 'columnType': 'STRING'}, {'id': '67972', 'name': 'assayTarget', 'columnType': 'STRING'}, {'id': '36222', 'name': 'organ', 'columnType': 'STRING'}, {'id': '67973', 'name': 'tissue', 'columnType': 'STRING'}, {'id': '67977', 'name': 'nucleicAcidSource', 'columnType': 'STRING'}, {'id': '67975', 'name': 'cellType', 'columnType': 'STRING'}, {'id': '67974', 'name': 'terminalDifferentiationPoint', 'columnType': 'STRING'}, {'id': '67976', 'name': 'specimenID', 'columnType': 'STRING'}, {'id': '37384', 'name': 'fileFormat', 'columnType': 'STRING'}, {'id': '4694', 'name': 'createdOn', 'columnType': 'DATE'}, {'id': '37382', 'name': 'createdBy', 'columnType': 'USERID'}, {'id': '23550', 'name': 'dataFileHandleId', 'columnType': 'FILEHANDLEID'}, {'id': '37485', 'name': 'individualID', 'columnType': 'STRING'}]
>>>
>>> download = syn.downloadTableColumns(table, 'dataFileHandleId')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/Cellar/python3/3.6.2/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/synapseclient/client.py", line 3216, in downloadTableColumns
file_handle_associations, file_handle_to_path_map = self._build_table_download_file_handle_list(table, columns)
File "/usr/local/Cellar/python3/3.6.2/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/synapseclient/client.py", line 3294, in _build_table_download_file_handle_list
for row in table:
File "/usr/local/Cellar/python3/3.6.2/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/synapseclient/table.py", line 1716, in iterate_rows
yield cast_values(row, headers)
File "/usr/local/Cellar/python3/3.6.2/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/synapseclient/table.py", line 440, in cast_values
raise ValueError('Each field in the row must have a matching column header. %d fields, %d headers' % (len(values), len(headers)))
ValueError: Each field in the row must have a matching column header. 21 fields, 18 headers
>>> synapseclient.__version__
'1.8.1'Environment
Status
Assignee
Kimyen Truong
Reporter
Kimyen Truong
Validator
Kenneth Daily
Epic Link
Fix versions
Affects versions
py-1.8.1
Priority
Major