Find incomplete records, normalize field values in bulk, dedupe with `hubspot objects merge`, and audit custom properties. Builds on `bulk-operations` for JSONL piping and dry-run/digest/confirm.

Read bulk operations/SKILL.md first — JSONL piping, batch read, pagination, and dry run/digest/confirm gating apply to every command below. Property discovery Don't guess property names. List them: Same for type companies , deals , or any custom type ( hubspot objects types ). 1. Find incomplete records !name = NOT HAS PROPERTY (missing or empty). Bare name = HAS PROPERTY. Within one filter , chain with AND ; multiple filter flags are OR'd. For 100 results, use the pagination loop from bulk operations . 2. Normalize field values Search → reshape with jq → pipe into update . Always dry run first; bulk operations covers digest/confirm escalation for 100 rows. Reshape patterns: bulk operations/resources/json patterns.md . 3. Dedupe with hubspot objects merge Secondary is folded into primary and deleted. Irreversible. Dry run/digest/confirm gating applies. Bulk: pipe JSONL {"primary":"...","secondary":"..."} on stdin (omit primary / secondary ). Pagination required. objects search caps at 100 rows per call and jq s slurps a single stream into memory — running the snippet below against a raw search will silently miss every duplicate that crosses a page boundary. Collect the full set first with the pagination loop from bulk operations/SKILL.md (write to /tmp/contacts.jsonl ), then dedupe from the file: For 100 pairs, lift digest and impact.records affected from the BulkData line and re pipe the same producer with digest / confirm (see bulk operations ). 4. Audit properties hubspot properties list (and get , batch read ) emits {name, label, type, fieldType, groupName} per row. Enum option values are not currently exposed by the CLI — read them off a real record ( hubspot objects search ... properties <enum ) or the HubSpot UI. Recovery Merge is irreversible. After any merge, hubspot history since 1h captures the audit trail. If wrong direction, restore the secondary from the UI's recycle bin.

crm-data-quality