Skip to content

Instantly share code, notes, and snippets.

@arturmkrtchyan
Last active March 29, 2021 21:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arturmkrtchyan/68da52f662d3c2e28a58cbc02750f91e to your computer and use it in GitHub Desktop.
Save arturmkrtchyan/68da52f662d3c2e28a58cbc02750f91e to your computer and use it in GitHub Desktop.
Airtable API
{
"tables": [
{
"id": "tbl2g31JZOaP5v35E",
"name": "Jobs",
"primaryFieldId": "fldKWJFMfX27nTZAw",
"fields": [
{
"type": "singleLineText",
"id": "fldKWJFMfX27nTZAw",
"name": "Role Name"
},
{
"type": "multilineText",
"id": "fldj3BJf5lX6n5qVr",
"name": "Description"
},
{
"type": "multipleAttachments",
"id": "fldheU57tYIusePNr",
"name": "Attachments"
},
{
"type": "singleSelect",
"id": "fld2s0B0Ny2n9sahz",
"name": "Status"
},
{
"type": "checkbox",
"id": "fldwDYLvEXRANJI3M",
"name": "Active"
},
{
"type": "multipleSelects",
"id": "fldW9M7AcEg4kYgkz",
"name": "Job Category"
},
{
"type": "singleSelect",
"id": "fldEWYdTIoGoIfttK",
"name": "Department"
},
{
"type": "date",
"id": "fldGDLVFmvO4412zY",
"name": "Start Date"
},
{
"type": "phoneNumber",
"id": "fldoO1VtOlJSeKaeA",
"name": "Contact Phone"
},
{
"type": "email",
"id": "fldj7c5jpPnnrb7Ql",
"name": "Contact Email"
},
{
"type": "url",
"id": "fld7OsRKxj7uVtPEA",
"name": "Application Link"
},
{
"type": "currency",
"id": "fldNkOEsBvTxJyV3Q",
"name": "Salary"
},
{
"type": "multipleRecordLinks",
"id": "fldeRqWjFuf0nqxtj",
"name": "Manager"
},
{
"type": "multipleLookupValues",
"id": "fld4Kz7gAMfLjzWRa",
"name": "Manager Email"
},
{
"type": "autoNumber",
"id": "fldDezAhTSzulby3L",
"name": "ID"
},
{
"type": "barcode",
"id": "fldaPGWAPmWBGthNg",
"name": "Barcode"
},
{
"type": "rating",
"id": "fldeszsUZzWWRbknw",
"name": "Rating"
},
{
"type": "button",
"id": "fldo3APkS9PED2w3u",
"name": "Button"
}
],
"views": [
{
"id": "viwly2Tfmc1d3CFzc",
"name": "Grid view",
"type": "grid"
}
]
},
{
"id": "tblE3HfRImHrVWz10",
"name": "Managers",
"primaryFieldId": "fld1jjW2YcgFNw33w",
"fields": [
{
"type": "singleLineText",
"id": "fld1jjW2YcgFNw33w",
"name": "Name"
},
{
"type": "email",
"id": "fldEcW9bUcBFPca8u",
"name": "Email"
},
{
"type": "multipleRecordLinks",
"id": "fldevCtLcKOO7HveB",
"name": "Jobs"
}
],
"views": [
{
"id": "viwsNnMIJtPV7177W",
"name": "Grid view",
"type": "grid"
}
]
}
]
}
curl "https://api.airtable.com/v0/YOUR_BASE_ID/Jobs?maxRecords=3&view=Grid%20view" \
-H "Authorization: Bearer YOUR_API_KEY"
curl 'https://api.airtable.com/v0/meta/bases/YOUR_BASE_ID/tables' \
-H 'X-Airtable-Client-Secret: YOUR_CLIENT_SSECRET' \
-H 'Authorization: Bearer YOUR_API_KEY' \
-H 'content-type: application/json; charset=UTF-8'
{
"records": [
{
"id": "rec8sSNTiVSAdIsqt",
"fields": {
"Role Name": "Java Developer",
"Description": "Dummy description\n",
"Attachments": [
{
"id": "atterWKkPrqJtYr7o",
"url": "https://dl.airtable.com/.attachments/0454e584e19266b28b59806289ac3c1b/4e422739/ScreenShot2021-03-29at02.18.00.png",
"filename": "Screen Shot 2021-03-29 at 02.18.00.png",
"size": 26820,
"type": "image/png",
"thumbnails": {
"small": {
"url": "https://dl.airtable.com/.attachmentThumbnails/355661ddfae4f7e4e8141ea226ca2757/aa97bc9d",
"width": 153,
"height": 36
},
"large": {
"url": "https://dl.airtable.com/.attachmentThumbnails/f5e75c91be797995cff0255783a1a55f/d4b7f011",
"width": 536,
"height": 126
},
"full": {
"url": "https://dl.airtable.com/.attachmentThumbnails/1c502a706aa2ad943805d29f22507418/545fc2bd",
"width": 3000,
"height": 3000
}
}
}
],
"Status": "In Progress",
"Active": true,
"Job Category": [
"Remote"
],
"Department": "Engineering",
"Start Date": "2021-03-03",
"Contact Phone": "23213232312",
"Contact Email": "email@email.com",
"Application Link": "https://google.com",
"Salary": 10000,
"Manager": [
"recRahspK2Rt1RfYO"
],
"Manager Email": [
"james@test.com"
],
"ID": 1,
"Rating": 5,
"Button": {
"label": "Open URL",
"url": ""
}
},
"createdTime": "2021-03-29T21:10:47.000Z"
},
{
"id": "rec0Ef2XpXhZJzPDT",
"fields": {
"Role Name": "Python Developer",
"ID": 2,
"Button": {
"label": "Open URL",
"url": ""
}
},
"createdTime": "2021-03-29T21:10:47.000Z"
}
],
"offset": "rec0Ef2XpXhZJzPDT"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment