Initialize airtable sandbox with data
curl --request POST \
--url https://api.klavis.ai/sandbox/airtable/{sandbox_id}/initialize \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data @- <<EOF
{
"tables": [
{
"name": "Projects",
"description": "Track all projects and their details",
"fields": [
{
"name": "Name",
"type": "singleLineText"
},
{
"name": "Status",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Planning"
},
{
"name": "In Progress"
},
{
"name": "On Hold"
},
{
"name": "Completed"
}
]
}
},
{
"name": "Description",
"type": "multilineText"
},
{
"name": "Start Date",
"type": "date"
},
{
"name": "Due Date",
"type": "date"
},
{
"name": "Budget",
"type": "number"
},
{
"name": "Priority",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "High"
},
{
"name": "Medium"
},
{
"name": "Low"
}
]
}
},
{
"name": "Tasks",
"type": "multipleRecordLinks"
}
],
"records": [
{
"fields": {
"Name": "Website Redesign",
"Status": "In Progress",
"Description": "Complete overhaul of company website with modern design and improved UX",
"Start Date": "2024-01-15",
"Due Date": "2024-03-30",
"Budget": 50000,
"Priority": "High"
}
},
{
"fields": {
"Name": "Mobile App Development",
"Status": "Planning",
"Description": "Develop iOS and Android mobile applications for customer engagement",
"Start Date": "2024-02-01",
"Due Date": "2024-06-30",
"Budget": 120000,
"Priority": "High"
}
},
{
"fields": {
"Name": "Marketing Campaign Q1",
"Status": "In Progress",
"Description": "Launch social media and email marketing campaign for Q1",
"Start Date": "2024-01-01",
"Due Date": "2024-03-31",
"Budget": 25000,
"Priority": "Medium"
}
},
{
"fields": {
"Name": "Infrastructure Upgrade",
"Status": "Planning",
"Description": "Upgrade cloud infrastructure and migrate to Kubernetes",
"Start Date": "2024-03-01",
"Due Date": "2024-05-31",
"Budget": 75000,
"Priority": "High"
}
},
{
"fields": {
"Name": "Customer Support Portal",
"Status": "On Hold",
"Description": "Build self-service customer support portal with knowledge base",
"Start Date": "2024-01-20",
"Due Date": "2024-04-30",
"Budget": 30000,
"Priority": "Low"
}
}
]
},
{
"name": "Tasks",
"description": "Individual tasks and action items",
"fields": [
{
"name": "Task Name",
"type": "singleLineText"
},
{
"name": "Description",
"type": "multilineText"
},
{
"name": "Status",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "To Do"
},
{
"name": "In Progress"
},
{
"name": "Review"
},
{
"name": "Done"
}
]
}
},
{
"name": "Assignee",
"type": "singleLineText"
},
{
"name": "Due Date",
"type": "date"
},
{
"name": "Priority",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Critical"
},
{
"name": "High"
},
{
"name": "Medium"
},
{
"name": "Low"
}
]
}
},
{
"name": "Estimated Hours",
"type": "number"
},
{
"name": "Completed",
"type": "checkbox"
},
{
"name": "Project",
"type": "multipleRecordLinks"
}
],
"records": [
{
"fields": {
"Task Name": "Design homepage mockup",
"Description": "Create high-fidelity mockups for the new homepage layout",
"Status": "In Progress",
"Assignee": "Sarah Johnson",
"Due Date": "2024-02-15",
"Priority": "High",
"Estimated Hours": 16,
"Completed": false
}
},
{
"fields": {
"Task Name": "Set up development environment",
"Description": "Configure local dev environment with all necessary tools",
"Status": "Done",
"Assignee": "Mike Chen",
"Due Date": "2024-01-20",
"Priority": "High",
"Estimated Hours": 8,
"Completed": true
}
},
{
"fields": {
"Task Name": "Conduct user research",
"Description": "Interview 20 users about their needs and pain points",
"Status": "In Progress",
"Assignee": "Emily Rodriguez",
"Due Date": "2024-02-28",
"Priority": "Medium",
"Estimated Hours": 40,
"Completed": false
}
},
{
"fields": {
"Task Name": "Write API documentation",
"Description": "Document all API endpoints with examples and parameters",
"Status": "To Do",
"Assignee": "David Lee",
"Due Date": "2024-03-10",
"Priority": "Medium",
"Estimated Hours": 24,
"Completed": false
}
},
{
"fields": {
"Task Name": "Implement authentication system",
"Description": "Build OAuth2 authentication with JWT tokens",
"Status": "In Progress",
"Assignee": "Mike Chen",
"Due Date": "2024-02-25",
"Priority": "Critical",
"Estimated Hours": 32,
"Completed": false
}
},
{
"fields": {
"Task Name": "Create social media content calendar",
"Description": "Plan content for Twitter, LinkedIn, and Instagram for Q1",
"Status": "Review",
"Assignee": "Amanda White",
"Due Date": "2024-02-05",
"Priority": "High",
"Estimated Hours": 12,
"Completed": false
}
},
{
"fields": {
"Task Name": "Deploy staging environment",
"Description": "Set up staging server for QA testing",
"Status": "Done",
"Assignee": "Robert Garcia",
"Due Date": "2024-01-25",
"Priority": "High",
"Estimated Hours": 6,
"Completed": true
}
},
{
"fields": {
"Task Name": "Database schema design",
"Description": "Design normalized database schema for new features",
"Status": "Review",
"Assignee": "David Lee",
"Due Date": "2024-02-10",
"Priority": "Critical",
"Estimated Hours": 20,
"Completed": false
}
}
]
},
{
"name": "Team Members",
"description": "Team directory with contact information",
"fields": [
{
"name": "Full Name",
"type": "singleLineText"
},
{
"name": "Email",
"type": "email"
},
{
"name": "Phone",
"type": "phoneNumber"
},
{
"name": "Role",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Developer"
},
{
"name": "Designer"
},
{
"name": "Product Manager"
},
{
"name": "Marketing"
},
{
"name": "DevOps"
}
]
}
},
{
"name": "Department",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Engineering"
},
{
"name": "Design"
},
{
"name": "Product"
},
{
"name": "Marketing"
},
{
"name": "Operations"
}
]
}
},
{
"name": "Start Date",
"type": "date"
},
{
"name": "Active",
"type": "checkbox"
},
{
"name": "Profile Picture",
"type": "url"
}
],
"records": [
{
"fields": {
"Full Name": "Sarah Johnson",
"Email": "sarah.johnson@example.com",
"Phone": "+1-555-0101",
"Role": "Designer",
"Department": "Design",
"Start Date": "2022-03-15",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=1"
}
},
{
"fields": {
"Full Name": "Mike Chen",
"Email": "mike.chen@example.com",
"Phone": "+1-555-0102",
"Role": "Developer",
"Department": "Engineering",
"Start Date": "2021-06-01",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=13"
}
},
{
"fields": {
"Full Name": "Emily Rodriguez",
"Email": "emily.rodriguez@example.com",
"Phone": "+1-555-0103",
"Role": "Product Manager",
"Department": "Product",
"Start Date": "2020-09-10",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=5"
}
},
{
"fields": {
"Full Name": "David Lee",
"Email": "david.lee@example.com",
"Phone": "+1-555-0104",
"Role": "Developer",
"Department": "Engineering",
"Start Date": "2023-01-20",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=12"
}
},
{
"fields": {
"Full Name": "Amanda White",
"Email": "amanda.white@example.com",
"Phone": "+1-555-0105",
"Role": "Marketing",
"Department": "Marketing",
"Start Date": "2022-11-05",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=10"
}
},
{
"fields": {
"Full Name": "Robert Garcia",
"Email": "robert.garcia@example.com",
"Phone": "+1-555-0106",
"Role": "DevOps",
"Department": "Operations",
"Start Date": "2021-02-28",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=15"
}
}
]
},
{
"name": "Meetings",
"description": "Schedule and track team meetings",
"fields": [
{
"name": "Meeting Title",
"type": "singleLineText"
},
{
"name": "Date",
"type": "date"
},
{
"name": "Duration (minutes)",
"type": "number"
},
{
"name": "Type",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Stand-up"
},
{
"name": "Planning"
},
{
"name": "Review"
},
{
"name": "Retrospective"
},
{
"name": "One-on-One"
}
]
}
},
{
"name": "Attendees",
"type": "multilineText"
},
{
"name": "Notes",
"type": "multilineText"
},
{
"name": "Action Items",
"type": "multilineText"
},
{
"name": "Recording URL",
"type": "url"
}
],
"records": [
{
"fields": {
"Meeting Title": "Weekly Team Stand-up",
"Date": "2024-02-05",
"Duration (minutes)": 30,
"Type": "Stand-up",
"Attendees": "Sarah, Mike, Emily, David, Amanda, Robert",
"Notes": "Discussed progress on current sprint. Team velocity is good. No major blockers.",
"Action Items": "- Mike to review David's PR\n- Sarah to finalize designs by EOD\n- Emily to schedule client demo"
}
},
{
"fields": {
"Meeting Title": "Sprint Planning - Sprint 5",
"Date": "2024-02-01",
"Duration (minutes)": 120,
"Type": "Planning",
"Attendees": "All team members",
"Notes": "Planned 25 story points for the upcoming sprint. Focus on authentication and API development.",
"Action Items": "- Break down epic into smaller tasks\n- Update story estimates\n- Assign tasks to team members",
"Recording URL": "https://zoom.us/rec/example123"
}
},
{
"fields": {
"Meeting Title": "Design Review - Homepage",
"Date": "2024-02-03",
"Duration (minutes)": 60,
"Type": "Review",
"Attendees": "Sarah, Emily, Mike",
"Notes": "Reviewed new homepage designs. Overall positive feedback. Some minor adjustments needed.",
"Action Items": "- Sarah to update color palette\n- Increase font size for headings\n- Add more whitespace in hero section"
}
},
{
"fields": {
"Meeting Title": "1:1 - Emily & Mike",
"Date": "2024-02-02",
"Duration (minutes)": 30,
"Type": "One-on-One",
"Attendees": "Emily, Mike",
"Notes": "Discussed career growth and upcoming projects. Mike interested in learning more about system architecture.",
"Action Items": "- Emily to share architecture resources\n- Mike to shadow senior architect next month"
}
}
]
}
]
}
EOFimport requests
url = "https://api.klavis.ai/sandbox/airtable/{sandbox_id}/initialize"
payload = { "tables": [
{
"name": "Projects",
"description": "Track all projects and their details",
"fields": [
{
"name": "Name",
"type": "singleLineText"
},
{
"name": "Status",
"type": "singleSelect",
"options": { "choices": [{ "name": "Planning" }, { "name": "In Progress" }, { "name": "On Hold" }, { "name": "Completed" }] }
},
{
"name": "Description",
"type": "multilineText"
},
{
"name": "Start Date",
"type": "date"
},
{
"name": "Due Date",
"type": "date"
},
{
"name": "Budget",
"type": "number"
},
{
"name": "Priority",
"type": "singleSelect",
"options": { "choices": [{ "name": "High" }, { "name": "Medium" }, { "name": "Low" }] }
},
{
"name": "Tasks",
"type": "multipleRecordLinks"
}
],
"records": [{ "fields": {
"Name": "Website Redesign",
"Status": "In Progress",
"Description": "Complete overhaul of company website with modern design and improved UX",
"Start Date": "2024-01-15",
"Due Date": "2024-03-30",
"Budget": 50000,
"Priority": "High"
} }, { "fields": {
"Name": "Mobile App Development",
"Status": "Planning",
"Description": "Develop iOS and Android mobile applications for customer engagement",
"Start Date": "2024-02-01",
"Due Date": "2024-06-30",
"Budget": 120000,
"Priority": "High"
} }, { "fields": {
"Name": "Marketing Campaign Q1",
"Status": "In Progress",
"Description": "Launch social media and email marketing campaign for Q1",
"Start Date": "2024-01-01",
"Due Date": "2024-03-31",
"Budget": 25000,
"Priority": "Medium"
} }, { "fields": {
"Name": "Infrastructure Upgrade",
"Status": "Planning",
"Description": "Upgrade cloud infrastructure and migrate to Kubernetes",
"Start Date": "2024-03-01",
"Due Date": "2024-05-31",
"Budget": 75000,
"Priority": "High"
} }, { "fields": {
"Name": "Customer Support Portal",
"Status": "On Hold",
"Description": "Build self-service customer support portal with knowledge base",
"Start Date": "2024-01-20",
"Due Date": "2024-04-30",
"Budget": 30000,
"Priority": "Low"
} }]
},
{
"name": "Tasks",
"description": "Individual tasks and action items",
"fields": [
{
"name": "Task Name",
"type": "singleLineText"
},
{
"name": "Description",
"type": "multilineText"
},
{
"name": "Status",
"type": "singleSelect",
"options": { "choices": [{ "name": "To Do" }, { "name": "In Progress" }, { "name": "Review" }, { "name": "Done" }] }
},
{
"name": "Assignee",
"type": "singleLineText"
},
{
"name": "Due Date",
"type": "date"
},
{
"name": "Priority",
"type": "singleSelect",
"options": { "choices": [{ "name": "Critical" }, { "name": "High" }, { "name": "Medium" }, { "name": "Low" }] }
},
{
"name": "Estimated Hours",
"type": "number"
},
{
"name": "Completed",
"type": "checkbox"
},
{
"name": "Project",
"type": "multipleRecordLinks"
}
],
"records": [{ "fields": {
"Task Name": "Design homepage mockup",
"Description": "Create high-fidelity mockups for the new homepage layout",
"Status": "In Progress",
"Assignee": "Sarah Johnson",
"Due Date": "2024-02-15",
"Priority": "High",
"Estimated Hours": 16,
"Completed": False
} }, { "fields": {
"Task Name": "Set up development environment",
"Description": "Configure local dev environment with all necessary tools",
"Status": "Done",
"Assignee": "Mike Chen",
"Due Date": "2024-01-20",
"Priority": "High",
"Estimated Hours": 8,
"Completed": True
} }, { "fields": {
"Task Name": "Conduct user research",
"Description": "Interview 20 users about their needs and pain points",
"Status": "In Progress",
"Assignee": "Emily Rodriguez",
"Due Date": "2024-02-28",
"Priority": "Medium",
"Estimated Hours": 40,
"Completed": False
} }, { "fields": {
"Task Name": "Write API documentation",
"Description": "Document all API endpoints with examples and parameters",
"Status": "To Do",
"Assignee": "David Lee",
"Due Date": "2024-03-10",
"Priority": "Medium",
"Estimated Hours": 24,
"Completed": False
} }, { "fields": {
"Task Name": "Implement authentication system",
"Description": "Build OAuth2 authentication with JWT tokens",
"Status": "In Progress",
"Assignee": "Mike Chen",
"Due Date": "2024-02-25",
"Priority": "Critical",
"Estimated Hours": 32,
"Completed": False
} }, { "fields": {
"Task Name": "Create social media content calendar",
"Description": "Plan content for Twitter, LinkedIn, and Instagram for Q1",
"Status": "Review",
"Assignee": "Amanda White",
"Due Date": "2024-02-05",
"Priority": "High",
"Estimated Hours": 12,
"Completed": False
} }, { "fields": {
"Task Name": "Deploy staging environment",
"Description": "Set up staging server for QA testing",
"Status": "Done",
"Assignee": "Robert Garcia",
"Due Date": "2024-01-25",
"Priority": "High",
"Estimated Hours": 6,
"Completed": True
} }, { "fields": {
"Task Name": "Database schema design",
"Description": "Design normalized database schema for new features",
"Status": "Review",
"Assignee": "David Lee",
"Due Date": "2024-02-10",
"Priority": "Critical",
"Estimated Hours": 20,
"Completed": False
} }]
},
{
"name": "Team Members",
"description": "Team directory with contact information",
"fields": [
{
"name": "Full Name",
"type": "singleLineText"
},
{
"name": "Email",
"type": "email"
},
{
"name": "Phone",
"type": "phoneNumber"
},
{
"name": "Role",
"type": "singleSelect",
"options": { "choices": [{ "name": "Developer" }, { "name": "Designer" }, { "name": "Product Manager" }, { "name": "Marketing" }, { "name": "DevOps" }] }
},
{
"name": "Department",
"type": "singleSelect",
"options": { "choices": [{ "name": "Engineering" }, { "name": "Design" }, { "name": "Product" }, { "name": "Marketing" }, { "name": "Operations" }] }
},
{
"name": "Start Date",
"type": "date"
},
{
"name": "Active",
"type": "checkbox"
},
{
"name": "Profile Picture",
"type": "url"
}
],
"records": [{ "fields": {
"Full Name": "Sarah Johnson",
"Email": "sarah.johnson@example.com",
"Phone": "+1-555-0101",
"Role": "Designer",
"Department": "Design",
"Start Date": "2022-03-15",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=1"
} }, { "fields": {
"Full Name": "Mike Chen",
"Email": "mike.chen@example.com",
"Phone": "+1-555-0102",
"Role": "Developer",
"Department": "Engineering",
"Start Date": "2021-06-01",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=13"
} }, { "fields": {
"Full Name": "Emily Rodriguez",
"Email": "emily.rodriguez@example.com",
"Phone": "+1-555-0103",
"Role": "Product Manager",
"Department": "Product",
"Start Date": "2020-09-10",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=5"
} }, { "fields": {
"Full Name": "David Lee",
"Email": "david.lee@example.com",
"Phone": "+1-555-0104",
"Role": "Developer",
"Department": "Engineering",
"Start Date": "2023-01-20",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=12"
} }, { "fields": {
"Full Name": "Amanda White",
"Email": "amanda.white@example.com",
"Phone": "+1-555-0105",
"Role": "Marketing",
"Department": "Marketing",
"Start Date": "2022-11-05",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=10"
} }, { "fields": {
"Full Name": "Robert Garcia",
"Email": "robert.garcia@example.com",
"Phone": "+1-555-0106",
"Role": "DevOps",
"Department": "Operations",
"Start Date": "2021-02-28",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=15"
} }]
},
{
"name": "Meetings",
"description": "Schedule and track team meetings",
"fields": [
{
"name": "Meeting Title",
"type": "singleLineText"
},
{
"name": "Date",
"type": "date"
},
{
"name": "Duration (minutes)",
"type": "number"
},
{
"name": "Type",
"type": "singleSelect",
"options": { "choices": [{ "name": "Stand-up" }, { "name": "Planning" }, { "name": "Review" }, { "name": "Retrospective" }, { "name": "One-on-One" }] }
},
{
"name": "Attendees",
"type": "multilineText"
},
{
"name": "Notes",
"type": "multilineText"
},
{
"name": "Action Items",
"type": "multilineText"
},
{
"name": "Recording URL",
"type": "url"
}
],
"records": [{ "fields": {
"Meeting Title": "Weekly Team Stand-up",
"Date": "2024-02-05",
"Duration (minutes)": 30,
"Type": "Stand-up",
"Attendees": "Sarah, Mike, Emily, David, Amanda, Robert",
"Notes": "Discussed progress on current sprint. Team velocity is good. No major blockers.",
"Action Items": "- Mike to review David's PR
- Sarah to finalize designs by EOD
- Emily to schedule client demo"
} }, { "fields": {
"Meeting Title": "Sprint Planning - Sprint 5",
"Date": "2024-02-01",
"Duration (minutes)": 120,
"Type": "Planning",
"Attendees": "All team members",
"Notes": "Planned 25 story points for the upcoming sprint. Focus on authentication and API development.",
"Action Items": "- Break down epic into smaller tasks
- Update story estimates
- Assign tasks to team members",
"Recording URL": "https://zoom.us/rec/example123"
} }, { "fields": {
"Meeting Title": "Design Review - Homepage",
"Date": "2024-02-03",
"Duration (minutes)": 60,
"Type": "Review",
"Attendees": "Sarah, Emily, Mike",
"Notes": "Reviewed new homepage designs. Overall positive feedback. Some minor adjustments needed.",
"Action Items": "- Sarah to update color palette
- Increase font size for headings
- Add more whitespace in hero section"
} }, { "fields": {
"Meeting Title": "1:1 - Emily & Mike",
"Date": "2024-02-02",
"Duration (minutes)": 30,
"Type": "One-on-One",
"Attendees": "Emily, Mike",
"Notes": "Discussed career growth and upcoming projects. Mike interested in learning more about system architecture.",
"Action Items": "- Emily to share architecture resources
- Mike to shadow senior architect next month"
} }]
}
] }
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
tables: [
{
name: 'Projects',
description: 'Track all projects and their details',
fields: [
{name: 'Name', type: 'singleLineText'},
{
name: 'Status',
type: 'singleSelect',
options: {
choices: [
{name: 'Planning'},
{name: 'In Progress'},
{name: 'On Hold'},
{name: 'Completed'}
]
}
},
{name: 'Description', type: 'multilineText'},
{name: 'Start Date', type: 'date'},
{name: 'Due Date', type: 'date'},
{name: 'Budget', type: 'number'},
{
name: 'Priority',
type: 'singleSelect',
options: {choices: [{name: 'High'}, {name: 'Medium'}, {name: 'Low'}]}
},
{name: 'Tasks', type: 'multipleRecordLinks'}
],
records: [
{
fields: {
Name: 'Website Redesign',
Status: 'In Progress',
Description: 'Complete overhaul of company website with modern design and improved UX',
'Start Date': '2024-01-15',
'Due Date': '2024-03-30',
Budget: 50000,
Priority: 'High'
}
},
{
fields: {
Name: 'Mobile App Development',
Status: 'Planning',
Description: 'Develop iOS and Android mobile applications for customer engagement',
'Start Date': '2024-02-01',
'Due Date': '2024-06-30',
Budget: 120000,
Priority: 'High'
}
},
{
fields: {
Name: 'Marketing Campaign Q1',
Status: 'In Progress',
Description: 'Launch social media and email marketing campaign for Q1',
'Start Date': '2024-01-01',
'Due Date': '2024-03-31',
Budget: 25000,
Priority: 'Medium'
}
},
{
fields: {
Name: 'Infrastructure Upgrade',
Status: 'Planning',
Description: 'Upgrade cloud infrastructure and migrate to Kubernetes',
'Start Date': '2024-03-01',
'Due Date': '2024-05-31',
Budget: 75000,
Priority: 'High'
}
},
{
fields: {
Name: 'Customer Support Portal',
Status: 'On Hold',
Description: 'Build self-service customer support portal with knowledge base',
'Start Date': '2024-01-20',
'Due Date': '2024-04-30',
Budget: 30000,
Priority: 'Low'
}
}
]
},
{
name: 'Tasks',
description: 'Individual tasks and action items',
fields: [
{name: 'Task Name', type: 'singleLineText'},
{name: 'Description', type: 'multilineText'},
{
name: 'Status',
type: 'singleSelect',
options: {
choices: [{name: 'To Do'}, {name: 'In Progress'}, {name: 'Review'}, {name: 'Done'}]
}
},
{name: 'Assignee', type: 'singleLineText'},
{name: 'Due Date', type: 'date'},
{
name: 'Priority',
type: 'singleSelect',
options: {choices: [{name: 'Critical'}, {name: 'High'}, {name: 'Medium'}, {name: 'Low'}]}
},
{name: 'Estimated Hours', type: 'number'},
{name: 'Completed', type: 'checkbox'},
{name: 'Project', type: 'multipleRecordLinks'}
],
records: [
{
fields: {
'Task Name': 'Design homepage mockup',
Description: 'Create high-fidelity mockups for the new homepage layout',
Status: 'In Progress',
Assignee: 'Sarah Johnson',
'Due Date': '2024-02-15',
Priority: 'High',
'Estimated Hours': 16,
Completed: false
}
},
{
fields: {
'Task Name': 'Set up development environment',
Description: 'Configure local dev environment with all necessary tools',
Status: 'Done',
Assignee: 'Mike Chen',
'Due Date': '2024-01-20',
Priority: 'High',
'Estimated Hours': 8,
Completed: true
}
},
{
fields: {
'Task Name': 'Conduct user research',
Description: 'Interview 20 users about their needs and pain points',
Status: 'In Progress',
Assignee: 'Emily Rodriguez',
'Due Date': '2024-02-28',
Priority: 'Medium',
'Estimated Hours': 40,
Completed: false
}
},
{
fields: {
'Task Name': 'Write API documentation',
Description: 'Document all API endpoints with examples and parameters',
Status: 'To Do',
Assignee: 'David Lee',
'Due Date': '2024-03-10',
Priority: 'Medium',
'Estimated Hours': 24,
Completed: false
}
},
{
fields: {
'Task Name': 'Implement authentication system',
Description: 'Build OAuth2 authentication with JWT tokens',
Status: 'In Progress',
Assignee: 'Mike Chen',
'Due Date': '2024-02-25',
Priority: 'Critical',
'Estimated Hours': 32,
Completed: false
}
},
{
fields: {
'Task Name': 'Create social media content calendar',
Description: 'Plan content for Twitter, LinkedIn, and Instagram for Q1',
Status: 'Review',
Assignee: 'Amanda White',
'Due Date': '2024-02-05',
Priority: 'High',
'Estimated Hours': 12,
Completed: false
}
},
{
fields: {
'Task Name': 'Deploy staging environment',
Description: 'Set up staging server for QA testing',
Status: 'Done',
Assignee: 'Robert Garcia',
'Due Date': '2024-01-25',
Priority: 'High',
'Estimated Hours': 6,
Completed: true
}
},
{
fields: {
'Task Name': 'Database schema design',
Description: 'Design normalized database schema for new features',
Status: 'Review',
Assignee: 'David Lee',
'Due Date': '2024-02-10',
Priority: 'Critical',
'Estimated Hours': 20,
Completed: false
}
}
]
},
{
name: 'Team Members',
description: 'Team directory with contact information',
fields: [
{name: 'Full Name', type: 'singleLineText'},
{name: 'Email', type: 'email'},
{name: 'Phone', type: 'phoneNumber'},
{
name: 'Role',
type: 'singleSelect',
options: {
choices: [
{name: 'Developer'},
{name: 'Designer'},
{name: 'Product Manager'},
{name: 'Marketing'},
{name: 'DevOps'}
]
}
},
{
name: 'Department',
type: 'singleSelect',
options: {
choices: [
{name: 'Engineering'},
{name: 'Design'},
{name: 'Product'},
{name: 'Marketing'},
{name: 'Operations'}
]
}
},
{name: 'Start Date', type: 'date'},
{name: 'Active', type: 'checkbox'},
{name: 'Profile Picture', type: 'url'}
],
records: [
{
fields: {
'Full Name': 'Sarah Johnson',
Email: 'sarah.johnson@example.com',
Phone: '+1-555-0101',
Role: 'Designer',
Department: 'Design',
'Start Date': '2022-03-15',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=1'
}
},
{
fields: {
'Full Name': 'Mike Chen',
Email: 'mike.chen@example.com',
Phone: '+1-555-0102',
Role: 'Developer',
Department: 'Engineering',
'Start Date': '2021-06-01',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=13'
}
},
{
fields: {
'Full Name': 'Emily Rodriguez',
Email: 'emily.rodriguez@example.com',
Phone: '+1-555-0103',
Role: 'Product Manager',
Department: 'Product',
'Start Date': '2020-09-10',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=5'
}
},
{
fields: {
'Full Name': 'David Lee',
Email: 'david.lee@example.com',
Phone: '+1-555-0104',
Role: 'Developer',
Department: 'Engineering',
'Start Date': '2023-01-20',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=12'
}
},
{
fields: {
'Full Name': 'Amanda White',
Email: 'amanda.white@example.com',
Phone: '+1-555-0105',
Role: 'Marketing',
Department: 'Marketing',
'Start Date': '2022-11-05',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=10'
}
},
{
fields: {
'Full Name': 'Robert Garcia',
Email: 'robert.garcia@example.com',
Phone: '+1-555-0106',
Role: 'DevOps',
Department: 'Operations',
'Start Date': '2021-02-28',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=15'
}
}
]
},
{
name: 'Meetings',
description: 'Schedule and track team meetings',
fields: [
{name: 'Meeting Title', type: 'singleLineText'},
{name: 'Date', type: 'date'},
{name: 'Duration (minutes)', type: 'number'},
{
name: 'Type',
type: 'singleSelect',
options: {
choices: [
{name: 'Stand-up'},
{name: 'Planning'},
{name: 'Review'},
{name: 'Retrospective'},
{name: 'One-on-One'}
]
}
},
{name: 'Attendees', type: 'multilineText'},
{name: 'Notes', type: 'multilineText'},
{name: 'Action Items', type: 'multilineText'},
{name: 'Recording URL', type: 'url'}
],
records: [
{
fields: {
'Meeting Title': 'Weekly Team Stand-up',
Date: '2024-02-05',
'Duration (minutes)': 30,
Type: 'Stand-up',
Attendees: 'Sarah, Mike, Emily, David, Amanda, Robert',
Notes: 'Discussed progress on current sprint. Team velocity is good. No major blockers.',
'Action Items': '- Mike to review David\'s PR\n- Sarah to finalize designs by EOD\n- Emily to schedule client demo'
}
},
{
fields: {
'Meeting Title': 'Sprint Planning - Sprint 5',
Date: '2024-02-01',
'Duration (minutes)': 120,
Type: 'Planning',
Attendees: 'All team members',
Notes: 'Planned 25 story points for the upcoming sprint. Focus on authentication and API development.',
'Action Items': '- Break down epic into smaller tasks\n- Update story estimates\n- Assign tasks to team members',
'Recording URL': 'https://zoom.us/rec/example123'
}
},
{
fields: {
'Meeting Title': 'Design Review - Homepage',
Date: '2024-02-03',
'Duration (minutes)': 60,
Type: 'Review',
Attendees: 'Sarah, Emily, Mike',
Notes: 'Reviewed new homepage designs. Overall positive feedback. Some minor adjustments needed.',
'Action Items': '- Sarah to update color palette\n- Increase font size for headings\n- Add more whitespace in hero section'
}
},
{
fields: {
'Meeting Title': '1:1 - Emily & Mike',
Date: '2024-02-02',
'Duration (minutes)': 30,
Type: 'One-on-One',
Attendees: 'Emily, Mike',
Notes: 'Discussed career growth and upcoming projects. Mike interested in learning more about system architecture.',
'Action Items': '- Emily to share architecture resources\n- Mike to shadow senior architect next month'
}
}
]
}
]
})
};
fetch('https://api.klavis.ai/sandbox/airtable/{sandbox_id}/initialize', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
tables: [
{
name: 'Projects',
description: 'Track all projects and their details',
fields: [
{name: 'Name', type: 'singleLineText'},
{
name: 'Status',
type: 'singleSelect',
options: {
choices: [
{name: 'Planning'},
{name: 'In Progress'},
{name: 'On Hold'},
{name: 'Completed'}
]
}
},
{name: 'Description', type: 'multilineText'},
{name: 'Start Date', type: 'date'},
{name: 'Due Date', type: 'date'},
{name: 'Budget', type: 'number'},
{
name: 'Priority',
type: 'singleSelect',
options: {choices: [{name: 'High'}, {name: 'Medium'}, {name: 'Low'}]}
},
{name: 'Tasks', type: 'multipleRecordLinks'}
],
records: [
{
fields: {
Name: 'Website Redesign',
Status: 'In Progress',
Description: 'Complete overhaul of company website with modern design and improved UX',
'Start Date': '2024-01-15',
'Due Date': '2024-03-30',
Budget: 50000,
Priority: 'High'
}
},
{
fields: {
Name: 'Mobile App Development',
Status: 'Planning',
Description: 'Develop iOS and Android mobile applications for customer engagement',
'Start Date': '2024-02-01',
'Due Date': '2024-06-30',
Budget: 120000,
Priority: 'High'
}
},
{
fields: {
Name: 'Marketing Campaign Q1',
Status: 'In Progress',
Description: 'Launch social media and email marketing campaign for Q1',
'Start Date': '2024-01-01',
'Due Date': '2024-03-31',
Budget: 25000,
Priority: 'Medium'
}
},
{
fields: {
Name: 'Infrastructure Upgrade',
Status: 'Planning',
Description: 'Upgrade cloud infrastructure and migrate to Kubernetes',
'Start Date': '2024-03-01',
'Due Date': '2024-05-31',
Budget: 75000,
Priority: 'High'
}
},
{
fields: {
Name: 'Customer Support Portal',
Status: 'On Hold',
Description: 'Build self-service customer support portal with knowledge base',
'Start Date': '2024-01-20',
'Due Date': '2024-04-30',
Budget: 30000,
Priority: 'Low'
}
}
]
},
{
name: 'Tasks',
description: 'Individual tasks and action items',
fields: [
{name: 'Task Name', type: 'singleLineText'},
{name: 'Description', type: 'multilineText'},
{
name: 'Status',
type: 'singleSelect',
options: {
choices: [{name: 'To Do'}, {name: 'In Progress'}, {name: 'Review'}, {name: 'Done'}]
}
},
{name: 'Assignee', type: 'singleLineText'},
{name: 'Due Date', type: 'date'},
{
name: 'Priority',
type: 'singleSelect',
options: {choices: [{name: 'Critical'}, {name: 'High'}, {name: 'Medium'}, {name: 'Low'}]}
},
{name: 'Estimated Hours', type: 'number'},
{name: 'Completed', type: 'checkbox'},
{name: 'Project', type: 'multipleRecordLinks'}
],
records: [
{
fields: {
'Task Name': 'Design homepage mockup',
Description: 'Create high-fidelity mockups for the new homepage layout',
Status: 'In Progress',
Assignee: 'Sarah Johnson',
'Due Date': '2024-02-15',
Priority: 'High',
'Estimated Hours': 16,
Completed: false
}
},
{
fields: {
'Task Name': 'Set up development environment',
Description: 'Configure local dev environment with all necessary tools',
Status: 'Done',
Assignee: 'Mike Chen',
'Due Date': '2024-01-20',
Priority: 'High',
'Estimated Hours': 8,
Completed: true
}
},
{
fields: {
'Task Name': 'Conduct user research',
Description: 'Interview 20 users about their needs and pain points',
Status: 'In Progress',
Assignee: 'Emily Rodriguez',
'Due Date': '2024-02-28',
Priority: 'Medium',
'Estimated Hours': 40,
Completed: false
}
},
{
fields: {
'Task Name': 'Write API documentation',
Description: 'Document all API endpoints with examples and parameters',
Status: 'To Do',
Assignee: 'David Lee',
'Due Date': '2024-03-10',
Priority: 'Medium',
'Estimated Hours': 24,
Completed: false
}
},
{
fields: {
'Task Name': 'Implement authentication system',
Description: 'Build OAuth2 authentication with JWT tokens',
Status: 'In Progress',
Assignee: 'Mike Chen',
'Due Date': '2024-02-25',
Priority: 'Critical',
'Estimated Hours': 32,
Completed: false
}
},
{
fields: {
'Task Name': 'Create social media content calendar',
Description: 'Plan content for Twitter, LinkedIn, and Instagram for Q1',
Status: 'Review',
Assignee: 'Amanda White',
'Due Date': '2024-02-05',
Priority: 'High',
'Estimated Hours': 12,
Completed: false
}
},
{
fields: {
'Task Name': 'Deploy staging environment',
Description: 'Set up staging server for QA testing',
Status: 'Done',
Assignee: 'Robert Garcia',
'Due Date': '2024-01-25',
Priority: 'High',
'Estimated Hours': 6,
Completed: true
}
},
{
fields: {
'Task Name': 'Database schema design',
Description: 'Design normalized database schema for new features',
Status: 'Review',
Assignee: 'David Lee',
'Due Date': '2024-02-10',
Priority: 'Critical',
'Estimated Hours': 20,
Completed: false
}
}
]
},
{
name: 'Team Members',
description: 'Team directory with contact information',
fields: [
{name: 'Full Name', type: 'singleLineText'},
{name: 'Email', type: 'email'},
{name: 'Phone', type: 'phoneNumber'},
{
name: 'Role',
type: 'singleSelect',
options: {
choices: [
{name: 'Developer'},
{name: 'Designer'},
{name: 'Product Manager'},
{name: 'Marketing'},
{name: 'DevOps'}
]
}
},
{
name: 'Department',
type: 'singleSelect',
options: {
choices: [
{name: 'Engineering'},
{name: 'Design'},
{name: 'Product'},
{name: 'Marketing'},
{name: 'Operations'}
]
}
},
{name: 'Start Date', type: 'date'},
{name: 'Active', type: 'checkbox'},
{name: 'Profile Picture', type: 'url'}
],
records: [
{
fields: {
'Full Name': 'Sarah Johnson',
Email: 'sarah.johnson@example.com',
Phone: '+1-555-0101',
Role: 'Designer',
Department: 'Design',
'Start Date': '2022-03-15',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=1'
}
},
{
fields: {
'Full Name': 'Mike Chen',
Email: 'mike.chen@example.com',
Phone: '+1-555-0102',
Role: 'Developer',
Department: 'Engineering',
'Start Date': '2021-06-01',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=13'
}
},
{
fields: {
'Full Name': 'Emily Rodriguez',
Email: 'emily.rodriguez@example.com',
Phone: '+1-555-0103',
Role: 'Product Manager',
Department: 'Product',
'Start Date': '2020-09-10',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=5'
}
},
{
fields: {
'Full Name': 'David Lee',
Email: 'david.lee@example.com',
Phone: '+1-555-0104',
Role: 'Developer',
Department: 'Engineering',
'Start Date': '2023-01-20',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=12'
}
},
{
fields: {
'Full Name': 'Amanda White',
Email: 'amanda.white@example.com',
Phone: '+1-555-0105',
Role: 'Marketing',
Department: 'Marketing',
'Start Date': '2022-11-05',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=10'
}
},
{
fields: {
'Full Name': 'Robert Garcia',
Email: 'robert.garcia@example.com',
Phone: '+1-555-0106',
Role: 'DevOps',
Department: 'Operations',
'Start Date': '2021-02-28',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=15'
}
}
]
},
{
name: 'Meetings',
description: 'Schedule and track team meetings',
fields: [
{name: 'Meeting Title', type: 'singleLineText'},
{name: 'Date', type: 'date'},
{name: 'Duration (minutes)', type: 'number'},
{
name: 'Type',
type: 'singleSelect',
options: {
choices: [
{name: 'Stand-up'},
{name: 'Planning'},
{name: 'Review'},
{name: 'Retrospective'},
{name: 'One-on-One'}
]
}
},
{name: 'Attendees', type: 'multilineText'},
{name: 'Notes', type: 'multilineText'},
{name: 'Action Items', type: 'multilineText'},
{name: 'Recording URL', type: 'url'}
],
records: [
{
fields: {
'Meeting Title': 'Weekly Team Stand-up',
Date: '2024-02-05',
'Duration (minutes)': 30,
Type: 'Stand-up',
Attendees: 'Sarah, Mike, Emily, David, Amanda, Robert',
Notes: 'Discussed progress on current sprint. Team velocity is good. No major blockers.',
'Action Items': '- Mike to review David\'s PR\n- Sarah to finalize designs by EOD\n- Emily to schedule client demo'
}
},
{
fields: {
'Meeting Title': 'Sprint Planning - Sprint 5',
Date: '2024-02-01',
'Duration (minutes)': 120,
Type: 'Planning',
Attendees: 'All team members',
Notes: 'Planned 25 story points for the upcoming sprint. Focus on authentication and API development.',
'Action Items': '- Break down epic into smaller tasks\n- Update story estimates\n- Assign tasks to team members',
'Recording URL': 'https://zoom.us/rec/example123'
}
},
{
fields: {
'Meeting Title': 'Design Review - Homepage',
Date: '2024-02-03',
'Duration (minutes)': 60,
Type: 'Review',
Attendees: 'Sarah, Emily, Mike',
Notes: 'Reviewed new homepage designs. Overall positive feedback. Some minor adjustments needed.',
'Action Items': '- Sarah to update color palette\n- Increase font size for headings\n- Add more whitespace in hero section'
}
},
{
fields: {
'Meeting Title': '1:1 - Emily & Mike',
Date: '2024-02-02',
'Duration (minutes)': 30,
Type: 'One-on-One',
Attendees: 'Emily, Mike',
Notes: 'Discussed career growth and upcoming projects. Mike interested in learning more about system architecture.',
'Action Items': '- Emily to share architecture resources\n- Mike to shadow senior architect next month'
}
}
]
}
]
})
};
fetch('https://api.klavis.ai/sandbox/airtable/{sandbox_id}/initialize', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));{
"sandbox_id": "<string>",
"message": "<string>"
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>",
"input": "<unknown>",
"ctx": {}
}
]
}Airtable
Initialize airtable sandbox with data
Initialize the sandbox with airtable-specific data following the defined schema.
POST
/
sandbox
/
airtable
/
{sandbox_id}
/
initialize
Initialize airtable sandbox with data
curl --request POST \
--url https://api.klavis.ai/sandbox/airtable/{sandbox_id}/initialize \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data @- <<EOF
{
"tables": [
{
"name": "Projects",
"description": "Track all projects and their details",
"fields": [
{
"name": "Name",
"type": "singleLineText"
},
{
"name": "Status",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Planning"
},
{
"name": "In Progress"
},
{
"name": "On Hold"
},
{
"name": "Completed"
}
]
}
},
{
"name": "Description",
"type": "multilineText"
},
{
"name": "Start Date",
"type": "date"
},
{
"name": "Due Date",
"type": "date"
},
{
"name": "Budget",
"type": "number"
},
{
"name": "Priority",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "High"
},
{
"name": "Medium"
},
{
"name": "Low"
}
]
}
},
{
"name": "Tasks",
"type": "multipleRecordLinks"
}
],
"records": [
{
"fields": {
"Name": "Website Redesign",
"Status": "In Progress",
"Description": "Complete overhaul of company website with modern design and improved UX",
"Start Date": "2024-01-15",
"Due Date": "2024-03-30",
"Budget": 50000,
"Priority": "High"
}
},
{
"fields": {
"Name": "Mobile App Development",
"Status": "Planning",
"Description": "Develop iOS and Android mobile applications for customer engagement",
"Start Date": "2024-02-01",
"Due Date": "2024-06-30",
"Budget": 120000,
"Priority": "High"
}
},
{
"fields": {
"Name": "Marketing Campaign Q1",
"Status": "In Progress",
"Description": "Launch social media and email marketing campaign for Q1",
"Start Date": "2024-01-01",
"Due Date": "2024-03-31",
"Budget": 25000,
"Priority": "Medium"
}
},
{
"fields": {
"Name": "Infrastructure Upgrade",
"Status": "Planning",
"Description": "Upgrade cloud infrastructure and migrate to Kubernetes",
"Start Date": "2024-03-01",
"Due Date": "2024-05-31",
"Budget": 75000,
"Priority": "High"
}
},
{
"fields": {
"Name": "Customer Support Portal",
"Status": "On Hold",
"Description": "Build self-service customer support portal with knowledge base",
"Start Date": "2024-01-20",
"Due Date": "2024-04-30",
"Budget": 30000,
"Priority": "Low"
}
}
]
},
{
"name": "Tasks",
"description": "Individual tasks and action items",
"fields": [
{
"name": "Task Name",
"type": "singleLineText"
},
{
"name": "Description",
"type": "multilineText"
},
{
"name": "Status",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "To Do"
},
{
"name": "In Progress"
},
{
"name": "Review"
},
{
"name": "Done"
}
]
}
},
{
"name": "Assignee",
"type": "singleLineText"
},
{
"name": "Due Date",
"type": "date"
},
{
"name": "Priority",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Critical"
},
{
"name": "High"
},
{
"name": "Medium"
},
{
"name": "Low"
}
]
}
},
{
"name": "Estimated Hours",
"type": "number"
},
{
"name": "Completed",
"type": "checkbox"
},
{
"name": "Project",
"type": "multipleRecordLinks"
}
],
"records": [
{
"fields": {
"Task Name": "Design homepage mockup",
"Description": "Create high-fidelity mockups for the new homepage layout",
"Status": "In Progress",
"Assignee": "Sarah Johnson",
"Due Date": "2024-02-15",
"Priority": "High",
"Estimated Hours": 16,
"Completed": false
}
},
{
"fields": {
"Task Name": "Set up development environment",
"Description": "Configure local dev environment with all necessary tools",
"Status": "Done",
"Assignee": "Mike Chen",
"Due Date": "2024-01-20",
"Priority": "High",
"Estimated Hours": 8,
"Completed": true
}
},
{
"fields": {
"Task Name": "Conduct user research",
"Description": "Interview 20 users about their needs and pain points",
"Status": "In Progress",
"Assignee": "Emily Rodriguez",
"Due Date": "2024-02-28",
"Priority": "Medium",
"Estimated Hours": 40,
"Completed": false
}
},
{
"fields": {
"Task Name": "Write API documentation",
"Description": "Document all API endpoints with examples and parameters",
"Status": "To Do",
"Assignee": "David Lee",
"Due Date": "2024-03-10",
"Priority": "Medium",
"Estimated Hours": 24,
"Completed": false
}
},
{
"fields": {
"Task Name": "Implement authentication system",
"Description": "Build OAuth2 authentication with JWT tokens",
"Status": "In Progress",
"Assignee": "Mike Chen",
"Due Date": "2024-02-25",
"Priority": "Critical",
"Estimated Hours": 32,
"Completed": false
}
},
{
"fields": {
"Task Name": "Create social media content calendar",
"Description": "Plan content for Twitter, LinkedIn, and Instagram for Q1",
"Status": "Review",
"Assignee": "Amanda White",
"Due Date": "2024-02-05",
"Priority": "High",
"Estimated Hours": 12,
"Completed": false
}
},
{
"fields": {
"Task Name": "Deploy staging environment",
"Description": "Set up staging server for QA testing",
"Status": "Done",
"Assignee": "Robert Garcia",
"Due Date": "2024-01-25",
"Priority": "High",
"Estimated Hours": 6,
"Completed": true
}
},
{
"fields": {
"Task Name": "Database schema design",
"Description": "Design normalized database schema for new features",
"Status": "Review",
"Assignee": "David Lee",
"Due Date": "2024-02-10",
"Priority": "Critical",
"Estimated Hours": 20,
"Completed": false
}
}
]
},
{
"name": "Team Members",
"description": "Team directory with contact information",
"fields": [
{
"name": "Full Name",
"type": "singleLineText"
},
{
"name": "Email",
"type": "email"
},
{
"name": "Phone",
"type": "phoneNumber"
},
{
"name": "Role",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Developer"
},
{
"name": "Designer"
},
{
"name": "Product Manager"
},
{
"name": "Marketing"
},
{
"name": "DevOps"
}
]
}
},
{
"name": "Department",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Engineering"
},
{
"name": "Design"
},
{
"name": "Product"
},
{
"name": "Marketing"
},
{
"name": "Operations"
}
]
}
},
{
"name": "Start Date",
"type": "date"
},
{
"name": "Active",
"type": "checkbox"
},
{
"name": "Profile Picture",
"type": "url"
}
],
"records": [
{
"fields": {
"Full Name": "Sarah Johnson",
"Email": "sarah.johnson@example.com",
"Phone": "+1-555-0101",
"Role": "Designer",
"Department": "Design",
"Start Date": "2022-03-15",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=1"
}
},
{
"fields": {
"Full Name": "Mike Chen",
"Email": "mike.chen@example.com",
"Phone": "+1-555-0102",
"Role": "Developer",
"Department": "Engineering",
"Start Date": "2021-06-01",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=13"
}
},
{
"fields": {
"Full Name": "Emily Rodriguez",
"Email": "emily.rodriguez@example.com",
"Phone": "+1-555-0103",
"Role": "Product Manager",
"Department": "Product",
"Start Date": "2020-09-10",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=5"
}
},
{
"fields": {
"Full Name": "David Lee",
"Email": "david.lee@example.com",
"Phone": "+1-555-0104",
"Role": "Developer",
"Department": "Engineering",
"Start Date": "2023-01-20",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=12"
}
},
{
"fields": {
"Full Name": "Amanda White",
"Email": "amanda.white@example.com",
"Phone": "+1-555-0105",
"Role": "Marketing",
"Department": "Marketing",
"Start Date": "2022-11-05",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=10"
}
},
{
"fields": {
"Full Name": "Robert Garcia",
"Email": "robert.garcia@example.com",
"Phone": "+1-555-0106",
"Role": "DevOps",
"Department": "Operations",
"Start Date": "2021-02-28",
"Active": true,
"Profile Picture": "https://i.pravatar.cc/150?img=15"
}
}
]
},
{
"name": "Meetings",
"description": "Schedule and track team meetings",
"fields": [
{
"name": "Meeting Title",
"type": "singleLineText"
},
{
"name": "Date",
"type": "date"
},
{
"name": "Duration (minutes)",
"type": "number"
},
{
"name": "Type",
"type": "singleSelect",
"options": {
"choices": [
{
"name": "Stand-up"
},
{
"name": "Planning"
},
{
"name": "Review"
},
{
"name": "Retrospective"
},
{
"name": "One-on-One"
}
]
}
},
{
"name": "Attendees",
"type": "multilineText"
},
{
"name": "Notes",
"type": "multilineText"
},
{
"name": "Action Items",
"type": "multilineText"
},
{
"name": "Recording URL",
"type": "url"
}
],
"records": [
{
"fields": {
"Meeting Title": "Weekly Team Stand-up",
"Date": "2024-02-05",
"Duration (minutes)": 30,
"Type": "Stand-up",
"Attendees": "Sarah, Mike, Emily, David, Amanda, Robert",
"Notes": "Discussed progress on current sprint. Team velocity is good. No major blockers.",
"Action Items": "- Mike to review David's PR\n- Sarah to finalize designs by EOD\n- Emily to schedule client demo"
}
},
{
"fields": {
"Meeting Title": "Sprint Planning - Sprint 5",
"Date": "2024-02-01",
"Duration (minutes)": 120,
"Type": "Planning",
"Attendees": "All team members",
"Notes": "Planned 25 story points for the upcoming sprint. Focus on authentication and API development.",
"Action Items": "- Break down epic into smaller tasks\n- Update story estimates\n- Assign tasks to team members",
"Recording URL": "https://zoom.us/rec/example123"
}
},
{
"fields": {
"Meeting Title": "Design Review - Homepage",
"Date": "2024-02-03",
"Duration (minutes)": 60,
"Type": "Review",
"Attendees": "Sarah, Emily, Mike",
"Notes": "Reviewed new homepage designs. Overall positive feedback. Some minor adjustments needed.",
"Action Items": "- Sarah to update color palette\n- Increase font size for headings\n- Add more whitespace in hero section"
}
},
{
"fields": {
"Meeting Title": "1:1 - Emily & Mike",
"Date": "2024-02-02",
"Duration (minutes)": 30,
"Type": "One-on-One",
"Attendees": "Emily, Mike",
"Notes": "Discussed career growth and upcoming projects. Mike interested in learning more about system architecture.",
"Action Items": "- Emily to share architecture resources\n- Mike to shadow senior architect next month"
}
}
]
}
]
}
EOFimport requests
url = "https://api.klavis.ai/sandbox/airtable/{sandbox_id}/initialize"
payload = { "tables": [
{
"name": "Projects",
"description": "Track all projects and their details",
"fields": [
{
"name": "Name",
"type": "singleLineText"
},
{
"name": "Status",
"type": "singleSelect",
"options": { "choices": [{ "name": "Planning" }, { "name": "In Progress" }, { "name": "On Hold" }, { "name": "Completed" }] }
},
{
"name": "Description",
"type": "multilineText"
},
{
"name": "Start Date",
"type": "date"
},
{
"name": "Due Date",
"type": "date"
},
{
"name": "Budget",
"type": "number"
},
{
"name": "Priority",
"type": "singleSelect",
"options": { "choices": [{ "name": "High" }, { "name": "Medium" }, { "name": "Low" }] }
},
{
"name": "Tasks",
"type": "multipleRecordLinks"
}
],
"records": [{ "fields": {
"Name": "Website Redesign",
"Status": "In Progress",
"Description": "Complete overhaul of company website with modern design and improved UX",
"Start Date": "2024-01-15",
"Due Date": "2024-03-30",
"Budget": 50000,
"Priority": "High"
} }, { "fields": {
"Name": "Mobile App Development",
"Status": "Planning",
"Description": "Develop iOS and Android mobile applications for customer engagement",
"Start Date": "2024-02-01",
"Due Date": "2024-06-30",
"Budget": 120000,
"Priority": "High"
} }, { "fields": {
"Name": "Marketing Campaign Q1",
"Status": "In Progress",
"Description": "Launch social media and email marketing campaign for Q1",
"Start Date": "2024-01-01",
"Due Date": "2024-03-31",
"Budget": 25000,
"Priority": "Medium"
} }, { "fields": {
"Name": "Infrastructure Upgrade",
"Status": "Planning",
"Description": "Upgrade cloud infrastructure and migrate to Kubernetes",
"Start Date": "2024-03-01",
"Due Date": "2024-05-31",
"Budget": 75000,
"Priority": "High"
} }, { "fields": {
"Name": "Customer Support Portal",
"Status": "On Hold",
"Description": "Build self-service customer support portal with knowledge base",
"Start Date": "2024-01-20",
"Due Date": "2024-04-30",
"Budget": 30000,
"Priority": "Low"
} }]
},
{
"name": "Tasks",
"description": "Individual tasks and action items",
"fields": [
{
"name": "Task Name",
"type": "singleLineText"
},
{
"name": "Description",
"type": "multilineText"
},
{
"name": "Status",
"type": "singleSelect",
"options": { "choices": [{ "name": "To Do" }, { "name": "In Progress" }, { "name": "Review" }, { "name": "Done" }] }
},
{
"name": "Assignee",
"type": "singleLineText"
},
{
"name": "Due Date",
"type": "date"
},
{
"name": "Priority",
"type": "singleSelect",
"options": { "choices": [{ "name": "Critical" }, { "name": "High" }, { "name": "Medium" }, { "name": "Low" }] }
},
{
"name": "Estimated Hours",
"type": "number"
},
{
"name": "Completed",
"type": "checkbox"
},
{
"name": "Project",
"type": "multipleRecordLinks"
}
],
"records": [{ "fields": {
"Task Name": "Design homepage mockup",
"Description": "Create high-fidelity mockups for the new homepage layout",
"Status": "In Progress",
"Assignee": "Sarah Johnson",
"Due Date": "2024-02-15",
"Priority": "High",
"Estimated Hours": 16,
"Completed": False
} }, { "fields": {
"Task Name": "Set up development environment",
"Description": "Configure local dev environment with all necessary tools",
"Status": "Done",
"Assignee": "Mike Chen",
"Due Date": "2024-01-20",
"Priority": "High",
"Estimated Hours": 8,
"Completed": True
} }, { "fields": {
"Task Name": "Conduct user research",
"Description": "Interview 20 users about their needs and pain points",
"Status": "In Progress",
"Assignee": "Emily Rodriguez",
"Due Date": "2024-02-28",
"Priority": "Medium",
"Estimated Hours": 40,
"Completed": False
} }, { "fields": {
"Task Name": "Write API documentation",
"Description": "Document all API endpoints with examples and parameters",
"Status": "To Do",
"Assignee": "David Lee",
"Due Date": "2024-03-10",
"Priority": "Medium",
"Estimated Hours": 24,
"Completed": False
} }, { "fields": {
"Task Name": "Implement authentication system",
"Description": "Build OAuth2 authentication with JWT tokens",
"Status": "In Progress",
"Assignee": "Mike Chen",
"Due Date": "2024-02-25",
"Priority": "Critical",
"Estimated Hours": 32,
"Completed": False
} }, { "fields": {
"Task Name": "Create social media content calendar",
"Description": "Plan content for Twitter, LinkedIn, and Instagram for Q1",
"Status": "Review",
"Assignee": "Amanda White",
"Due Date": "2024-02-05",
"Priority": "High",
"Estimated Hours": 12,
"Completed": False
} }, { "fields": {
"Task Name": "Deploy staging environment",
"Description": "Set up staging server for QA testing",
"Status": "Done",
"Assignee": "Robert Garcia",
"Due Date": "2024-01-25",
"Priority": "High",
"Estimated Hours": 6,
"Completed": True
} }, { "fields": {
"Task Name": "Database schema design",
"Description": "Design normalized database schema for new features",
"Status": "Review",
"Assignee": "David Lee",
"Due Date": "2024-02-10",
"Priority": "Critical",
"Estimated Hours": 20,
"Completed": False
} }]
},
{
"name": "Team Members",
"description": "Team directory with contact information",
"fields": [
{
"name": "Full Name",
"type": "singleLineText"
},
{
"name": "Email",
"type": "email"
},
{
"name": "Phone",
"type": "phoneNumber"
},
{
"name": "Role",
"type": "singleSelect",
"options": { "choices": [{ "name": "Developer" }, { "name": "Designer" }, { "name": "Product Manager" }, { "name": "Marketing" }, { "name": "DevOps" }] }
},
{
"name": "Department",
"type": "singleSelect",
"options": { "choices": [{ "name": "Engineering" }, { "name": "Design" }, { "name": "Product" }, { "name": "Marketing" }, { "name": "Operations" }] }
},
{
"name": "Start Date",
"type": "date"
},
{
"name": "Active",
"type": "checkbox"
},
{
"name": "Profile Picture",
"type": "url"
}
],
"records": [{ "fields": {
"Full Name": "Sarah Johnson",
"Email": "sarah.johnson@example.com",
"Phone": "+1-555-0101",
"Role": "Designer",
"Department": "Design",
"Start Date": "2022-03-15",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=1"
} }, { "fields": {
"Full Name": "Mike Chen",
"Email": "mike.chen@example.com",
"Phone": "+1-555-0102",
"Role": "Developer",
"Department": "Engineering",
"Start Date": "2021-06-01",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=13"
} }, { "fields": {
"Full Name": "Emily Rodriguez",
"Email": "emily.rodriguez@example.com",
"Phone": "+1-555-0103",
"Role": "Product Manager",
"Department": "Product",
"Start Date": "2020-09-10",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=5"
} }, { "fields": {
"Full Name": "David Lee",
"Email": "david.lee@example.com",
"Phone": "+1-555-0104",
"Role": "Developer",
"Department": "Engineering",
"Start Date": "2023-01-20",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=12"
} }, { "fields": {
"Full Name": "Amanda White",
"Email": "amanda.white@example.com",
"Phone": "+1-555-0105",
"Role": "Marketing",
"Department": "Marketing",
"Start Date": "2022-11-05",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=10"
} }, { "fields": {
"Full Name": "Robert Garcia",
"Email": "robert.garcia@example.com",
"Phone": "+1-555-0106",
"Role": "DevOps",
"Department": "Operations",
"Start Date": "2021-02-28",
"Active": True,
"Profile Picture": "https://i.pravatar.cc/150?img=15"
} }]
},
{
"name": "Meetings",
"description": "Schedule and track team meetings",
"fields": [
{
"name": "Meeting Title",
"type": "singleLineText"
},
{
"name": "Date",
"type": "date"
},
{
"name": "Duration (minutes)",
"type": "number"
},
{
"name": "Type",
"type": "singleSelect",
"options": { "choices": [{ "name": "Stand-up" }, { "name": "Planning" }, { "name": "Review" }, { "name": "Retrospective" }, { "name": "One-on-One" }] }
},
{
"name": "Attendees",
"type": "multilineText"
},
{
"name": "Notes",
"type": "multilineText"
},
{
"name": "Action Items",
"type": "multilineText"
},
{
"name": "Recording URL",
"type": "url"
}
],
"records": [{ "fields": {
"Meeting Title": "Weekly Team Stand-up",
"Date": "2024-02-05",
"Duration (minutes)": 30,
"Type": "Stand-up",
"Attendees": "Sarah, Mike, Emily, David, Amanda, Robert",
"Notes": "Discussed progress on current sprint. Team velocity is good. No major blockers.",
"Action Items": "- Mike to review David's PR
- Sarah to finalize designs by EOD
- Emily to schedule client demo"
} }, { "fields": {
"Meeting Title": "Sprint Planning - Sprint 5",
"Date": "2024-02-01",
"Duration (minutes)": 120,
"Type": "Planning",
"Attendees": "All team members",
"Notes": "Planned 25 story points for the upcoming sprint. Focus on authentication and API development.",
"Action Items": "- Break down epic into smaller tasks
- Update story estimates
- Assign tasks to team members",
"Recording URL": "https://zoom.us/rec/example123"
} }, { "fields": {
"Meeting Title": "Design Review - Homepage",
"Date": "2024-02-03",
"Duration (minutes)": 60,
"Type": "Review",
"Attendees": "Sarah, Emily, Mike",
"Notes": "Reviewed new homepage designs. Overall positive feedback. Some minor adjustments needed.",
"Action Items": "- Sarah to update color palette
- Increase font size for headings
- Add more whitespace in hero section"
} }, { "fields": {
"Meeting Title": "1:1 - Emily & Mike",
"Date": "2024-02-02",
"Duration (minutes)": 30,
"Type": "One-on-One",
"Attendees": "Emily, Mike",
"Notes": "Discussed career growth and upcoming projects. Mike interested in learning more about system architecture.",
"Action Items": "- Emily to share architecture resources
- Mike to shadow senior architect next month"
} }]
}
] }
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
tables: [
{
name: 'Projects',
description: 'Track all projects and their details',
fields: [
{name: 'Name', type: 'singleLineText'},
{
name: 'Status',
type: 'singleSelect',
options: {
choices: [
{name: 'Planning'},
{name: 'In Progress'},
{name: 'On Hold'},
{name: 'Completed'}
]
}
},
{name: 'Description', type: 'multilineText'},
{name: 'Start Date', type: 'date'},
{name: 'Due Date', type: 'date'},
{name: 'Budget', type: 'number'},
{
name: 'Priority',
type: 'singleSelect',
options: {choices: [{name: 'High'}, {name: 'Medium'}, {name: 'Low'}]}
},
{name: 'Tasks', type: 'multipleRecordLinks'}
],
records: [
{
fields: {
Name: 'Website Redesign',
Status: 'In Progress',
Description: 'Complete overhaul of company website with modern design and improved UX',
'Start Date': '2024-01-15',
'Due Date': '2024-03-30',
Budget: 50000,
Priority: 'High'
}
},
{
fields: {
Name: 'Mobile App Development',
Status: 'Planning',
Description: 'Develop iOS and Android mobile applications for customer engagement',
'Start Date': '2024-02-01',
'Due Date': '2024-06-30',
Budget: 120000,
Priority: 'High'
}
},
{
fields: {
Name: 'Marketing Campaign Q1',
Status: 'In Progress',
Description: 'Launch social media and email marketing campaign for Q1',
'Start Date': '2024-01-01',
'Due Date': '2024-03-31',
Budget: 25000,
Priority: 'Medium'
}
},
{
fields: {
Name: 'Infrastructure Upgrade',
Status: 'Planning',
Description: 'Upgrade cloud infrastructure and migrate to Kubernetes',
'Start Date': '2024-03-01',
'Due Date': '2024-05-31',
Budget: 75000,
Priority: 'High'
}
},
{
fields: {
Name: 'Customer Support Portal',
Status: 'On Hold',
Description: 'Build self-service customer support portal with knowledge base',
'Start Date': '2024-01-20',
'Due Date': '2024-04-30',
Budget: 30000,
Priority: 'Low'
}
}
]
},
{
name: 'Tasks',
description: 'Individual tasks and action items',
fields: [
{name: 'Task Name', type: 'singleLineText'},
{name: 'Description', type: 'multilineText'},
{
name: 'Status',
type: 'singleSelect',
options: {
choices: [{name: 'To Do'}, {name: 'In Progress'}, {name: 'Review'}, {name: 'Done'}]
}
},
{name: 'Assignee', type: 'singleLineText'},
{name: 'Due Date', type: 'date'},
{
name: 'Priority',
type: 'singleSelect',
options: {choices: [{name: 'Critical'}, {name: 'High'}, {name: 'Medium'}, {name: 'Low'}]}
},
{name: 'Estimated Hours', type: 'number'},
{name: 'Completed', type: 'checkbox'},
{name: 'Project', type: 'multipleRecordLinks'}
],
records: [
{
fields: {
'Task Name': 'Design homepage mockup',
Description: 'Create high-fidelity mockups for the new homepage layout',
Status: 'In Progress',
Assignee: 'Sarah Johnson',
'Due Date': '2024-02-15',
Priority: 'High',
'Estimated Hours': 16,
Completed: false
}
},
{
fields: {
'Task Name': 'Set up development environment',
Description: 'Configure local dev environment with all necessary tools',
Status: 'Done',
Assignee: 'Mike Chen',
'Due Date': '2024-01-20',
Priority: 'High',
'Estimated Hours': 8,
Completed: true
}
},
{
fields: {
'Task Name': 'Conduct user research',
Description: 'Interview 20 users about their needs and pain points',
Status: 'In Progress',
Assignee: 'Emily Rodriguez',
'Due Date': '2024-02-28',
Priority: 'Medium',
'Estimated Hours': 40,
Completed: false
}
},
{
fields: {
'Task Name': 'Write API documentation',
Description: 'Document all API endpoints with examples and parameters',
Status: 'To Do',
Assignee: 'David Lee',
'Due Date': '2024-03-10',
Priority: 'Medium',
'Estimated Hours': 24,
Completed: false
}
},
{
fields: {
'Task Name': 'Implement authentication system',
Description: 'Build OAuth2 authentication with JWT tokens',
Status: 'In Progress',
Assignee: 'Mike Chen',
'Due Date': '2024-02-25',
Priority: 'Critical',
'Estimated Hours': 32,
Completed: false
}
},
{
fields: {
'Task Name': 'Create social media content calendar',
Description: 'Plan content for Twitter, LinkedIn, and Instagram for Q1',
Status: 'Review',
Assignee: 'Amanda White',
'Due Date': '2024-02-05',
Priority: 'High',
'Estimated Hours': 12,
Completed: false
}
},
{
fields: {
'Task Name': 'Deploy staging environment',
Description: 'Set up staging server for QA testing',
Status: 'Done',
Assignee: 'Robert Garcia',
'Due Date': '2024-01-25',
Priority: 'High',
'Estimated Hours': 6,
Completed: true
}
},
{
fields: {
'Task Name': 'Database schema design',
Description: 'Design normalized database schema for new features',
Status: 'Review',
Assignee: 'David Lee',
'Due Date': '2024-02-10',
Priority: 'Critical',
'Estimated Hours': 20,
Completed: false
}
}
]
},
{
name: 'Team Members',
description: 'Team directory with contact information',
fields: [
{name: 'Full Name', type: 'singleLineText'},
{name: 'Email', type: 'email'},
{name: 'Phone', type: 'phoneNumber'},
{
name: 'Role',
type: 'singleSelect',
options: {
choices: [
{name: 'Developer'},
{name: 'Designer'},
{name: 'Product Manager'},
{name: 'Marketing'},
{name: 'DevOps'}
]
}
},
{
name: 'Department',
type: 'singleSelect',
options: {
choices: [
{name: 'Engineering'},
{name: 'Design'},
{name: 'Product'},
{name: 'Marketing'},
{name: 'Operations'}
]
}
},
{name: 'Start Date', type: 'date'},
{name: 'Active', type: 'checkbox'},
{name: 'Profile Picture', type: 'url'}
],
records: [
{
fields: {
'Full Name': 'Sarah Johnson',
Email: 'sarah.johnson@example.com',
Phone: '+1-555-0101',
Role: 'Designer',
Department: 'Design',
'Start Date': '2022-03-15',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=1'
}
},
{
fields: {
'Full Name': 'Mike Chen',
Email: 'mike.chen@example.com',
Phone: '+1-555-0102',
Role: 'Developer',
Department: 'Engineering',
'Start Date': '2021-06-01',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=13'
}
},
{
fields: {
'Full Name': 'Emily Rodriguez',
Email: 'emily.rodriguez@example.com',
Phone: '+1-555-0103',
Role: 'Product Manager',
Department: 'Product',
'Start Date': '2020-09-10',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=5'
}
},
{
fields: {
'Full Name': 'David Lee',
Email: 'david.lee@example.com',
Phone: '+1-555-0104',
Role: 'Developer',
Department: 'Engineering',
'Start Date': '2023-01-20',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=12'
}
},
{
fields: {
'Full Name': 'Amanda White',
Email: 'amanda.white@example.com',
Phone: '+1-555-0105',
Role: 'Marketing',
Department: 'Marketing',
'Start Date': '2022-11-05',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=10'
}
},
{
fields: {
'Full Name': 'Robert Garcia',
Email: 'robert.garcia@example.com',
Phone: '+1-555-0106',
Role: 'DevOps',
Department: 'Operations',
'Start Date': '2021-02-28',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=15'
}
}
]
},
{
name: 'Meetings',
description: 'Schedule and track team meetings',
fields: [
{name: 'Meeting Title', type: 'singleLineText'},
{name: 'Date', type: 'date'},
{name: 'Duration (minutes)', type: 'number'},
{
name: 'Type',
type: 'singleSelect',
options: {
choices: [
{name: 'Stand-up'},
{name: 'Planning'},
{name: 'Review'},
{name: 'Retrospective'},
{name: 'One-on-One'}
]
}
},
{name: 'Attendees', type: 'multilineText'},
{name: 'Notes', type: 'multilineText'},
{name: 'Action Items', type: 'multilineText'},
{name: 'Recording URL', type: 'url'}
],
records: [
{
fields: {
'Meeting Title': 'Weekly Team Stand-up',
Date: '2024-02-05',
'Duration (minutes)': 30,
Type: 'Stand-up',
Attendees: 'Sarah, Mike, Emily, David, Amanda, Robert',
Notes: 'Discussed progress on current sprint. Team velocity is good. No major blockers.',
'Action Items': '- Mike to review David\'s PR\n- Sarah to finalize designs by EOD\n- Emily to schedule client demo'
}
},
{
fields: {
'Meeting Title': 'Sprint Planning - Sprint 5',
Date: '2024-02-01',
'Duration (minutes)': 120,
Type: 'Planning',
Attendees: 'All team members',
Notes: 'Planned 25 story points for the upcoming sprint. Focus on authentication and API development.',
'Action Items': '- Break down epic into smaller tasks\n- Update story estimates\n- Assign tasks to team members',
'Recording URL': 'https://zoom.us/rec/example123'
}
},
{
fields: {
'Meeting Title': 'Design Review - Homepage',
Date: '2024-02-03',
'Duration (minutes)': 60,
Type: 'Review',
Attendees: 'Sarah, Emily, Mike',
Notes: 'Reviewed new homepage designs. Overall positive feedback. Some minor adjustments needed.',
'Action Items': '- Sarah to update color palette\n- Increase font size for headings\n- Add more whitespace in hero section'
}
},
{
fields: {
'Meeting Title': '1:1 - Emily & Mike',
Date: '2024-02-02',
'Duration (minutes)': 30,
Type: 'One-on-One',
Attendees: 'Emily, Mike',
Notes: 'Discussed career growth and upcoming projects. Mike interested in learning more about system architecture.',
'Action Items': '- Emily to share architecture resources\n- Mike to shadow senior architect next month'
}
}
]
}
]
})
};
fetch('https://api.klavis.ai/sandbox/airtable/{sandbox_id}/initialize', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
tables: [
{
name: 'Projects',
description: 'Track all projects and their details',
fields: [
{name: 'Name', type: 'singleLineText'},
{
name: 'Status',
type: 'singleSelect',
options: {
choices: [
{name: 'Planning'},
{name: 'In Progress'},
{name: 'On Hold'},
{name: 'Completed'}
]
}
},
{name: 'Description', type: 'multilineText'},
{name: 'Start Date', type: 'date'},
{name: 'Due Date', type: 'date'},
{name: 'Budget', type: 'number'},
{
name: 'Priority',
type: 'singleSelect',
options: {choices: [{name: 'High'}, {name: 'Medium'}, {name: 'Low'}]}
},
{name: 'Tasks', type: 'multipleRecordLinks'}
],
records: [
{
fields: {
Name: 'Website Redesign',
Status: 'In Progress',
Description: 'Complete overhaul of company website with modern design and improved UX',
'Start Date': '2024-01-15',
'Due Date': '2024-03-30',
Budget: 50000,
Priority: 'High'
}
},
{
fields: {
Name: 'Mobile App Development',
Status: 'Planning',
Description: 'Develop iOS and Android mobile applications for customer engagement',
'Start Date': '2024-02-01',
'Due Date': '2024-06-30',
Budget: 120000,
Priority: 'High'
}
},
{
fields: {
Name: 'Marketing Campaign Q1',
Status: 'In Progress',
Description: 'Launch social media and email marketing campaign for Q1',
'Start Date': '2024-01-01',
'Due Date': '2024-03-31',
Budget: 25000,
Priority: 'Medium'
}
},
{
fields: {
Name: 'Infrastructure Upgrade',
Status: 'Planning',
Description: 'Upgrade cloud infrastructure and migrate to Kubernetes',
'Start Date': '2024-03-01',
'Due Date': '2024-05-31',
Budget: 75000,
Priority: 'High'
}
},
{
fields: {
Name: 'Customer Support Portal',
Status: 'On Hold',
Description: 'Build self-service customer support portal with knowledge base',
'Start Date': '2024-01-20',
'Due Date': '2024-04-30',
Budget: 30000,
Priority: 'Low'
}
}
]
},
{
name: 'Tasks',
description: 'Individual tasks and action items',
fields: [
{name: 'Task Name', type: 'singleLineText'},
{name: 'Description', type: 'multilineText'},
{
name: 'Status',
type: 'singleSelect',
options: {
choices: [{name: 'To Do'}, {name: 'In Progress'}, {name: 'Review'}, {name: 'Done'}]
}
},
{name: 'Assignee', type: 'singleLineText'},
{name: 'Due Date', type: 'date'},
{
name: 'Priority',
type: 'singleSelect',
options: {choices: [{name: 'Critical'}, {name: 'High'}, {name: 'Medium'}, {name: 'Low'}]}
},
{name: 'Estimated Hours', type: 'number'},
{name: 'Completed', type: 'checkbox'},
{name: 'Project', type: 'multipleRecordLinks'}
],
records: [
{
fields: {
'Task Name': 'Design homepage mockup',
Description: 'Create high-fidelity mockups for the new homepage layout',
Status: 'In Progress',
Assignee: 'Sarah Johnson',
'Due Date': '2024-02-15',
Priority: 'High',
'Estimated Hours': 16,
Completed: false
}
},
{
fields: {
'Task Name': 'Set up development environment',
Description: 'Configure local dev environment with all necessary tools',
Status: 'Done',
Assignee: 'Mike Chen',
'Due Date': '2024-01-20',
Priority: 'High',
'Estimated Hours': 8,
Completed: true
}
},
{
fields: {
'Task Name': 'Conduct user research',
Description: 'Interview 20 users about their needs and pain points',
Status: 'In Progress',
Assignee: 'Emily Rodriguez',
'Due Date': '2024-02-28',
Priority: 'Medium',
'Estimated Hours': 40,
Completed: false
}
},
{
fields: {
'Task Name': 'Write API documentation',
Description: 'Document all API endpoints with examples and parameters',
Status: 'To Do',
Assignee: 'David Lee',
'Due Date': '2024-03-10',
Priority: 'Medium',
'Estimated Hours': 24,
Completed: false
}
},
{
fields: {
'Task Name': 'Implement authentication system',
Description: 'Build OAuth2 authentication with JWT tokens',
Status: 'In Progress',
Assignee: 'Mike Chen',
'Due Date': '2024-02-25',
Priority: 'Critical',
'Estimated Hours': 32,
Completed: false
}
},
{
fields: {
'Task Name': 'Create social media content calendar',
Description: 'Plan content for Twitter, LinkedIn, and Instagram for Q1',
Status: 'Review',
Assignee: 'Amanda White',
'Due Date': '2024-02-05',
Priority: 'High',
'Estimated Hours': 12,
Completed: false
}
},
{
fields: {
'Task Name': 'Deploy staging environment',
Description: 'Set up staging server for QA testing',
Status: 'Done',
Assignee: 'Robert Garcia',
'Due Date': '2024-01-25',
Priority: 'High',
'Estimated Hours': 6,
Completed: true
}
},
{
fields: {
'Task Name': 'Database schema design',
Description: 'Design normalized database schema for new features',
Status: 'Review',
Assignee: 'David Lee',
'Due Date': '2024-02-10',
Priority: 'Critical',
'Estimated Hours': 20,
Completed: false
}
}
]
},
{
name: 'Team Members',
description: 'Team directory with contact information',
fields: [
{name: 'Full Name', type: 'singleLineText'},
{name: 'Email', type: 'email'},
{name: 'Phone', type: 'phoneNumber'},
{
name: 'Role',
type: 'singleSelect',
options: {
choices: [
{name: 'Developer'},
{name: 'Designer'},
{name: 'Product Manager'},
{name: 'Marketing'},
{name: 'DevOps'}
]
}
},
{
name: 'Department',
type: 'singleSelect',
options: {
choices: [
{name: 'Engineering'},
{name: 'Design'},
{name: 'Product'},
{name: 'Marketing'},
{name: 'Operations'}
]
}
},
{name: 'Start Date', type: 'date'},
{name: 'Active', type: 'checkbox'},
{name: 'Profile Picture', type: 'url'}
],
records: [
{
fields: {
'Full Name': 'Sarah Johnson',
Email: 'sarah.johnson@example.com',
Phone: '+1-555-0101',
Role: 'Designer',
Department: 'Design',
'Start Date': '2022-03-15',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=1'
}
},
{
fields: {
'Full Name': 'Mike Chen',
Email: 'mike.chen@example.com',
Phone: '+1-555-0102',
Role: 'Developer',
Department: 'Engineering',
'Start Date': '2021-06-01',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=13'
}
},
{
fields: {
'Full Name': 'Emily Rodriguez',
Email: 'emily.rodriguez@example.com',
Phone: '+1-555-0103',
Role: 'Product Manager',
Department: 'Product',
'Start Date': '2020-09-10',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=5'
}
},
{
fields: {
'Full Name': 'David Lee',
Email: 'david.lee@example.com',
Phone: '+1-555-0104',
Role: 'Developer',
Department: 'Engineering',
'Start Date': '2023-01-20',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=12'
}
},
{
fields: {
'Full Name': 'Amanda White',
Email: 'amanda.white@example.com',
Phone: '+1-555-0105',
Role: 'Marketing',
Department: 'Marketing',
'Start Date': '2022-11-05',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=10'
}
},
{
fields: {
'Full Name': 'Robert Garcia',
Email: 'robert.garcia@example.com',
Phone: '+1-555-0106',
Role: 'DevOps',
Department: 'Operations',
'Start Date': '2021-02-28',
Active: true,
'Profile Picture': 'https://i.pravatar.cc/150?img=15'
}
}
]
},
{
name: 'Meetings',
description: 'Schedule and track team meetings',
fields: [
{name: 'Meeting Title', type: 'singleLineText'},
{name: 'Date', type: 'date'},
{name: 'Duration (minutes)', type: 'number'},
{
name: 'Type',
type: 'singleSelect',
options: {
choices: [
{name: 'Stand-up'},
{name: 'Planning'},
{name: 'Review'},
{name: 'Retrospective'},
{name: 'One-on-One'}
]
}
},
{name: 'Attendees', type: 'multilineText'},
{name: 'Notes', type: 'multilineText'},
{name: 'Action Items', type: 'multilineText'},
{name: 'Recording URL', type: 'url'}
],
records: [
{
fields: {
'Meeting Title': 'Weekly Team Stand-up',
Date: '2024-02-05',
'Duration (minutes)': 30,
Type: 'Stand-up',
Attendees: 'Sarah, Mike, Emily, David, Amanda, Robert',
Notes: 'Discussed progress on current sprint. Team velocity is good. No major blockers.',
'Action Items': '- Mike to review David\'s PR\n- Sarah to finalize designs by EOD\n- Emily to schedule client demo'
}
},
{
fields: {
'Meeting Title': 'Sprint Planning - Sprint 5',
Date: '2024-02-01',
'Duration (minutes)': 120,
Type: 'Planning',
Attendees: 'All team members',
Notes: 'Planned 25 story points for the upcoming sprint. Focus on authentication and API development.',
'Action Items': '- Break down epic into smaller tasks\n- Update story estimates\n- Assign tasks to team members',
'Recording URL': 'https://zoom.us/rec/example123'
}
},
{
fields: {
'Meeting Title': 'Design Review - Homepage',
Date: '2024-02-03',
'Duration (minutes)': 60,
Type: 'Review',
Attendees: 'Sarah, Emily, Mike',
Notes: 'Reviewed new homepage designs. Overall positive feedback. Some minor adjustments needed.',
'Action Items': '- Sarah to update color palette\n- Increase font size for headings\n- Add more whitespace in hero section'
}
},
{
fields: {
'Meeting Title': '1:1 - Emily & Mike',
Date: '2024-02-02',
'Duration (minutes)': 30,
Type: 'One-on-One',
Attendees: 'Emily, Mike',
Notes: 'Discussed career growth and upcoming projects. Mike interested in learning more about system architecture.',
'Action Items': '- Emily to share architecture resources\n- Mike to shadow senior architect next month'
}
}
]
}
]
})
};
fetch('https://api.klavis.ai/sandbox/airtable/{sandbox_id}/initialize', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));{
"sandbox_id": "<string>",
"message": "<string>"
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>",
"input": "<unknown>",
"ctx": {}
}
]
}Authorizations
Your Klavis AI API key.
Path Parameters
The unique sandbox identifier
Query Parameters
If true, use default test data for initialization
Body
application/json
Complete Airtable sandbox data structure.
Hierarchy:
- Bases contain Tables
- Tables contain Fields (schema) and Records (data)
- Records contain field values
Note: For sandbox purposes, we typically work with a single base and multiple tables within it.
List of tables (simplified, assumes single base)
Show child attributes
Show child attributes
⌘I