JSON CRUD icon

JSON CRUD

Perform CRUD operations on JSON data (perfect for Excel data)

Actions6

Remove Duplicates

AI-generated

Summary

Remove duplicate records from the input JSON data based on specified unique fields or entire record content if no fields are specified.

Inputs

  • Unique Fields — Comma-separated list of field names to identify duplicates. If empty, duplicates are identified by entire record content.

Output shape

a list of JSON records

Returns the input records filtered to exclude duplicates. Duplicate detection is done by concatenating specified unique field values or by JSON stringification of the whole record if no fields specified.

Links

Discussion