QueryTableRows - Amazon Honeycode
AWS CLI ExamplePython SDK ExampleResponse

To our valued customers: After careful consideration, we have made the decision to end the Amazon Honeycode beta service, effective February 29, 2024. New customer sign-ups and account plan upgrades are no longer available. Existing customers will be able to use Honeycode and your Honeycode apps as normal (and add team members to your existing account) until February 29, 2024, when the service will be discontinued. After this date, you will no longer be able to use Honeycode or any of the apps you created in Honeycode. To learn more about this change, and how to download your data, visit the Community Discussions.

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
}