NocoDB (Custom) icon

NocoDB (Custom)

Work with NocoDB rows and links

Row → Upsert

AI-generated

Summary

Update existing row if filter groups match; otherwise create new row.

Inputs

None.

Output shape

jsonArray

Each item returns the row record tagged with _upsertAction ('created' or 'updated'), or an error object if continueOnFail.

Examples

Example 1: Create new row

fieldsCollection provides values, filterGroups provide no matches → POST new record, returned with _upsertAction: 'created'

Example 2: Update existing row

fieldsCollection provides values, filterGroups match exactly one row → PATCH that row, returned refreshed with _upsertAction: 'updated'

Example 3: Error on multiple matches

filterGroups match >1 row AND upsertOptions.errorOnMultipleMatches (default true) → throws NodeApiError

Links

Discussion