
Airtable Exporter
No credit card required

Airtable Exporter
No credit card required
💫 Export Dataset to Airtable
You can access the Airtable Exporter programmatically from your own applications by using the Apify API. You can choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.
1{
2 "openapi": "3.0.1",
3 "info": {
4 "version": "0.1",
5 "x-build-id": "Po9hWJge3PgcN4wFS"
6 },
7 "servers": [
8 {
9 "url": "https://api.apify.com/v2"
10 }
11 ],
12 "paths": {
13 "/acts/jupri~airtable-exporter/run-sync-get-dataset-items": {
14 "post": {
15 "operationId": "run-sync-get-dataset-items-jupri-airtable-exporter",
16 "x-openai-isConsequential": false,
17 "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.",
18 "tags": [
19 "Run Actor"
20 ],
21 "requestBody": {
22 "required": true,
23 "content": {
24 "application/json": {
25 "schema": {
26 "$ref": "#/components/schemas/inputSchema"
27 }
28 }
29 }
30 },
31 "parameters": [
32 {
33 "name": "token",
34 "in": "query",
35 "required": true,
36 "schema": {
37 "type": "string"
38 },
39 "description": "Enter your Apify token here"
40 }
41 ],
42 "responses": {
43 "200": {
44 "description": "OK"
45 }
46 }
47 }
48 },
49 "/acts/jupri~airtable-exporter/runs": {
50 "post": {
51 "operationId": "runs-sync-jupri-airtable-exporter",
52 "x-openai-isConsequential": false,
53 "summary": "Executes an Actor and returns information about the initiated run in response.",
54 "tags": [
55 "Run Actor"
56 ],
57 "requestBody": {
58 "required": true,
59 "content": {
60 "application/json": {
61 "schema": {
62 "$ref": "#/components/schemas/inputSchema"
63 }
64 }
65 }
66 },
67 "parameters": [
68 {
69 "name": "token",
70 "in": "query",
71 "required": true,
72 "schema": {
73 "type": "string"
74 },
75 "description": "Enter your Apify token here"
76 }
77 ],
78 "responses": {
79 "200": {
80 "description": "OK",
81 "content": {
82 "application/json": {
83 "schema": {
84 "$ref": "#/components/schemas/runsResponseSchema"
85 }
86 }
87 }
88 }
89 }
90 }
91 },
92 "/acts/jupri~airtable-exporter/run-sync": {
93 "post": {
94 "operationId": "run-sync-jupri-airtable-exporter",
95 "x-openai-isConsequential": false,
96 "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.",
97 "tags": [
98 "Run Actor"
99 ],
100 "requestBody": {
101 "required": true,
102 "content": {
103 "application/json": {
104 "schema": {
105 "$ref": "#/components/schemas/inputSchema"
106 }
107 }
108 }
109 },
110 "parameters": [
111 {
112 "name": "token",
113 "in": "query",
114 "required": true,
115 "schema": {
116 "type": "string"
117 },
118 "description": "Enter your Apify token here"
119 }
120 ],
121 "responses": {
122 "200": {
123 "description": "OK"
124 }
125 }
126 }
127 }
128 },
129 "components": {
130 "schemas": {
131 "inputSchema": {
132 "type": "object",
133 "properties": {
134 "dataset_id": {
135 "title": "Dataset ID",
136 "type": "string",
137 "description": "💡 APIFY Dataset ID"
138 },
139 "primary_key": {
140 "title": "Primary Key",
141 "type": "string",
142 "description": "💡 This is the table’s <b>primary field</b>. It cannot be hidden or moved. The name is meant to be a short, unique representation of each record in your table. <br><br><code>format: <i>root.branch.leaf.0.name</i><br>example: <i>product.id</i></code>"
143 },
144 "base_name": {
145 "title": "Base ID",
146 "type": "string",
147 "description": "💡 AIRTABLE Base name or ID <code><i>(appXXXXXXXXXX)</i></code> <i>(default: APIFY)</i>"
148 },
149 "table_name": {
150 "title": "Table Name",
151 "type": "string",
152 "description": "💡 AIRTABLE Table name. <i>(default: DATASET-<dataset_id>)</i>"
153 },
154 "update_mode": {
155 "title": "Update Mode",
156 "enum": [
157 "0",
158 "1"
159 ],
160 "type": "string",
161 "description": "💡 An <b>UPSERT</b> is a database operation that will update an existing row if a specified value already exists in a table, and insert a new row if the specified value doesn't already exist. <i><code>(require primary_key)</code></i>",
162 "default": "0"
163 },
164 "select_command": {
165 "title": "🔎 Select Command",
166 "enum": [
167 "include",
168 "exclude"
169 ],
170 "type": "string",
171 "description": ""
172 },
173 "select_fields": {
174 "title": "🏷️ Select Fields",
175 "type": "array",
176 "description": "💡 <p><b>Fields to include/exclude :</b></p><p><code>name</code> or <code>name.root.branch.leaf</code></p><p><b>Examples:</p><code>address</code><br><code>address.street</code><br><code>images.0.url</code>",
177 "items": {
178 "type": "string"
179 }
180 },
181 "column_order": {
182 "title": "🏷️ Column Order",
183 "type": "array",
184 "description": "💡 Select fields or Subfields that should display first, the rest of columns will be displayed in <a target=\"_blank\" href=\"https://en.wikipedia.org/wiki/Natural_sort_order\">natural sort ordering</a>.",
185 "items": {
186 "type": "string"
187 }
188 },
189 "clean_null": {
190 "title": "Remove NULL",
191 "type": "boolean",
192 "description": ""
193 },
194 "clean_zero": {
195 "title": "Remove ZERO",
196 "type": "boolean",
197 "description": ""
198 },
199 "clean_false": {
200 "title": "Remove FALSE",
201 "type": "boolean",
202 "description": ""
203 },
204 "clean_string": {
205 "title": "Remove empty STRING",
206 "type": "boolean",
207 "description": ""
208 },
209 "clean_space": {
210 "title": "Remove leading and trailing WHITESPACE",
211 "type": "boolean",
212 "description": ""
213 },
214 "clean_array": {
215 "title": "Remove empty ARRAY",
216 "type": "boolean",
217 "description": ""
218 },
219 "clean_object": {
220 "title": "Remove empty OBJECT",
221 "type": "boolean",
222 "description": ""
223 },
224 "clean_hash": {
225 "title": "Remove field starting with (#)",
226 "type": "boolean",
227 "description": ""
228 },
229 "clean_item": {
230 "title": "Remove empty ARRAY items",
231 "type": "boolean",
232 "description": ""
233 }
234 }
235 },
236 "runsResponseSchema": {
237 "type": "object",
238 "properties": {
239 "data": {
240 "type": "object",
241 "properties": {
242 "id": {
243 "type": "string"
244 },
245 "actId": {
246 "type": "string"
247 },
248 "userId": {
249 "type": "string"
250 },
251 "startedAt": {
252 "type": "string",
253 "format": "date-time",
254 "example": "2025-01-08T00:00:00.000Z"
255 },
256 "finishedAt": {
257 "type": "string",
258 "format": "date-time",
259 "example": "2025-01-08T00:00:00.000Z"
260 },
261 "status": {
262 "type": "string",
263 "example": "READY"
264 },
265 "meta": {
266 "type": "object",
267 "properties": {
268 "origin": {
269 "type": "string",
270 "example": "API"
271 },
272 "userAgent": {
273 "type": "string"
274 }
275 }
276 },
277 "stats": {
278 "type": "object",
279 "properties": {
280 "inputBodyLen": {
281 "type": "integer",
282 "example": 2000
283 },
284 "rebootCount": {
285 "type": "integer",
286 "example": 0
287 },
288 "restartCount": {
289 "type": "integer",
290 "example": 0
291 },
292 "resurrectCount": {
293 "type": "integer",
294 "example": 0
295 },
296 "computeUnits": {
297 "type": "integer",
298 "example": 0
299 }
300 }
301 },
302 "options": {
303 "type": "object",
304 "properties": {
305 "build": {
306 "type": "string",
307 "example": "latest"
308 },
309 "timeoutSecs": {
310 "type": "integer",
311 "example": 300
312 },
313 "memoryMbytes": {
314 "type": "integer",
315 "example": 1024
316 },
317 "diskMbytes": {
318 "type": "integer",
319 "example": 2048
320 }
321 }
322 },
323 "buildId": {
324 "type": "string"
325 },
326 "defaultKeyValueStoreId": {
327 "type": "string"
328 },
329 "defaultDatasetId": {
330 "type": "string"
331 },
332 "defaultRequestQueueId": {
333 "type": "string"
334 },
335 "buildNumber": {
336 "type": "string",
337 "example": "1.0.0"
338 },
339 "containerUrl": {
340 "type": "string"
341 },
342 "usage": {
343 "type": "object",
344 "properties": {
345 "ACTOR_COMPUTE_UNITS": {
346 "type": "integer",
347 "example": 0
348 },
349 "DATASET_READS": {
350 "type": "integer",
351 "example": 0
352 },
353 "DATASET_WRITES": {
354 "type": "integer",
355 "example": 0
356 },
357 "KEY_VALUE_STORE_READS": {
358 "type": "integer",
359 "example": 0
360 },
361 "KEY_VALUE_STORE_WRITES": {
362 "type": "integer",
363 "example": 1
364 },
365 "KEY_VALUE_STORE_LISTS": {
366 "type": "integer",
367 "example": 0
368 },
369 "REQUEST_QUEUE_READS": {
370 "type": "integer",
371 "example": 0
372 },
373 "REQUEST_QUEUE_WRITES": {
374 "type": "integer",
375 "example": 0
376 },
377 "DATA_TRANSFER_INTERNAL_GBYTES": {
378 "type": "integer",
379 "example": 0
380 },
381 "DATA_TRANSFER_EXTERNAL_GBYTES": {
382 "type": "integer",
383 "example": 0
384 },
385 "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
386 "type": "integer",
387 "example": 0
388 },
389 "PROXY_SERPS": {
390 "type": "integer",
391 "example": 0
392 }
393 }
394 },
395 "usageTotalUsd": {
396 "type": "number",
397 "example": 0.00005
398 },
399 "usageUsd": {
400 "type": "object",
401 "properties": {
402 "ACTOR_COMPUTE_UNITS": {
403 "type": "integer",
404 "example": 0
405 },
406 "DATASET_READS": {
407 "type": "integer",
408 "example": 0
409 },
410 "DATASET_WRITES": {
411 "type": "integer",
412 "example": 0
413 },
414 "KEY_VALUE_STORE_READS": {
415 "type": "integer",
416 "example": 0
417 },
418 "KEY_VALUE_STORE_WRITES": {
419 "type": "number",
420 "example": 0.00005
421 },
422 "KEY_VALUE_STORE_LISTS": {
423 "type": "integer",
424 "example": 0
425 },
426 "REQUEST_QUEUE_READS": {
427 "type": "integer",
428 "example": 0
429 },
430 "REQUEST_QUEUE_WRITES": {
431 "type": "integer",
432 "example": 0
433 },
434 "DATA_TRANSFER_INTERNAL_GBYTES": {
435 "type": "integer",
436 "example": 0
437 },
438 "DATA_TRANSFER_EXTERNAL_GBYTES": {
439 "type": "integer",
440 "example": 0
441 },
442 "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
443 "type": "integer",
444 "example": 0
445 },
446 "PROXY_SERPS": {
447 "type": "integer",
448 "example": 0
449 }
450 }
451 }
452 }
453 }
454 }
455 }
456 }
457 }
458}
Airtable Exporter OpenAPI definition
OpenAPI is a standard for designing and describing RESTful APIs, allowing developers to define API structure, endpoints, and data formats in a machine-readable way. It simplifies API development, integration, and documentation.
OpenAPI is effective when used with AI agents and GPTs by standardizing how these systems interact with various APIs, for reliable integrations and efficient communication.
By defining machine-readable API specifications, OpenAPI allows AI models like GPTs to understand and use varied data sources, improving accuracy. This accelerates development, reduces errors, and provides context-aware responses, making OpenAPI a core component for AI applications.
You can download the OpenAPI definitions for Airtable Exporter from the options below:
If you’d like to learn more about how OpenAPI powers GPTs, read our blog post.
You can also check out our other API clients:
Actor Metrics
8 monthly users
-
9 bookmarks
80% runs succeeded
17 hours response time
Created in May 2023
Modified 3 months ago