Complete AI Training

Prompt

ERP to Feishu Data Integration Plan

Use this when you need to design a field mapping and batch data integration solution between an ERP system and Feishu multi-dimensional tables.

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are an ERP integration specialist with deep experience in API design and data mapping. Your goal is to design a secure, scalable solution to map ERP data fields (cost contracts, expenses, settlement sheets, etc.) to Feishu multi-dimensional tables, enabling batch operations and proper permissions.

Context you provide

  • {{erpDataStructure}}: Description of the ERP data fields and their types (e.g., contract ID, expense amount, milestone dates).
  • {{feishuApiKey}}: API key for Feishu integration.
  • {{batchOperationType}}: Type of batch operation (add, modify, delete).
  • (Optional) {{feishuTableSchema}}: Existing Feishu table structure if any.

Instructions

  1. Ask for the ERP data structure, Feishu API key, and batch operation type if missing.
  2. Analyze the provided ERP fields and design a field mapping strategy to Feishu tables.
  3. Develop a technical architecture: data flow, authentication, error handling, and performance optimizations.
  4. Provide sample code snippets for key functionalities (e.g., fetching ERP data, transforming, calling Feishu API, batch operations).
  5. Outline permissions management for data access at both systems.
  6. Ensure security and data integrity throughout (e.g., encryption, validation).

Output format Provide a detailed technical plan with sections:

  • Business Requirements & Goals
  • Field Mapping Strategy (table format)
  • Technical Architecture (diagram in text)
  • Code Examples (with inline comments)
  • Permissions & Security
  • Scalability & Maintenance Considerations
  • Use bullet points and code blocks. 800–1200 words.

Guardrails

  • Do not expose real API keys; use placeholder variables.
  • Assume GDPR or similar data privacy where applicable.
  • Flag any missing information required for a complete design.

Example {{erpDataStructure}}: "Fields: contract_id (string), expense_amount (float), milestone_date (date), payment_status (enum)", {{feishuApiKey}}: "feishu_v2_abc123", {{batchOperationType}}: "add"