capabilities.work

Create a Table and Upsert Rows

A 3-step recipe with Dust. We can help you get access.

Recipe · 3 steps

Create a Table and Upsert Rows

with Dust

Upsert a table, load rows, and read the table back.

  1. Upsert the table definition into the data source so rows can be loaded into it.
  2. Load the supplied rows into the table.
  3. Read the table back to confirm it was created and populated.
What you'll need to have ready
  • apiToken: Dust API key used as the Bearer token.
  • wId: The workspace identifier.
  • spaceId: The space identifier containing the data source.
  • dsId: The data source identifier.
  • tableId: The table identifier to upsert.
  • title: Title of the table.
  • description: Description of the table.
  • rows: Array of rows, each with a row_id and a value object.
  • truncate: Whether to truncate existing rows before upserting (defaults to false).
For your developer

Arazzo workflow dust-tt:create-table-and-upsert-rows, 3 operations: {$sourceDescriptions.datasourcesApi.url}#/paths/~1api~1v1~1w~1{wId}~1spaces~1{spaceId}~1data_sources~1{dsId}~1tables/post → {$sourceDescriptions.datasourcesApi.url}#/paths/~1api~1v1~1w~1{wId}~1spaces~1{spaceId}~1data_sources~1{dsId}~1tables~1{tId}~1rows/post → {$sourceDescriptions.datasourcesApi.url}#/paths/~1api~1v1~1w~1{wId}~1spaces~1{spaceId}~1data_sources~1{dsId}~1tables~1{tId}/get. Specs on APIs.io.

More recipes with Dust

Approve a Pending Agent Tool ActionAttach a File and Ask an AgentConverse with an AgentDiscover Spaces and Data SourcesFind Agent and Start a ConversationImport an Agent and Start a ConversationMessage an Agent and Submit FeedbackPost Follow-up Message and PollRun an App and Poll for CompletionSuggest a Mention and Start a Conversation