Querying by rowID in the API

[Phillip_Davis]

I suppose I have two questions:

1. How do I query for this row (I have Big Table enabled)
2. How do (if it at all) should I use this rowID in my insertion calls?
   I tried the following query:

        sql = f"SELECT * FROM \"GLIDE_INTERNAL_TABLE_ID\" WHERE \"rowID\" = $1"
        query = {
            "sql": sql,
            "params": ["ROWID"]
        }

and got the response:

{'message': 'Unknown column rowID'}

[Jeff_Hager]

If you want to see the RowID on your table, then you need to add a RowID column.

Row ID Column | Glide Docs

[Phillip_Davis]

The problem was I didn’t query by $rowID. Assuming one has a SQL data store, the above code should work.

[ThinhDinh]

Yeah, because rowIDs are referred to as $rowID as its “column name” when you query using Glide API.