connected-content-airtable.html

{% comment %}Get results from a specific view in a table within an Airtable base.{% endcomment %}

{% assign base = "appGqWQfIYRUabcxyz" %}
{% assign table = "Products" | url_encode %}
{% assign view = "On Sale" | url_encode %}
{% assign results = 8 %}

{% connected_content 
    https://api.airtable.com/v0/{{base}}/{{table}}?maxRecords={{results}}&view={{view}}
    :method get
    :headers {
    "Authorization": "Bearer ABC123XYZ"
    }
    :save items
%}

{% comment %}List values from the Name column{% endcomment %}
{% for item in items['records'] %}
  {{item.fields['Name']}}
{% endfor %}