Using a ROWID and an asterisk in the Google Platform API SELECT tables

Question

I am trying to get a ROWID as well as all the data for each row in Google Fusion tables.

This select statement:

SELECT *, ROWID FROM [tableID] 

leads to this error:

 "domain": "fusiontables", "reason": "badQueryCouldNotParse", "message": "Invalid query: Parse error near '*' (line 1, position 14).", "locationType": "parameter", "location": "q" 

If I provide column names, for example ...

 SELECT ROWID, name, city, suburb, etc FROM [tableID] 

... where, etc. - all column names, it works fine. The thing is, I have many column names, and I will add / remove them over time and do not want to update this select statement every time I do this.

Is statement statement ROWID + asterisk of a SELECT wildcard possible?

(I understand that perhaps I could do this using the DESCRIBE query to get all the column names and create my query from there, but I would like the number of calls to be minimal if possible).

Answer 1

You should use this:

 SELECT ROWID FROM [Table ID] WHERE [NameColum]='Data' 

and you will get a ROWID from this line where the data will be found. And then you can use the ROWID to call the entire line.