Auto Mapping (Append Operation)
The Auto Mapping feature in the Append Operation provides an intelligent way to generate the JSON required for mapping and appending data to your dataset. By supplying the source and target schemas, Auto Mapping automatically suggests and creates the field mappings needed to transform incoming data fields into the structure expected by the target system.
This is particularly useful for accurately mapping fields from your data source to the corresponding fields in the destination, ensuring proper data transformation and append behavior without manual JSON construction.
Default Mode (Manual JSON Entry)
By default, Auto Mapping is turned off.
In this mode:
- You manually enter or edit the Append JSON directly in the editor.
- You can copy or clear the content as needed.
This mode is ideal when you prefer complete manual control or need a custom configuration that doesnt follow standard schema mapping.
Auto Mapping Mode
When you turn Auto Mapping on:
- The manual editor is replaced with an assisted mapping interface.
- You provide the Source Schema (the structure of your incoming data) and the Target Schema (the desired structure in the destination).
- The Source Schema can be entered manually or turn on the Auto Populate toggle to automatically retrieve and populate the source schema
- Once both schemas are ready, click Map to generate the Append JSON automatically using an AI-powered mapping process.
- The generated JSON appears in a Preview area, where you can review it, copy it if needed, or clear it to start over.
Auto Mapping simplifies complex mappings, reduces errors, and saves time, especially when dealing with large or unfamiliar schemas.
Switching Back to Manual Mode
When you turn Auto Mapping off:
- The assisted interface disappears.
- The generated JSON from the Preview (if any) is automatically transferred to the main editor.
- You return to the manual mode, where you can further refine, adjust, or use the generated JSON as a starting point.