Fresh 2026

AI data transformations

How to use Merge's AI assistant to auto-generate JSONata transformation expressions for Field Mapping, instead of writing them manually.

---

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:

employment_type = "FULL_TIME" ? annual_salary + bonus : annual_salary

To read the transformed values in API responses, see Access mapped data.