Recently am getting following errors while querying syn5884179 via API.
I tried same query on web interface after removing the brackets and it also failed. Can someone suggest what might be happening?
I've downloaded about 90 rows from same table since April 2016 without a problem.
The column exists and is returned if not specified in the query by SELECT *
INFO: Retrieving (1) rowId: 94
Processing file column: accelerometer_fitness_walk_json.items
ERROR: Failure within Sync for config index 0 | 500 Server Error: Internal Server Error#012PreparedStatementCallback; bad SQL grammar [SELECT accelerometer_fitness_walk_json.items FROM T5884179 WHERE ROW_ID IN ( 94 )]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'accelerometer_fitness_walk_json.items' in 'field list'
Thanks
Created by jdrummey Putting the column name in single quotes should resolve the issue:
```
SELECT 'accelerometer_fitness_walk_json.items' FROM syn5884179 WHERE ROW_ID IN ( 94 )
```