def lambda_handler()

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)
    }