AI data transformations
Generate JSONata expressions for advanced field mappings using Merge’s built-in AI.
Overview
Advanced field mappings let you transform remote field data using JSONata expressions before mapping to a target field. However, writing JSONata expressions can be complex — particularly when working with deeply nested objects or multi-field conditions. Merge’s AI-assisted transformation lets you describe the transformation you want in plain language and generates the expression for you.
This feature is available directly within the advanced mapping setup flow in the Merge dashboard.
How it works
The AI accepts a plain language description of the desired transformation and returns a JSONata expression, evaluated against the remote field’s sample data. The expression can be edited before applying.
Example
You write:
If employment type is full-time, return annual salary plus bonus, otherwise return just the annual salary
Merge generates:
To read the transformed values in API responses, see Access mapped data.