TimeTonic
DatabaseTimeTonic is a French no-code database and collaboration workspace built around books containing smart tables. Agents list books and tables, read table values, create and update rows and cells, roll back changes, manage cell comments, send book messages and attach files.
What This Integration Enables
TimeTonic is a French no-code workspace built around books, each holding smart tables, and its distinguishing habit is that discussion lives in the same object as the data. Comments attach to a cell rather than to a record, so the argument about a value sits on the value. Every book carries an activity stream a flow can read and post into. For an operations team, that removes the most common failure of a shared tracker, which is that the number is visible and the reason for it is not. A FlowRunner agent that finds a discrepancy can put its explanation exactly where the next reader will already be looking, rather than in a channel they might check.
The read side is built for flows that run often. List Table Row IDs transfers identifiers rather than values, Get Table Value Subset fetches only the cells named, and every read accepts a modified-since stamp and explicit field lists, which together are the difference between a workable polling flow and one that times out. Get Table Values By Sync Code addresses a table by a code that stays stable across copies of a workspace, so a flow keeps working against a templated or duplicated book where the numeric identifiers differ. Reference fields have to be set to one of the values Get Reference Field Values returns rather than to a raw string, which the connector surfaces so a write cannot fail silently on a link.
Without FlowRunner
With FlowRunner
Use Case Scenarios
-
A tracker that explains itself
Each cycle the agent calls List Table Row IDs with a modified-since stamp, then Get Table Value Subset for just the cells behind the rows that moved. Where a milestone date has slipped, Update Cell Value writes the revised forecast, and Get Cell Comments plus Edit Cell Comment maintain a single running note on the cell rather than a pile of new ones. A digest posts into the book with Send Message and into Slack for the people who do not live in TimeTonic. The number and the reason arrive together.
-
Scheduled work read out of the workspace
List Book Events returns the calendar events in a book over a date range, optionally narrowed to particular participants, and Get Calendar Data covers the personal view across every book a user can reach. The agent reads the week's committed work, compares it against the resource table, and syncs the confirmed items into Google Calendar so the people delivering the work see it where they already look. Conflicts are reported, not resolved.
-
An import that does not need to guess
A file of new records arrives. Create Or Update Rows handles the whole batch in one call, using TimeTonic's own convention where a row identifier beginning with a temporary prefix creates a row and anything else updates the row with that identifier. Before the write, the agent calls Get Reference Field Values for each link field so the values it sends are ones the field will actually accept, and Attach File To Cell binds any supporting document to the cell it belongs to. Where a row's identifier does not resolve cleanly, the flow reports it rather than writing, because on this API a wrong identifier updates the wrong record instead of failing.
Human-in-Loop Highlight
TimeTonic already decided that emptying a table is too serious for one call. Initialize Truncate Table deletes nothing: it returns a token which, combined with the same secret the caller chose, must be passed to Confirm Truncate Table before a single row goes. Roll Back Row Change is the closest thing this API has to an undo and it works on one row, so it will not recover a truncated table. This connector deliberately does not collapse the pair into one convenient operation, because collapsing it would throw away the vendor's own guard.
FlowRunner's contribution is to put a person where that guard was designed for one. The agent runs the first call, gathers the evidence, and hands over the half it does not hold: "Initialize Truncate Table returned a token for the 2025 Sites table, 14,880 rows. Nothing has been deleted. Confirm Truncate Table needs that token and the secret, and once it runs there is no row-level rollback for the table. Reply with the confirmation secret to proceed." The operations owner supplies it, or does not. Two things make this the right shape rather than a ceremony: the agent genuinely cannot proceed without a value only a person holds, and the pause is the vendor's, not an invention of ours. FlowRunner is at its best when the platform underneath already knows where the risk is, and the connectors preserve that boundary instead of smoothing it away.
Agent Capabilities
34 actionsAuthentication
5- Register Application Registers an application name and returns an app key. The first step of the login chain, identifying the integration rather than the user, so it is created once and reused.
- Create OAuth Key Logs a user in and returns an OAuth key, using either a password or an SSO token alongside the app key. Most integrations configure a session key on the connection instead of running this.
- Create Session Key Exchanges an OAuth key for the session key every other operation uses. Session keys do not expire on a fixed schedule, so this is normally a one time setup step rather than something a flow runs.
- Get User Info Returns the authenticated user's profile, workspace membership, and reachable books. Used to verify a connection and to discover the book owner and code values every other operation needs.
- Drop All Sessions Invalidates every session key issued to the authenticated user, including the one the connection is using. Used when a key may have been exposed, and every flow on that connection will fail until a new key is configured.
Books
5- List Books Returns the books the user can reach, each with the owner and code that together address every other resource on this API. A server stamp returns only what changed since a given point.
- Get Book Returns one book's title, members, settings, and metadata.
- List Tables Returns the smart tables in a book, each with its category id and field definitions. That category id is what every table operation calls a Table ID.
- List Book Events Returns calendar events in a book over a date range, optionally narrowed to particular events or participants.
- Get Calendar Data Returns the authenticated user's calendar across every book they can reach, rather than the events of one book.
Tables
11- Get Table Values Returns the rows and cell values of a smart table. The main read, and the one whose options matter most at scale: field lists, dropping the schema block, and a modified-since stamp that keeps a polling flow from re-reading everything.
- Get Table Values By Sync Code Returns a table's rows addressed by its sync code rather than its numeric id. Sync codes are stable across copies of a workspace, which is what makes a flow portable to a templated or duplicated book.
- Get Table Value Subset Returns only the intersection of the rows and fields named. Far cheaper than reading a table and discarding most of it.
- List Table Row IDs Returns just the row identifiers, optionally through a saved view and optionally only those modified after a timestamp. The cheapest way to detect that something changed.
- Compute Table Operation Runs an aggregate over a table on TimeTonic's side rather than pulling rows into the flow. Only count is supported at present, which the vendor states plainly.
- Get Reference Field Values Returns the values available in a link, foreign enumeration, or lookup field. Writing a raw string to a reference field does not work, so this is what makes setting one possible.
- Get Pivot Table Values Returns a pivot computed over a date range through a saved view. Both the dates and the view are required, because a pivot here is defined by the view rather than by call parameters.
- Render Smart Text Field Renders one smart text cell, resolving the formulas and references inside it into the text a person would see. Used when the stored value is a template and the flow needs the evaluated output.
- Verify Encrypted Field Password Checks a password against an encrypted field without reading its contents, so a flow can validate before calling operations that otherwise fail opaquely.
- Initialize Truncate Table Begins removing every row from a table and returns a token. Nothing is deleted by this call. It is the first half of the vendor's guard against an accidental mass delete.
- Confirm Truncate Table Deletes every row in a table, requiring the token from the first call and the identical secret chosen there. There is no undo, and single-row rollback will not recover a truncated table. This is where this page's human gate sits.
Rows
5- Create Or Update Row Creates a row or updates an existing one in a single call, with the row identifier deciding which: a temporary prefix creates, anything else updates the row with that identifier. Treat the identifier as the important parameter, because a wrong one updates the wrong record rather than failing.
- Create Or Update Rows Creates or updates several rows in one call, with the same convention per row. The right choice for a bulk import rather than looping the single operation.
- Update Cell Value Writes one cell. The same identifier convention applies, so use an existing identifier when the intent is to edit.
- Delete Row Permanently deletes a row. A context message is written into the row's history, which is what lets someone reviewing the audit trail later see why it went.
- Roll Back Row Change Reverts a row to its state before a given change, using the change id from the row's history. The closest thing this API has to an undo, and it works on a single row.
Comments
3- Get Cell Comments Returns the comments attached to one cell. TimeTonic stores comments per cell rather than per record, so a cell is addressed by table, field, and row together.
- Edit Cell Comment Replaces the text of an existing cell comment, which is how a flow maintains one running note rather than a pile of new ones.
- Delete Cell Comment Permanently deletes a cell comment by its identifier.
Messages
4- List Book Messages Returns the messages posted in a book's activity stream, which is where conversation about the records lives.
- Send Message Posts a message into a book's activity stream. How a flow reports back to the people working in the workspace rather than only writing data.
- Delete Message Permanently deletes a message from a book's activity stream.
- Mark Messages As Read Marks messages in one or more books as read for the authenticated user, which is how a flow processing an activity stream stops picking up the same items.
Files
1- Attach File To Cell Attaches an already uploaded file to a specific cell, addressed by row and field. TimeTonic's upload is two stages, and this is the call that binds the file to the cell.
Frequently Asked Questions
What can FlowRunner do with TimeTonic?
FlowRunner agents can run Register Application, Create OAuth Key, and Create Session Key in TimeTonic, plus 31 more actions.
Does connecting TimeTonic to FlowRunner require OAuth?
No. TimeTonic connects to FlowRunner with an API key, no OAuth flow required.
Can TimeTonic trigger a FlowRunner workflow automatically?
TimeTonic doesn't currently expose triggers in FlowRunner. It connects as an action step inside workflows started by another trigger.
Other Database integrations
Start building with TimeTonic
Free plan, no card required. Connect in minutes.