Skip to content

Instantly share code, notes, and snippets.

@arturmkrtchyan

arturmkrtchyan/airtable_meta_api.json

Last active March 29, 2021 21:54
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save arturmkrtchyan/68da52f662d3c2e28a58cbc02750f91e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save arturmkrtchyan/68da52f662d3c2e28a58cbc02750f91e to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. arturmkrtchyan renamed this gist Mar 29, 2021. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → gistfile1.sh
    View file
    File renamed without changes.
  2. arturmkrtchyan revised this gist Mar 29, 2021. 2 changed files with 5 additions and 3 deletions.
    2 changes: 2 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,2 @@
    curl "https://api.airtable.com/v0/YOUR_BASE_ID/Jobs?maxRecords=3&view=Grid%20view" \
    -H "Authorization: Bearer YOUR_API_KEY"
    6 changes: 3 additions & 3 deletions meta_api_call.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    curl 'https://api.airtable.com/v0/meta/bases/{basseId}/tables' \
    -H 'X-Airtable-Client-Secret: {Client-Secret}' \
    -H 'Authorization: Bearer {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'
  3. arturmkrtchyan revised this gist Mar 29, 2021. 1 changed file with 74 additions and 0 deletions.
    74 changes: 74 additions & 0 deletions regular_api.json
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,74 @@
    {
    "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 protected]",
    "Application Link": "https://google.com",
    "Salary": 10000,
    "Manager": [
    "recRahspK2Rt1RfYO"
    ],
    "Manager Email": [
    "[email protected]"
    ],
    "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"
    }
  4. arturmkrtchyan revised this gist Mar 29, 2021. 1 changed file with 4 additions and 0 deletions.
    4 changes: 4 additions & 0 deletions meta_api_call.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,4 @@
    curl 'https://api.airtable.com/v0/meta/bases/{basseId}/tables' \
    -H 'X-Airtable-Client-Secret: {Client-Secret}' \
    -H 'Authorization: Bearer {API Key}' \
    -H 'content-type: application/json; charset=UTF-8'
  5. arturmkrtchyan revised this gist Mar 29, 2021. 2 changed files with 137 additions and 3 deletions.
    137 changes: 137 additions & 0 deletions airtable_meta_api.json
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,137 @@
    {
    "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"
    }
    ]
    }
    ]
    }
    3 changes: 0 additions & 3 deletions airtable_meta_api.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +0,0 @@
    ```JSON
    {"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"}]}]}
    ```
  6. arturmkrtchyan revised this gist Mar 29, 2021. No changes.
  7. arturmkrtchyan renamed this gist Mar 29, 2021. 1 changed file with 0 additions and 0 deletions.
    0 airtable_meta_api.json → airtable_meta_api.md
    View file
    File renamed without changes.
  8. arturmkrtchyan revised this gist Mar 29, 2021. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion airtable_meta_api.json
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1,3 @@
    {"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"}]}]}
    ```JSON
    {"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"}]}]}
    ```
  9. arturmkrtchyan created this gist Mar 29, 2021.
    1 change: 1 addition & 0 deletions airtable_meta_api.json
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    {"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"}]}]}