Test table:
The API instructions provided in association with the table is the next image below. The “List records” API intructions / URL was used, rather than “Retrieve a record.” I found that with Retrieve a record, I was having to include the URL for each individual row. The URL provided by the List records instructions is as follows.
https://api.airtable.com/v0/applHEBApYdbwibul/Quotes?maxRecords=100&view=Grid%20view.
I increased the max records from 3 to 100 manually. I am not sure how the “Grid%20view” works, but the call doesn’t work correctly without it (I tried testing without it).
Here is a closeup of the example:
Here is my API response step. It includes the header value with the authentication. I am retrieving three columns of values from three of the five rows. The 0’s, 1’s and 2’s in the call corresponds with rows 1, 2 and 3, as expected.
Here is the test output.
The last Alexa step goes to the stop block, where it adds “Cheers’ at the end.