Chatbot element → NocoDB

Modified on Thu, 3 Jul at 2:46 PM

This element of chatbot scenarios allows you to integrate with the service https://nocodb.kompaas.tech/, hosted on our servers.

*You can find instructions for the service itself here.

The element has 2 steps to complete:

Select the database and table, which are automatically pulled from the service.
Select the operation and the fields necessary for it.

Available operations:

Operation 'Receive' — retrieving a specific record by id from the service table.
- Fields:
  - Enter ID — id of the record from the table.
  - Save to a variable — a variable in the scenario where we will store the response returned to us from the service.
Operation 'Get Several' — retrieving records from the service table.
- Fields:
  - Save to a variable — a variable in the scenario where we will store the response returned to us from the service.
  - Filter — a filter that will be used for the selection.
    Enables you to define specific conditions for filtering records in your API response. Multiple conditions can be combined using logical operators such as 'and' and 'or'. Each condition consists of three parts: a field name, a comparison operator, and a value.
    Example: where=(field1,eq,value1)~and(field2,eq,value2) will filter records where 'field1' is equal to 'value1' AND 'field2' is equal to 'value2'.
    You can also use other comparison operators like 'ne' (not equal), 'gt' (greater than), 'lt' (less than), and more, to create complex filtering rules.
    In this case, the filter will work as in the example above, you need to write:
    where=(field1,eq,value1)~and(field2,eq,value2)
  - Sort — sorting the selection values.
    Example: sort=field1,-field2 will sort the records first by 'field1' in ascending order and then by 'field2' in descending order.
    In this case, the sorting will be formed automatically according to the selected fields. We can exclude some fields or add them.
Operation 'Create' — creating a new record in the service table.
- Fields:
  - Save to a variable — a variable in the scenario where we will store the response returned to us from the service.
  - Name \ Value — the field name comes to us from the service, we enter the value ourselves.
Operation 'Change' — updating an existing record in the service table.
- Fields:
  - Enter ID — id of the record from the table.
  - Name \ Value — the field name comes to us from the service, we enter the value ourselves.
Operation 'Delete' — deleting an existing record by id from the service table.
- Fields:
  - Enter ID — id of the record from the table.
    
    Also see.:
    Chatbots
    Chatbots → Marketplace
    Chatbots → Scenarios templates