What I can do now is select any one of these. You can see that it's now succeeded and voila, there are the tasks that I previously created in my Airtable database. ![]() Now that that's finished, we can test that request. And then we'll head back to Voiceflow, type in authorization and then paste what we had copied into the value field. We'll need to copy over bearer and the key for the actual base itself. The next thing we need to do is copy the line next to authorization. If you haven't generated this key yet, be sure to do so or this check box will not appear. This personal API key is required in order to use the Airtable API and can be generated in your Airtable account settings. We're going to want to click show API key in the top right corner of the screen. Next, let's head back to the API documentation for our Airtable. One thing to note when you copy this over is to make sure the URL has the entire slug in it, including the name of the tab you want to pull data from. What we're going to want to do here is copy over the URL under EXAMPLE USING BEARER TOKEN and we're going to place that inside our API step in the request URL text field. The first thing you might notice is that our variables are have been added: for example overview, task, and our example values. Now as you scroll down, there are a few things you may want to look at. Once here, we're going to need find the API key and the ID of the base. It's important to remember that each Airtable database has its own unique set of API documents, which provides us with everything we need to fill out this API step. Next, we're going to need to head back to Airtable and navigate over to the help tab.įrom there, we need to select API documentation. For this scenario, we want to use the GET request which allows us to retrieve data, or in this case, the information we just inputted into our Airtable database. Let's now open up the editor and select the dropdown next to GET.Īnd what this does is give you a few different ways you can access, manipulate, or utilize the data in your Airtable. The first thing we need to do is drag our API step onto the canvas. Now that we have our Airtable database created, let's show you how we can connect it to our Voiceflow project so we can pull or bring these answers into our experience. Let's now add three things under our task field - let's put laundry, buy gym membership, and grocery shopping. Finally, we can rename any field or fields we're using. In this case, I'm going to call this overview. We can also rename the table itself if we so choose to. Once Airtable creates this for us, we can rename this database to Airtable tutorial. From there, click add a base and then select start from scratch to create a brand new database. Once you've successfully created your account, you're going to want to navigate to the bases tab. You'll need to head to and sign up for free. The first thing you'll need to do is create an Airtable account. In Voiceflow, hooking up Airtable to your Voiceflow project is a great way to harness the power of relational databases. And then we'll explain how to retrieve information from that database using a GET request. Read more about this behavior and why it's important for security here.\In this tutorial, we'll show you how to connect a Voiceflow project to an Airtable database. As of November 8th, 2022, attachment URLs obtained via the CSV export functionality will expire after a few hours. How are attachments included in a CSV export of a view?Īttachment fields will be included in the CSV file as a filename and URL. Information not included in the export are record-level comments, field descriptions, base guide content, and data stored solely in extensions (like Description extension). What information is exported in a CSV export of a view?Īll field values visible in the view will be included in the export. Since CSV files are text only, attachment files will also need to be exported separately (more info on how attachments are included in the CSV export below). ![]() Each table in a base will need to be downloaded as its own CSV. We do not currently support exporting a full base. When you download the CSV file, it will be located in your device's default download location (more info on finding this is available here for Macs, and here for Windows) FAQs Can I export my entire base? ![]() You can use this export as a way to back up your data outside of Airtable and into another program (like Excel or Google Sheets). This functionality is only available on our web and desktop applications. ![]() You can export all of the records in a given grid view to CSV by opening up the view menu, clicking on the name of the view, then selecting the "Download CSV" menu option.
0 Comments
Leave a Reply. |