#AIRTABLE API AND WORDPRESS HOW TO#
#AIRTABLE API AND WORDPRESS UPDATE#
#AIRTABLE API AND WORDPRESS CODE#

The value of those fields is being maintained by the plugin's settings which you've written to the database and that you're updating from your third party app. So now you're assigning one of your predefined fields to your post. Then you'd select one of your predefined fields from a dropdown or checkbox list or you could use a Select2 input. You could still use custom fields, but then, when a custom field is present, rather than show it's value, you'd instead go to the plugin's options data and get the most up-to-date value for that field.īy 'generating a custom meta box for posts' what I mean is that you'd create a setting on a post that says 'Use this Reza Plugin Field'. You'll want to build this as a plugin and instead of using custom fields it'd be better if you generated a custom post meta box where you could assign the plugin field to get the value from. Rather than change the value 20 times, you'd want to store this value in the database, so when a change is triggered at the source you'd contact WP and change the value in the DB & that value would then appear in all the posts. If you make WordPress go and get the values from the 3rd Party application it'll be scheduled and thus not 'real-time'. You'll want the 3rd party application to be the one triggering the change, otherwise it can't be real time. Here's an example data payload for adding scores to the Airtable for the first two holes.This can be done, however a couple of quick details. Each record in the array is a dictionary with a key fields, containing a dictionary that maps values to the columns in the sheet. ’ Auto sync can be toggled on to check for new and changed data every 10 minutes. Paste your token into the API Token field. The request includes a dictionary with a key, records, defining an array of the records that will be added to the sheet. Go back to Wordrpress plugin, create post page. You can add records to your Airtable by sending a POST request. We'll have a sheet named golf-scorecard containing four columns: the date, hole number, par, and the number of strokes for the hole. To demonstrate how the API works, we will use Airtable to track golf scores.

#AIRTABLE API AND WORDPRESS HOW TO#

Below we'll look at examples of how to use the API using Python.

The documentation provides API usage documentation for curl and Javascript. A nice feature of the Airtable API documentation is after you log in to your account, you can view the documentation specific to the Airtable base you want to use.

#AIRTABLE API AND WORDPRESS UPDATE#

The Airtable REST API allows you to perform a few core actions: add a record, retrieve records, update records, and delete records.

Include the following at the top of the file:Įnter fullscreen mode Exit fullscreen mode With all the variables assembled to make our requests, it's time to put it together into a python file. You'll need that to complete the URL for making requests. env file naming it AIRTABLE_BASE_ID.įinally, make a note of the sheet name you want to modify via the API. On the next page, you will see the ID of your Airtable Base. Select the base you want to work with from the list. Make sure you are logged into your Airtable account and go to the API docs. env to avoid accidentally exposing this information! Make sure you keep this token private and do not share it with anyone! If you're committing files to a GitHub repo (or any other source control system), make sure you exclude the. Scroll down to the API section of your account page, and you will see your token.Ĭopy the token value and paste it into your. You can find your API token by going to your account page. Submitting a request to the Airtable REST API requires three pieces of information:Īirtable uses a bearer token to authenticate each API request, which should be saved in a. There is also a Jupyer notebook, AirtablePractice.ipynb in the repo you can use to follow along.įirst, let's look at the authentication for submitting a request. In the repo you will find a file airtable.py with example functions you'll build here.

#AIRTABLE API AND WORDPRESS CODE#

You will need to create a table in Airtable with the following four columns and data types:Īll the code referenced here is available in a GitHub repo. You'll learn how to add, retrieve, update, and delete records in Airtable through the Airtable REST API and also talk about some of the common gotchas and limitations.įor this tutorial, we will be using scores from a round of golf as a toy dataset. The API documentation only contains curl and Javascript examples, so this tutorial will look at how you can interact with Airtable using Python complete with examples. Airtable has a REST API that can be used to perform common operations on your Airtable. Airtable is a cloud-based relational database that simplifies data storage without having to write SQL.

Airtable api and wordpress