What the model is told
Find a customer's record in NocoDB by the exact email address they give you. Returns at most one record with its id, Name and Status. Use the id with the update tool. If nothing is returned, tell the customer you could not find a record.
Request
GEThttps://app.nocodb.com/api/v3/data/YOUR_NOCODB_BASE_ID/YOUR_NOCODB_TABLE_ID/records?where=(Email,eq,{{email}})&fields=Name,Status&limit=1
Headers
xc-tokenYOUR_NOCODB_API_TOKEN
Parameters
email stringThe exact email address to look up.
Engage payload
{
"source": "VOICE_AI",
"tool": {
"id": "9b1a85a6-d88d-4a65-aed3-653a53b3ca8d",
"type": "HTTP_REQUEST",
"label": "Find NocoDB Record by Email",
"name": "find_nocodb_record_by_email",
"customName": false,
"description": "Find a customer's record in NocoDB by the exact email address they give you. Returns at most one record with its id, Name and Status. Use the id with the update tool. If nothing is returned, tell the customer you could not find a record.",
"parameters": [
{
"name": "email",
"type": "string",
"description": "The exact email address to look up."
}
],
"config": {
"endpoint": {
"method": "GET",
"url": "https://app.nocodb.com/api/v3/data/YOUR_NOCODB_BASE_ID/YOUR_NOCODB_TABLE_ID/records?where=(Email,eq,{{email}})&fields=Name,Status&limit=1"
},
"headers": [
{
"name": "xc-token",
"value": "YOUR_NOCODB_API_TOKEN"
}
],
"body": null,
"timeout": null
}
}
}IDs are regenerated on every copy.