https://discord.gg/botpress logo
Airtable Integration - Create Record & Update Reco...
# 🤝help
s
I'm building a sales bot for a travel agency using the Autonomous Node with Airtable integration. The bot needs to: 1. Search if a prospect exists (List Records) ✅ Working 2. Create a new prospect if they don't exist (Create Record) ❌ Failing 3. Update the prospect's record with collected travel details (Update Record) ❌ Failing ### The Issue: - List Records works perfectly - Create Record fails with error:
Tool airtable.createRecord failed - [Error: failed to create record]
- Update Record fails with error: ### What I've Already Tried: 1. Airtable Access Token Configuration: - Personal Access Token properly configured with scopes: -
data.records:read
-
data.records:write
-
schema.bases:read
- Token has access to the specific base - Base ID and Table name ("Prospects") are correct 2. Create Record Configuration: I've tried multiple approaches for the Fields parameter: {"Nom Complet": "Jean Dupont"} And also with additional fields matching my Airtable schema: { "Nom Complet": "Test User", "Statut du Lead": "Nouveau", "Source": "Bot", "Canal": "Chat" } ``` 3. Update Record Configuration: - Tried leaving Record ID and Fields empty, relying on AI to auto-populate ### Context: My Airtable Table Structure ("Prospects"): - Nom Complet (Single line text) - Email (Single line text) - Téléphone (Single line text) - Date d'inscription (Single line text) - Campagne Origine (Single select) - Closer Assigné (Single select) - Statut du Lead (Single select) - Budget Annoncé (Number - Currency $) - Dates de Voyage (Single line text) - Projet Voyage (Long text) - Source (Single line text) ### Questions: 1. Is there a specific format required for the
fields
parameter in Create Record? 2. Should I be manually handling the record ID between List Records and Update Record, or should the Autonomous Node handle this automatically? Any help would be greatly appreciated! 🙏 https://cdn.discordapp.com/attachments/1469672619136651492/1469672619467870313/image.png?ex=698882c9&is=69873149&hm=bb31da817c7df31c0b3265e12360a91005311a37cbc9f7370f44e26a14a89284&
l
Can you share your workspace ID Please @swift-terabyte-10871
3 Views