# QueryTable API Cannot Extract Lookup or Template Column Values?

**URL:** <https://community.glideapps.com/t/querytable-api-cannot-extract-lookup-or-template-column-values/54952>\
**Category:** Ask for Help\
**Created:** [November 26, 2022, 6:29am UTC](https://community.glideapps.com/t/querytable-api-cannot-extract-lookup-or-template-column-values/54952 "2022-11-26T06:29:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [November 26, 2022, 6:29am UTC](https://community.glideapps.com/t/querytable-api-cannot-extract-lookup-or-template-column-values/54952/1 "2022-11-26T06:29:36Z")

</div>

Dear Community

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

 ![RF}ECN7W{{_NO@{S%4`)7(L](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd6c1e1270ff8c466ac48cab3e9a51f8eb8d7dc4.png)

The script is as such:

curl --request POST ‘[https://api.glideapp.io/api/function/queryTables](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](https://community.glideapps.com/t/computed-value-different-after-using-customer-action-add-row-to-another-table/54950) 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?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 26, 2022, 6:37am UTC](https://community.glideapps.com/t/querytable-api-cannot-extract-lookup-or-template-column-values/54952/2 "2022-11-26T06:37:44Z")

</div>

> [@ichilddev](#):
>
> 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”  
> }]  
> }]

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.