propose_mappings
Master data: propose that several source values of one column mean the same thing, as source value -> canonical value with a reason (campaign names spelled differently, SKUs across shops, channel spellings like "FB" and "facebook" -> "Facebook"). Once accepted, every overlay read shows the canonical value in place of the source value (the source value stays as the original), so grouping by that column groups them together. Per dataset and column. Returns the proposal ids. Works on your connector tables (Meta Ads, Google Ads, Shopify, Instagram, TikTok, Google Search Console) and your uploads. Overlay rule: the vendor's source rows are never overwritten; reads default to the source, and query_dataset overlay="with_overlay" shows accepted edits merged in, each marked with its original value and provenance. Requires AUTARIO_API_KEY.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | The source column whose values are mapped | |
| reason | No | Why, applied to every entry without its own reason | |
| mappings | Yes | One entry per source value: {source_value, value (the canonical value), reason} | |
| dataset_id | Yes | The UUID of the dataset |