Aller au contenu
Agentivity
Star on GitHub Commencer gratuitement

What a Data Table is for

Ce contenu n’est pas encore disponible dans votre langue.

A Data Table is a table of data that lives in your Agentivity workspace. Your agents and your workflows can read it and fill it. You can look at it and change it in the Studio.

An agent or a workflow forgets everything when its execution ends. A Data Table is where the work is kept.

  • Keep what was done. The reminders that were sent, the invoices that were read, the requests that were handled.
  • Give facts to work from. A list of customers, of products, of open invoices.
  • Pass work between solutions. One solution fills a table, another one reads it.
  • Show data in an application. An application built with the SDK can list the rows of a table.

In our example, a table reminders keeps one row for each payment reminder: the customer, the invoice, the date, and whether a person approved it.

PartWhat it is
ColumnsThe fields of the table. Each column has a name and a type, for example text or number. The Studio also calls them fields.
RowsThe entries. One row is one reminder, one invoice, one trip.
id, CreatedAt, UpdatedAtThree columns that every table has. Agentivity fills them itself.

An open Data Table named trips: its 57 rows and 16 fields, the button Add column, and one column per field with buttons to sort

WhoHow
You, in the StudioOpen the table, sort and search its rows, change its columns. See Look at a Data Table and change its columns.
A workflowA step reads, adds, changes or deletes rows. See Read and write a Data Table from a workflow.
An agentA tool lets the agent read and fill the table, within the limits you set. See Let an agent read and fill a Data Table.
An applicationIt reads and writes rows. It cannot change the columns. See List solutions and start an execution from your app.

In the menu on the left, open Resources > Data Tables.

The screen Data Tables: a search field, the button New Data Table, and one line per table

  • Search Data Tables finds a table by its name.
  • Double-click a line to open the table.
  • The panel on the left holds folders, as for agents and workflows.
  • A Template can carry tables. When you import a showcase, its tables are added to your workspace.
  • Agentivity has no login. Anyone who can reach your server can read and change every table. Do not keep there what must stay private from the people who can reach the server.
  • Keeping earlier versions of a table is not in the Community edition.

A Data Table holds rows, and an agent looks up or changes a value. A Knowledge Base holds texts, and an agent finds the passage that fits. See Where each kind of information goes.

Create a Data Table.