QueryTable API Cannot Extract Lookup or Template Column Values?

Dear Community

We have used the API - queryTables trying to retrieve the Table Rows’ data

The script is as such:

curl --request POST ‘https://api.glideapp.io/api/function/queryTables
–header ‘Content-Type: application/json’
–header ‘Authorization: Bearer XXXXXXXXX-e8XX-47c1-8b07-c8f805514f31’
–data-raw ‘{
“appID”: “XXXXX”,
“queries”: [
“tableName”: “native-table-RBfbyBITg5LQV7s0uqsa”

It works well if we use Custom Action: Add Row but there’s some issue with some of the values (IDs) and thus we try the Relational method. See Computed Value Different After Using Customer Action ADD ROW to Another Table for the issue with the Add Row issue.

However the API result only gives 2 columns’ values:
“rows”: [{
“$rowIndex”: “Wv”,
“$rowID”: “inFlZ6UKTW6rS8xxXiDgIw”,
“kind”: “add-row-to-table”
}, {
“$rowIndex”: “Wz”,
“$rowID”: “bYPsmaOjSyOOd7eaXrpl-Q”,
“Invoice ID”: “c61fe173-fd97-480a-89a9-e9ce236e916a”,
“kind”: “add-row-to-table”

Kindly advise?

That example is for adding rows to a table. You can only provide basic (non-computed) column values when adding rows. ie. what you see is correct.

1 Like