QueryTableRows - Amazon Honeycode

QueryTableRows

Note

This API does not currently support multi-select picklist values in the new Honeycode experience.

The QueryTableRows API can be used to query for specific rows in the table using a filter function.

To find more details about using this API check the QueryTableRows API Reference page.

The following example finds all stocks that had more than 6.00% change from the previous price. Replace <workbook-id> with your workbook id and <table-id> with the table id from the response of ListTables API call.

AWS CLI Example

aws honeycode query-table-rows \ --workbook-id "<workboook-id>" \ --table-id "<table-id>" \ --filter-formula '{"formula": "=Filter(Stocks,\"Stocks[Change]>0.06\")"}'

Python SDK Example

response = honeycode_client.query_table_rows( workbookId = '<workbook-id>', tableId = '<table-id>', filterFormula = { "formula": "=Filter(Stocks,\"Stocks[Change]>0.06\")"} )

Response

{ "columnIds": [ "<symbol-column-id>", "<price-column-id>", "<previous-price-column-id>", "<percentage-change-column-id>", "<last-update-column-id>" ], "rows": [ { "cells": [ { "format": "AUTO", "formattedValue": "AMZN", "rawValue": "AMZN" }, { "format": "CURRENCY", "formattedValue": "$3,241.16", "rawValue": "3241.16" }, { "format": "CURRENCY", "formattedValue": "$3,048.41", "rawValue": "3048.41" }, { "format": "PERCENTAGE", "formattedValue": "6.32%", "formula": "=[Price]/[Previous Price]-1", "rawValue": "0.06322968367116" }, { "format": "DATE_TIME", "formattedValue": "11/4/20 6:00 PM", "rawValue": "44139.75" } ], "rowId": "<amzn-row-id>" }, { "cells": [ { "format": "AUTO", "formattedValue": "FB", "rawValue": "FB" }, { "format": "CURRENCY", "formattedValue": "$287.38", "rawValue": "287.38" }, { "format": "CURRENCY", "formattedValue": "$265.30", "rawValue": "265.3" }, { "format": "PERCENTAGE", "formattedValue": "8.32%", "formula": "=[Price]/[Previous Price]-1", "rawValue": "0.083226535996985" }, { "format": "DATE_TIME", "formattedValue": "11/4/20 6:00 PM", "rawValue": "44139.75" } ], "rowId": "<fb-row-id>" } ], "workbookCursor": 1288302476 }