Fetch data from Airtable records using Text Blaze
This snippet fetches specific data from a single record in an Airtable base.
You can build other snippets that, for example, fetch the same column data from multiple records (using a for loop).
Theoretically, it is possible to build on top of any data that you can extract from Airtable; see this page for examples on what data you can extract.
Currently, we ask for base value as form input and use it the API query. If you want to use a fixed base, you can change the url in the urlload command below. Currently, it is importing from https://api.airtable.com/v0/\{=base\}/VWB/\{=recordid\}. In place of \{=base\} you can put in the exact base Id, for example, https://api.airtable.com/v0/appW0YBv9zvXFQcO6/VWB/\{=recordid\}.
Note that this is a connected snippet! (documentation) You will be prompted to give special permissions for this folder, so you may want to keep a single separate folder for all your connected snippets in your Text Blaze Dashboard.
{note}{formtext: name=apikey} {formtext: name=base} {formtext: name=recordid}{endnote}
{if: apikey <> "" and recordid <> "" and base <> ""}{urlload: https://api.airtable.com/v0/{=base}/VWB/{=recordid}; method=GET; done=(res) -> ["response"=catch(fromJSON(res), "???")]; headers=Authorization=Bearer {=apikey}}
Data received
All keys in response: {=keys(response)}
All keys in response.fields: {=keys(response.fields)}
Specific data from the given record
Our agent: {=response.fields["Our Agent"]}
Property Address: {=response.fields["Property Address"]}
TC: {=response.fields["TC"]}
Buyer Full Name: {=response.fields["Buyer Full Name"]}
{else}
Enter apikey, base and recordid to proceed
To get the apikey, generate it on your Airtable account page (keep it a secret)
If you have the record URL as: https://airtable.com/appW0YBv9zvXFQcO6/tblHDV2wc3yp0T7IQ/viwqYnynm1ysWpg6Y/recltLpNVfdtUlVtB?blocks=hide, then base=appW0...Qc06, and recordid=rec...VtB.
For an interactive demo of Airtable's API, visit their API page and choose your base. On the left you should choose "VWB Table" and then "Fields", "List records" or "Retrieve a record". On the right you will see various outputs relevant to your base.
{endif}