{"uid":"cap_TuJEXBGr1tOkuZ67v6669","slug":"openrefine-reference-catalog-reconciliation-review-605029e0","name":"OpenRefine Reference Catalog Reconciliation Review","description":"Reconciles a column of names against a reference catalog that you supply — your catalog, not a public knowledge base — using native OpenRefine reconciliation with a caller-set edit distance and an optional required type. The result separates rows with a single candidate, rows with several, and rows with none, and it leaves the ambiguous ones ambiguous: an automatic pick would be the cheapest possible way to introduce a wrong identity into a reference dataset.","url":"https://agent.halowerk.com/v1/oss-openrefine-reference-catalog-reconciliation-review?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"table":{"type":"object","required":["columns","rows"],"properties":{"rows":{"type":"array","items":{"type":"object","required":["id","values"],"properties":{"id":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"values":{"type":"array","items":{"anyOf":[{"type":"string","maxLength":4096},{"type":"null"}]},"maxItems":16,"minItems":1}},"additionalProperties":false},"maxItems":200,"minItems":1},"columns":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"maxItems":16,"minItems":1}},"additionalProperties":false},"catalog":{"type":"array","items":{"type":"object","required":["id","name","type"],"properties":{"id":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"name":{"type":"string","maxLength":256,"minLength":1},"type":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"}},"additionalProperties":false},"maxItems":100,"minItems":1},"query_column":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"required_type":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"max_edit_distance":{"type":"integer","maximum":8,"minimum":0}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.004","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.004/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_T793Ms6QXZPgaWG56Ynwm","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.004","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Reconciles a column of names against a caller-supplied reference catalog using OpenRefine edit-distance matching, returning rows grouped by match confidence (single, multiple, or no candidates) without auto-resolving ambiguous cases.","exampleAgentPrompt":"I have a table of 80 supplier names in the 'supplierName' column and a reference catalog of 50 known suppliers — can you reconcile them using a max edit distance of 2, filtering to type 'company', and group the results into single matches, multiple candidates, and no matches without auto-picking any ambiguous ones?","exampleUseCases":[{"title":"Museum collection authority reconciliation","prompt":"I have a table of artwork creator names from our museum database in the 'artistName' column and a catalog of 40 verified artists with their IDs — reconcile them with max edit distance 1 and type 'person', and show me which names match exactly one entry, which match several, and which match nothing."},{"title":"Drug formulary name deduplication","prompt":"We have a formulary of 100 drug entries and a table of 150 prescription names in the 'drugName' column — run a reconciliation with edit distance 3 and type 'medication' so I can see which prescriptions map to exactly one formulary drug, which are ambiguous, and which have no match at all."},{"title":"Vendor onboarding identity review","prompt":"Before we onboard these 60 new vendors, reconcile the 'vendorName' column in our pending table against our approved vendor catalog with an edit distance of 2 and type 'organization' — I need to see which are clear matches, which are ambiguous, and which are completely new so we can route them for manual review."}],"resultDescription":"Returns rows partitioned into three groups: rows with exactly one catalog candidate (confident matches), rows with multiple candidates (ambiguous, left unresolved for human review), and rows with no candidates (unmatched). Each matched row includes the candidate ID, name, and type from the catalog.","failureModes":["Invalid column name pattern (must match ^[A-Za-z][A-Za-z0-9_]{0,31}$) returns validation error","Catalog exceeds 100 entries — request rejected","Table exceeds 200 rows — request rejected","query_column not found in table columns — returns error","max_edit_distance outside 0–8 range — validation failure","Empty catalog array — validation error","All rows unmatched when edit distance is too low or catalog is too sparse"],"whenToPreferThis":"Choose this endpoint when you have a private reference catalog (not a public knowledge base) and need to reconcile entity names against it using fuzzy matching with a configurable edit distance, particularly when human review of ambiguous cases is required and auto-resolution of conflicts is unacceptable. Prefer this over generic deduplication tools when you need OpenRefine's native reconciliation semantics with explicit single/multiple/none grouping and type filtering.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T00:33:30.172Z","isFirstParty":false,"canonicalSlug":"openrefine-reference-catalog-reconciliation-review-605029e0"}