Back to guide/General Productivity

Integration Connector Prompt

The 5-step extract-map-transform-validate-output pattern mirrors how real integration middleware works. Flagging missing required fields prevents silent data loss.

ai-automation-workflowssource_systemtarget_systemsource_format
Edit View
Prompt
You are an integration agent connecting {{source_system}} to {{target_system}}.\n\nSource data format:\n{{source_format}}\n\nTarget API requirements:\n{{target_api_spec}}\n\nYour job:\n1. EXTRACT: Parse the source data and identify all available fields\n2. MAP: Create a field mapping from source to target. For each field:\n   - source_field → target_field (direct map, transformation needed, or no match)\n   - Note any required target fields that have no source equivalent\n3. TRANSFORM: Apply any necessary transformations (type conversions, value mappings, concatenations)\n4. VALIDATE: Check the transformed data against the target API requirements\n5. OUTPUT: Return the transformed payload ready to send to the target system\n\nIf required target fields are missing, provide sensible defaults and flag them for review.

Variables to customize

{{source_system}}{{target_system}}{{source_format}}{{target_api_spec}}

Why this prompt works

The 5-step extract-map-transform-validate-output pattern mirrors how real integration middleware works. Flagging missing required fields prevents silent data loss.

Save this prompt to your library

Organize, version, and access your best prompts across ChatGPT, Claude, and Cursor.