in lambda-connector/DC-got-talent-preliminary-scores.py [0:0]
def lambda_handler(event, context):
client = boto3.client('honeycode')
data = []
workbook = "<your wookbook ID>"
table = "<your table ID>"
response = client.query_table_rows(
workbookId=workbook,
tableId=table,
filterFormula={
'formula': "=Filter(Composers, \"Composers[Display Preliminary] ORDER BY Composers[Aggregated Preliminary Score] Desc\")"
}
)
data += process_data(response)
while("nextToken" in response.keys()):
print('Next token found in keys!')
response = client.query_table_rows(
workbookId=workbook,
tableId=table,
filterFormula={
'formula': "=Filter(Composers, \"Composers[Display Preliminary] ORDER BY Composers[Aggregated Preliminary Score] Desc\")"
},
nextToken=response['nextToken']
)
data += process_data(response)
return {
'statusCode': 200,
"isBase64Encoded": False,
"headers": {
'Access-Control-Allow-Origin': '*',
'Access-Control-Allow-Credentials': True,
},
'body': json.dumps(data)
}