oneAI icon

oneAI

Interact with the oneAI API

Dataset Row → Append Many

AI-generated

Summary

Append all incoming items as rows to a OneAI dataset in the specified space. Choose automatic field mapping or provide each row as raw JSON, and optionally exclude fields or allow the import to create a missing dataset.

Inputs

  • Space ID (required) — ID of the space containing the dataset. The operation makes one request for all input items, so expressions are evaluated against the first item only.
  • Table Name (required) — Name of the dataset to append to. Expressions are evaluated against the first item only.
  • Data Mode (required) — Choose Auto-Map Input Data to Columns to use each incoming item as a row, matching field names to column names, or Raw JSON to supply rows as JSON objects. Raw JSON preserves native numbers, booleans, and other JSON values; the column fields supplied by the other mode are passed as strings.
  • Data (JSON) — In Raw JSON mode, provide the row as a JSON object keyed by column name.
  • Create Table if Missing — When enabled, let the import create the dataset if it does not exist; its columns will be VARCHAR because the import uses an untyped CSV. When disabled, the node checks the space's tables and fails with a named error if the dataset is missing.
  • Fields to Ignore — Comma-separated input field names to omit from rows, useful for dropping fields that are not dataset columns.

Output shape

A list of items corresponding to the input rows, with the import response data.

The operation sends one request for all input items. An extra field that does not match a dataset column can cause the write to fail unless it is ignored.

Links

Discussion