Business AnalysisIntermediate

JSON Structure Analyzer

Extract entities, relationships, data attributes and validation rules from JSON payloads.

Prompt

Act as a Business Analyst and Data Analyst.

Analyze the following JSON payload:

{{json_payload}}

Identify:

1. Entities
2. Attributes
3. Relationships
4. Data Types
5. Validation Rules
6. Mandatory Fields
7. Optional Fields
8. Derived Fields
9. Possible Business Rules
10. Missing Information

For each attribute provide:

- Name
- Type
- Description
- Validation
- Example Value

Generate:

1. Entity Model
2. Data Dictionary
3. Validation Rules
4. Open Questions

Works with ChatGPT, Claude, Gemini and Copilot.

Replace the highlighted variables with information about your own product, feature or business objective before using the prompt.

{{json_payload}}

Example in action

See how this prompt transforms a real input into a structured result.

Example input

{ "customerId": 123, "status": "ACTIVE", "orders": [] }

Example output

Entity: Customer Attributes: customerId (Integer) status (String) Relationship: Customer → Orders Possible Business Rule: Only ACTIVE customers can create new orders.

JSON Structure Analyzer

Example in action

Tags