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?