I am working on a lambda to export the data present in Honeycode. I am using QueryTableRows API to get the selected rows from the table. API reference: https://docs.aws.amazon.com/honeycode/latest/APIReference/API_QueryTableRows.html
Sample code:
def fetch_proposal_data(): response = honeycode_client.query_table_rows( workbookId=WORKBOOK_ID, tableId=PROPOSAL_TABLE_ID, filterFormula = {"formula": f'=FILTER(Proposals,"Proposals[Status]=""MEDICAL_EVALUATION_REQUIRED"" OR Proposals[Status]=""UNDER_WRITER_REVIEW""")'} ) return response
Above code might not return all data present in DB if the table size is huge, we probably need to fetch the records in pagination form. API reference mentioned here https://docs.aws.amazon.com/honeycode/latest/APIReference/API_QueryTableRows.html
From the above link, this is not very clear about how we can provide nextToken as the reference to the API call. What value should we pass as nextToken in the API request?