Questions tagged [airtable]

Questions related to interacting with Airtable databases programmatically.

Airtable is a spreadsheet like software in the cloud.

286 questions
2
votes
1 answer

Unclear why Fetch for UPS XML API failing

I'm working on an airtable automation that is putting in an address validation request to the USPS API. For some reason, when I try to fetch it times out. I've validated that the URL I'm testing on works just fine and provides a response, but no…
j_kathleen
  • 21
  • 1
2
votes
1 answer

Airtable returns not all records via API

I do load aittable records via their API: const base = airtable.base(item.baseId); base("Dishes") .select({ }) .eachPage( function page(records, fetchNextPage) { tableRecords.push(...records); // To fetch the…
Vasiliy vvscode Vanchuk
  • 7,007
  • 2
  • 21
  • 44
2
votes
1 answer

Integromat - Save Google Doc to Airtable Attachment Field

I am trying to use Integromat to save a Google Doc to an Airtable attachment field. The problem is that the Airtable "Update a Record" module expects a "File URL" value which I am unsure how to get. I tried choose the "Export Links: Application PDF"…
Alex N
  • 31
  • 3
2
votes
1 answer

How to pass event parameters to AWS Lambda function using API Gateway?

I have an AWS Lambda function written in python that is initiated by a Zapier trigger that I set up. As I pass some input parameters to the function in the Zapier trigger, I can access to the input parameters in my python code by using variables…
2
votes
1 answer

How to use createResovers to convert a Markdown FIELD (not a file) to HTML in Gatsby

The standard process for converting MD to HTML in Gatsby is for complete files on the local system. I need to convert a specific field, NOT a file. The top related question is this one, but as you can see that is using Contentful, which now provides…
rmcsharry
  • 5,363
  • 6
  • 65
  • 108
2
votes
1 answer

React Table: Filtering specific columns within a Global Filter

I'm currently attempting to build an Airtable-esque filter component. I'm wondering if it is possible to use the useGlobalFilter hook to choose what columns to filter a table by programmatically. For example, Airtable implements table filtering…
kaeland
  • 191
  • 2
  • 9
2
votes
1 answer

Is there a component for a data grid like the one Notion and Airtable use?

The data grid that Notion and Airtable use for their table/database view is very nice and full of great features (like type specific columns, resizing, being beautiful, fast, excel-like): Is there a component (free or paid) that does the same as…
Rick Wolff
  • 769
  • 11
  • 25
2
votes
1 answer

How to get more than 100 rows using Airtable API using offest?

I am really new to the Airtable API and for some reason connecting the API this way did not work. at = airtable.Airtable('Base_Key', 'Airtable_Key') But I got it working this way - get_url =…
2
votes
2 answers

JSON data not displaying in Vuetify v-data-table using Axios

Can't get the JSON data to display. I'm receiving the data. Trying to take two of the fields from the JSON and put it in a v-data-table. In it's current form, the table generates and the correct # of rows appears for the # of records, but each…
majordomo
  • 1,160
  • 1
  • 15
  • 34
2
votes
1 answer

AirTable API Find record by email

I'm trying to see if a user exists by trying to find their email in the user's table, if it doesn't exist then I'm inserting the user. var Airtable = require('airtable'); var base = new Airtable({ apiKey: process.env.AIRTABLE_API_KEY…
Bill
  • 4,614
  • 13
  • 77
  • 132
2
votes
1 answer

trying to connect data pulled in from airtable into gatsby graphql to algolia, plugin not working

https://github.com/algolia/gatsby-plugin-algolia this plugin doesn't seem to be working in my gatsby-config when i run a build (doesn't populate my algolia index) -- i've already pushed data into my index using algoliasearch and a json file, but i…
Zach Mason
  • 125
  • 9
2
votes
0 answers

airtable python wrapper - passing API key not working

I'm trying to use airtable-python-wrapper but it's not accepting the API key when passed, as explained here: https://airtable-python-wrapper.readthedocs.io/en/master/authentication.html Code below: from airtable import Airtable base_key =…
T3metrics
  • 135
  • 2
  • 11
2
votes
3 answers

airtable get request 401 (Unauthorized)

I made a GET request to airtable table, but with the right key and right url he give me the 401 (Unauthorized) error. fetch("https://api.airtable.com/...") .then(response => response.json()) .then(data => { …
2
votes
1 answer

How to store a blob of JSON in Airtable?

There does not appear to be a dedicated field type in Airtable for "meta" data blobs and/or a JSON string. Is the "Attachment" type my best bet?
bugeats
  • 164
  • 2
  • 9
1
vote
2 answers

Regex extract - single string between commas&english only

I have strings that have random option name list, and I would like to extract only one option COLOR="" between the comma & " ". These options sometimes include different language letter so It must extract english only. Here we have four examples of…
Mulllu S
  • 23
  • 3
1
2
3
19 20