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
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
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
- Ask for the ERP data structure, Feishu API key, and batch operation type if missing.
- Analyze the provided ERP fields and design a field mapping strategy to Feishu tables.
- Develop a technical architecture: data flow, authentication, error handling, and performance optimizations.
- Provide sample code snippets for key functionalities (e.g., fetching ERP data, transforming, calling Feishu API, batch operations).
- Outline permissions management for data access at both systems.
- 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"