{"openapi":"3.0.0","info":{"description":"Cloud-based spreadsheet-database hybrid - organize anything with tables, views, and apps","version":[{"name":"v0","value":"0"}]},"servers":[{"description":"Cloud-based spreadsheet-database hybrid - organize anything with tables, views, and apps","url":"https://api.apirails.com/airtable"}],"paths":{"/{table_name_or_id}":{"get":{"tags":["Records"],"parameters":[{"name":"table_name_or_id","in":"path","description":"Table name or ID","required":true,"schema":{"type":"string","example":""}},{"name":"fields","in":"query","description":"Array of field names to include","required":false,"schema":{"type":"array","example":""}},{"name":"filterByFormula","in":"query","description":"Airtable formula to filter records","required":false,"schema":{"type":"string","example":""}},{"name":"maxRecords","in":"query","description":"Maximum number of records to return","required":false,"schema":{"type":"number","example":""}},{"name":"pageSize","in":"query","description":"Number of records per page (max 100)","required":false,"schema":{"type":"number","example":""}},{"name":"sort","in":"query","description":"Array of sort objects","required":false,"schema":{"type":"array","example":""}},{"name":"view","in":"query","description":"View name or ID to use for filtering/sorting","required":false,"schema":{"type":"string","example":""}},{"name":"cellFormat","in":"query","description":"Format for cell values","required":false,"schema":{"type":"string","example":"","items":{"type":"string","enum":["json","string"]}}},{"name":"timeZone","in":"query","description":"Time zone for date fields","required":false,"schema":{"type":"string","example":""}},{"name":"userLocale","in":"query","description":"User locale for formatting","required":false,"schema":{"type":"string","example":""}},{"name":"offset","in":"query","description":"Pagination offset token","required":false,"schema":{"type":"string","example":""}}],"responses":{"401":{"description":"Bearer token required (Authorization header)","content":{"application/json":{}}}},"externalDocs":{"api_ref":"https://airtable.com/developers/web/api/list-records","api_endpoint":"https://api.airtable.com/v0/{baseId}/{table_name_or_id}"},"summary":"List records","description":"List records from a table","security":[{"bearerAuth":[]}]},"post":{"tags":["Records"],"parameters":[{"name":"table_name_or_id","in":"path","description":"Table name or ID","required":true,"schema":{"type":"string","example":""}}],"responses":{"401":{"description":"Bearer token required (Authorization header)","content":{"application/json":{}}}},"externalDocs":{"api_ref":"https://airtable.com/developers/web/api/create-records","api_endpoint":"https://api.airtable.com/v0/{baseId}/{table_name_or_id}"},"summary":"Create a record","description":"Create a new record","security":[{"bearerAuth":[]}],"requestBody":{"description":"","required":true,"content":{"application/json":{"schema":{"type":"object","required":[],"properties":{"records":{"type":"array","description":"Array of records to create","required":true,"items":{"type":"string"}},"typecast":{"type":"boolean","description":"Auto-convert field values to correct types","enum":[true,false]},"returnFieldsByFieldId":{"type":"boolean","description":"Return fields by field ID instead of name","enum":[true,false]}}},"example":{"records":[],"typecast":"","returnFieldsByFieldId":""}}}}},"patch":{"tags":["Records"],"parameters":[{"name":"table_name_or_id","in":"path","description":"Table name or ID","required":true,"schema":{"type":"string","example":""}}],"responses":{"401":{"description":"Bearer token required (Authorization header)","content":{"application/json":{}}}},"externalDocs":{"api_ref":"https://airtable.com/developers/web/api/update-records","api_endpoint":"https://api.airtable.com/v0/{baseId}/{table_name_or_id}"},"summary":"Update multiple records","description":"Update multiple records at once","security":[{"bearerAuth":[]}],"requestBody":{"description":"","required":true,"content":{"application/json":{"schema":{"type":"object","required":[],"properties":{"records":{"type":"array","description":"Array of records to update (max 10)","required":true,"items":{"type":"string"}},"typecast":{"type":"boolean","description":"Auto-convert field values to correct types","enum":[true,false]},"returnFieldsByFieldId":{"type":"boolean","description":"Return fields by field ID instead of name","enum":[true,false]},"performUpsert":{"type":"object","description":"Upsert records based on field matching","properties":{}}}},"example":{"records":[],"typecast":"","returnFieldsByFieldId":"","performUpsert":{}}}}}},"delete":{"tags":["Records"],"parameters":[{"name":"table_name_or_id","in":"path","description":"Table name or ID","required":true,"schema":{"type":"string","example":""}},{"name":"records","in":"query","description":"Array of record IDs to delete","required":true,"schema":{"type":"array","example":""}}],"responses":{"401":{"description":"Bearer token required (Authorization header)","content":{"application/json":{}}}},"externalDocs":{"api_ref":"https://airtable.com/developers/web/api/delete-records","api_endpoint":"https://api.airtable.com/v0/{baseId}/{table_name_or_id}"},"summary":"Delete multiple records","description":"Delete multiple records at once","security":[{"bearerAuth":[]}],"requestBody":{"description":"","required":true,"content":{"application/json":{"schema":{"type":"object","required":[],"properties":{}},"example":{}}}}}},"/{table_name_or_id}/{record_id}":{"get":{"tags":["Records"],"parameters":[{"name":"table_name_or_id","in":"path","description":"Table name or ID","required":true,"schema":{"type":"string","example":""}},{"name":"record_id","in":"path","description":"Record ID (e.g., recXXXXXXXXXXXXXX)","required":true,"schema":{"type":"string","example":""}},{"name":"cellFormat","in":"query","description":"Format for cell values","required":false,"schema":{"type":"string","example":"","items":{"type":"string","enum":["json","string"]}}},{"name":"returnFieldsByFieldId","in":"query","description":"Return fields by field ID instead of name","required":false,"schema":{"type":"boolean","example":"","items":{"type":"string","enum":[true,false]}}},{"name":"timeZone","in":"query","description":"Time zone for date fields","required":false,"schema":{"type":"string","example":""}},{"name":"userLocale","in":"query","description":"User locale for formatting","required":false,"schema":{"type":"string","example":""}}],"responses":{"401":{"description":"Bearer token required (Authorization header)","content":{"application/json":{}}}},"externalDocs":{"api_ref":"https://airtable.com/developers/web/api/get-record","api_endpoint":"https://api.airtable.com/v0/{baseId}/{table_name_or_id}/{record_id}"},"summary":"Get a record","description":"Get a single record by ID","security":[{"bearerAuth":[]}]},"patch":{"tags":["Records"],"parameters":[{"name":"table_name_or_id","in":"path","description":"Table name or ID","required":true,"schema":{"type":"string","example":""}},{"name":"record_id","in":"path","description":"Record ID","required":true,"schema":{"type":"string","example":""}}],"responses":{"401":{"description":"Bearer token required (Authorization header)","content":{"application/json":{}}}},"externalDocs":{"api_ref":"https://airtable.com/developers/web/api/update-record","api_endpoint":"https://api.airtable.com/v0/{baseId}/{table_name_or_id}/{record_id}"},"summary":"Update a record","description":"Update specific fields in a record (PATCH)","security":[{"bearerAuth":[]}],"requestBody":{"description":"","required":true,"content":{"application/json":{"schema":{"type":"object","required":[],"properties":{"fields":{"type":"object","description":"Fields to update (only specified fields are changed)","required":true,"properties":{}},"typecast":{"type":"boolean","description":"Auto-convert field values to correct types","enum":[true,false]},"returnFieldsByFieldId":{"type":"boolean","description":"Return fields by field ID instead of name","enum":[true,false]}}},"example":{"fields":{},"typecast":"","returnFieldsByFieldId":""}}}}},"put":{"tags":["Records"],"parameters":[{"name":"table_name_or_id","in":"path","description":"Table name or ID","required":true,"schema":{"type":"string","example":""}},{"name":"record_id","in":"path","description":"Record ID","required":true,"schema":{"type":"string","example":""}}],"responses":{"401":{"description":"Bearer token required (Authorization header)","content":{"application/json":{}}}},"externalDocs":{"api_ref":"https://airtable.com/developers/web/api/update-record","api_endpoint":"https://api.airtable.com/v0/{baseId}/{table_name_or_id}/{record_id}"},"summary":"Replace a record","description":"Replace all fields in a record (PUT)","security":[{"bearerAuth":[]}],"requestBody":{"description":"","required":true,"content":{"application/json":{"schema":{"type":"object","required":[],"properties":{"fields":{"type":"object","description":"All fields for the record (unspecified fields are cleared)","required":true,"properties":{}},"typecast":{"type":"boolean","description":"Auto-convert field values to correct types","enum":[true,false]},"returnFieldsByFieldId":{"type":"boolean","description":"Return fields by field ID instead of name","enum":[true,false]}}},"example":{"fields":{},"typecast":"","returnFieldsByFieldId":""}}}}},"delete":{"tags":["Records"],"parameters":[{"name":"table_name_or_id","in":"path","description":"Table name or ID","required":true,"schema":{"type":"string","example":""}},{"name":"record_id","in":"path","description":"Record ID","required":true,"schema":{"type":"string","example":""}}],"responses":{"401":{"description":"Bearer token required (Authorization header)","content":{"application/json":{}}}},"externalDocs":{"api_ref":"https://airtable.com/developers/web/api/delete-record","api_endpoint":"https://api.airtable.com/v0/{baseId}/{table_name_or_id}/{record_id}"},"summary":"Delete a record","description":"Delete a record","security":[{"bearerAuth":[]}],"requestBody":{"description":"","required":true,"content":{"application/json":{"schema":{"type":"object","required":[],"properties":{}},"example":{}}}}}}},"components":{"securitySchemes":{"bearerAuth":{"type":"http","scheme":"bearer"}}},"security":[{"bearerAuth":[]}]}