Skip to main content
Splits a list into “missing from” and “present in” a second list, matched by a key read from each item. The reconciliation workhorse: feed it your stored mappings and a freshly fetched source list, and the missing partition is exactly the orphans.

​
Configuration

  • Left assign — the list to partition (e.g. rows from an Entity Mapping List).
  • Left key path — dot-path to each left item’s key, e.g. external_id or metadata.source_id.
  • Right assign — the reference list (e.g. rows fetched by a Flow Action).
  • Right key path — dot-path to each right item’s key, e.g. id.
  • Missing output assign — receives left items whose key is absent from the right list.
  • Present output assign — receives left items whose key is found in the right list.
Configure either output or both — a blank output is simply not written.

​
Tips

  • Follow the missing output with a Flow Each to act on each orphan (delete the target row, then an Entity Mapping Delete).
  • Left items with no value at the key path go to neither output; the log reports how many, which is the tell for a mistyped path.
  • If the right assign is missing or not a list, the node no-ops instead of declaring everything missing.

​
Ports