Hi @Doggy-Wild_and_Free ,
Please check the document → Manage database tables & data | yellow.ai
to
- Create a table
- Fetch table data
- Edit table and add associate relations if required
- Insert/update data from bot flows
- Delete table or table fieldst
The result of the DB search will be stored in an Object.
{
"records": [
{
"bot_table": "x1661764941397_4bbecb68-ff6c-4288-8bb2-05cbd1",
"category": "Debit Cards",
"created_at": "2022-09-22T09:57:04.344Z",
"name": "Sam Griffith",
"updated_at": "2022-09-22T09:57:04.344Z"
},
{
"bot_table": "x1661764941397_4bbecb68-ff6c-4288-8bb2-05d1",
"category": "Debit Cards",
"created_at": "2022-09-22T09:57:04.344Z",
"name": "Rob Williams",
"updated_at": "2022-09-22T09:57:04.344Z"
}
]
}
let {var_name} = data.variables -> access response in variables
Post this you can filter the data required for you and resolve in a varible for a function and resolve it to be displayed as text in a next node.