Examples

Comprehensive real-world examples demonstrating JSON Path mapping in common business scenarios.

E-commerce Order Processing

Scenario: Process New Order

You receive an order from an API and need to transform it for your system.

Source Data
Mapping Configuration
Result

{
  "get_order": {
    "orderId": "ORD-2025-001",
    "customer": {
      "id": "CUST-123",
      "firstName": "Sarah",
      "lastName": "Chen",
      "email": "[email protected]",
      "phone": "+1-555-0123"
    },
    "items": [
      {
        "sku": "WIDGET-001",
        "name": "Premium Widget",
        "quantity": 2,
        "price": 49.99,
        "discount": 0.1
      },
      {
        "sku": "GADGET-005",
        "name": "Smart Gadget",
        "quantity": 1,
        "price": 129.99,
        "discount": 0
      }
    ],
    "shipping": {
      "method": "express",
      "address": {
        "street": "123 Main St",
        "city": "San Francisco",
        "state": "CA",
        "zip": "94105"
      },
      "cost": 12.50
    },
    "payment": {
      "method": "credit_card",
      "last4": "4242",
      "status": "authorized"
    },
    "timestamps": {
      "created": "2025-10-08T10:30:00Z",
      "updated": "2025-10-08T10:35:00Z"
    }
  }
}

{
  "orderNumber": "$.get_order.orderId",
  "customerName": "$.get_order.customer.firstName| |$.get_order.customer.lastName",
  "customerEmail": "$.get_order.customer.email",
  "customerPhone": "$.get_order.customer.phone",
  "itemCount": "$.get_order.items.length",
  "allProducts": "$.get_order.items[*].name",
  "totalBeforeDiscount": "$.get_order.items[*].price",
  "discountedItems": "$.get_order.items[?(@.discount>0)]",
  "firstItemSku": "$.get_order.items[0].sku",
  "shippingAddress": "$.get_order.shipping.address.street|, |$.get_order.shipping.address.city|, |$.get_order.shipping.address.state| |$.get_order.shipping.address.zip",
  "shippingMethod": "Shipping: |$.get_order.shipping.method",
  "paymentInfo": "$.get_order.payment.method| ending in |$.get_order.payment.last4",
  "orderDate": "$.get_order.timestamps.created",
  "isExpressShipping": "$.get_order.shipping[?(@.method==='express')]"
}

{
  "orderNumber": "ORD-2025-001",
  "customerName": "Sarah Chen",
  "customerEmail": "[email protected]",
  "customerPhone": "+1-555-0123",
  "itemCount": 2,
  "allProducts": ["Premium Widget", "Smart Gadget"],
  "totalBeforeDiscount": [49.99, 129.99],
  "discountedItems": [
    {
      "sku": "WIDGET-001",
      "name": "Premium Widget",
      "quantity": 2,
      "price": 49.99,
      "discount": 0.1
    }
  ],
  "firstItemSku": "WIDGET-001",
  "shippingAddress": "123 Main St, San Francisco, CA 94105",
  "shippingMethod": "Shipping: express",
  "paymentInfo": "credit_card ending in 4242",
  "orderDate": "2025-10-08T10:30:00Z",
  "isExpressShipping": [{"method": "express", "address": {...}, "cost": 12.50}]
}

Key Techniques Used:

Pipe operator for full name concatenation
Pipe operator for formatted address
Array wildcard [*] to get all product names
Filter ?(@.discount>0) to find discounted items
.length to count items
Array indexing [0] for first item

User Management & Authorization

Scenario: User Profile Enrichment

Combine user data from multiple API calls to create a complete profile.

Source Data
Mapping Configuration
Result

{
  "get_user": {
    "userId": "USER-456",
    "username": "jsmith",
    "email": "[email protected]",
    "status": "active",
    "createdAt": "2024-01-15T08:00:00Z"
  },
  "get_permissions": {
    "roles": ["editor", "reviewer"],
    "permissions": [
      {"resource": "articles", "actions": ["read", "write", "publish"]},
      {"resource": "comments", "actions": ["read", "moderate"]},
      {"resource": "analytics", "actions": ["read"]}
    ],
    "restrictions": {
      "maxFileSize": 10485760,
      "allowedFileTypes": ["jpg", "png", "pdf", "docx"]
    }
  },
  "get_activity": {
    "lastLogin": "2025-10-08T09:15:00Z",
    "loginCount": 247,
    "recentActions": [
      {"action": "published_article", "timestamp": "2025-10-08T09:20:00Z", "articleId": "ART-123"},
      {"action": "edited_article", "timestamp": "2025-10-08T08:45:00Z", "articleId": "ART-122"},
      {"action": "moderated_comment", "timestamp": "2025-10-07T16:30:00Z", "commentId": "COM-789"}
    ]
  }
}

{
  "userId": "$.get_user.userId",
  "displayName": "$.get_user.username| (|$.get_user.email|)",
  "accountStatus": "Status: |$.get_user.status",
  "memberSince": "$.get_user.createdAt",
  "primaryRole": "$.get_permissions.roles[0]",
  "allRoles": "$.get_permissions.roles[*]",
  "canPublish": "$.get_permissions.permissions[?(@.resource==='articles')].actions",
  "hasModeratorAccess": "$.get_permissions.permissions[?(@.resource==='comments' && @.actions[*]==='moderate')]",
  "allowedFileTypes": "Allowed: |$.get_permissions.restrictions.allowedFileTypes[*]",
  "maxUploadSize": "$.get_permissions.restrictions.maxFileSize",
  "lastActive": "$.get_activity.lastLogin",
  "totalLogins": "$.get_activity.loginCount",
  "recentActivity": "$.get_activity.recentActions[0:3]",
  "lastAction": "$.get_activity.recentActions[0].action| at |$.get_activity.recentActions[0].timestamp",
  "isActiveUser": "$.get_activity[?(@.loginCount>100)]"
}

{
  "userId": "USER-456",
  "displayName": "jsmith ([email protected])",
  "accountStatus": "Status: active",
  "memberSince": "2024-01-15T08:00:00Z",
  "primaryRole": "editor",
  "allRoles": ["editor", "reviewer"],
  "canPublish": [["read", "write", "publish"]],
  "hasModeratorAccess": [
    {"resource": "comments", "actions": ["read", "moderate"]}
  ],
  "allowedFileTypes": "Allowed: jpg,png,pdf,docx",
  "maxUploadSize": 10485760,
  "lastActive": "2025-10-08T09:15:00Z",
  "totalLogins": 247,
  "recentActivity": [
    {"action": "published_article", "timestamp": "2025-10-08T09:20:00Z", "articleId": "ART-123"},
    {"action": "edited_article", "timestamp": "2025-10-08T08:45:00Z", "articleId": "ART-122"},
    {"action": "moderated_comment", "timestamp": "2025-10-07T16:30:00Z", "commentId": "COM-789"}
  ],
  "lastAction": "published_article at 2025-10-08T09:20:00Z",
  "isActiveUser": [{"lastLogin": "2025-10-08T09:15:00Z", "loginCount": 247, "recentActions": [...]}]
}

Advanced Pattern: This example shows how to combine data from three different API calls (get_user, get_permissions, get_activity) into a single enriched user profile.

CRM & Sales Pipeline

Scenario: Lead Scoring & Qualification

Score leads based on activity, engagement, and company data.

Source Data
Mapping Configuration
Result

{
  "get_lead": {
    "leadId": "LEAD-789",
    "contact": {
      "name": "Michael Rodriguez",
      "title": "VP of Engineering",
      "email": "[email protected]",
      "phone": "+1-555-0199"
    },
    "company": {
      "name": "TechCorp Solutions",
      "industry": "Software",
      "size": "500-1000",
      "revenue": "50M-100M",
      "website": "https://techcorp.com"
    },
    "engagement": {
      "score": 85,
      "activities": [
        {"type": "email_open", "count": 12, "lastDate": "2025-10-08"},
        {"type": "link_click", "count": 5, "lastDate": "2025-10-07"},
        {"type": "form_submit", "count": 2, "lastDate": "2025-10-06"},
        {"type": "demo_request", "count": 1, "lastDate": "2025-10-05"}
      ],
      "pageViews": [
        {"page": "pricing", "visits": 8},
        {"page": "features", "visits": 5},
        {"page": "case-studies", "visits": 3}
      ]
    },
    "sourceInfo": {
      "channel": "organic_search",
      "campaign": "Q4_Enterprise",
      "firstTouch": "2025-09-15T14:30:00Z"
    }
  }
}

{
  "leadId": "$.get_lead.leadId",
  "contactSummary": "$.get_lead.contact.name| - |$.get_lead.contact.title| at |$.get_lead.company.name",
  "email": "$.get_lead.contact.email",
  "companyProfile": "$.get_lead.company.name| (|$.get_lead.company.industry|, |$.get_lead.company.size| employees, $|$.get_lead.company.revenue| revenue)",
  "engagementScore": "Score: |$.get_lead.engagement.score|/100",
  "isHotLead": "$.get_lead.engagement[?(@.score>=80)]",
  "totalActivities": "$.get_lead.engagement.activities[*].count",
  "hasDemoRequest": "$.get_lead.engagement.activities[?(@.type==='demo_request')]",
  "highValueActivities": "$.get_lead.engagement.activities[?(@.count>=5)]",
  "topVisitedPage": "$.get_lead.engagement.pageViews[0].page",
  "pricingPageViews": "$.get_lead.engagement.pageViews[?(@.page==='pricing')].visits",
  "recentActivity": "$.get_lead.engagement.activities[?(@.lastDate>='2025-10-07')]",
  "sourceChannel": "Source: |$.get_lead.sourceInfo.channel| (|$.get_lead.sourceInfo.campaign|)",
  "daysSinceFirstTouch": "$.get_lead.sourceInfo.firstTouch",
  "qualificationStatus": "$.get_lead[?(@.engagement.score>=80 && @.company.size==='500-1000')]"
}

{
  "leadId": "LEAD-789",
  "contactSummary": "Michael Rodriguez - VP of Engineering at TechCorp Solutions",
  "email": "[email protected]",
  "companyProfile": "TechCorp Solutions (Software, 500-1000 employees, $50M-100M revenue)",
  "engagementScore": "Score: 85/100",
  "isHotLead": [{"score": 85, "activities": [...], "pageViews": [...]}],
  "totalActivities": [12, 5, 2, 1],
  "hasDemoRequest": [
    {"type": "demo_request", "count": 1, "lastDate": "2025-10-05"}
  ],
  "highValueActivities": [
    {"type": "email_open", "count": 12, "lastDate": "2025-10-08"},
    {"type": "link_click", "count": 5, "lastDate": "2025-10-07"}
  ],
  "topVisitedPage": "pricing",
  "pricingPageViews": [8],
  "recentActivity": [
    {"type": "email_open", "count": 12, "lastDate": "2025-10-08"},
    {"type": "link_click", "count": 5, "lastDate": "2025-10-07"}
  ],
  "sourceChannel": "Source: organic_search (Q4_Enterprise)",
  "daysSinceFirstTouch": "2025-09-15T14:30:00Z",
  "qualificationStatus": [{"leadId": "LEAD-789", "contact": {...}, "company": {...}, "engagement": {...}}]
}

Scoring Logic: Use filters to identify hot leads (score>=80), demo requests, and recent activity to prioritize sales follow-up.

Inventory Management

Scenario: Stock Level Monitoring

Track inventory across multiple warehouses and trigger reorder alerts.

{
  "get_inventory": {
    "productId": "PROD-2025",
    "sku": "LAPTOP-PRO-15",
    "name": "Professional Laptop 15\"",
    "category": "Electronics",
    "warehouses": [
      {
        "id": "WH-EAST",
        "location": "New York",
        "quantity": 45,
        "reserved": 12,
        "available": 33,
        "reorderPoint": 25,
        "reorderQuantity": 50
      },
      {
        "id": "WH-WEST",
        "location": "Los Angeles",
        "quantity": 18,
        "reserved": 5,
        "available": 13,
        "reorderPoint": 20,
        "reorderQuantity": 50
      },
      {
        "id": "WH-CENTRAL",
        "location": "Chicago",
        "quantity": 62,
        "reserved": 8,
        "available": 54,
        "reorderPoint": 30,
        "reorderQuantity": 75
      }
    ],
    "supplier": {
      "name": "TechSupply Co",
      "leadTime": 14,
      "minOrderQuantity": 25
    },
    "pricing": {
      "cost": 850,
      "retail": 1299,
      "margin": 0.346
    }
  }
}

Smart Filtering: Identify warehouses below reorder points, critical stock levels, or high inventory for redistribution decisions.

Customer Support Ticket Routing

Scenario: Intelligent Ticket Assignment

Route support tickets based on priority, customer tier, and agent expertise.

Source Data
Mapping Configuration
Result

{
  "get_ticket": {
    "ticketId": "TKT-10234",
    "subject": "API Integration Issues",
    "description": "Getting 429 rate limit errors on webhook endpoints",
    "priority": "high",
    "category": "technical",
    "tags": ["api", "webhooks", "rate-limiting"],
    "customer": {
      "id": "CUST-5678",
      "name": "Acme Corp",
      "tier": "enterprise",
      "plan": "professional",
      "accountManager": "AM-123"
    },
    "reportedBy": {
      "name": "Tom Anderson",
      "email": "[email protected]",
      "role": "CTO"
    },
    "timestamps": {
      "created": "2025-10-08T10:15:00Z",
      "firstResponse": null,
      "resolved": null
    },
    "metadata": {
      "affectedUsers": 45,
      "businessImpact": "high",
      "slaDeadline": "2025-10-08T14:15:00Z"
    }
  },
  "get_team": {
    "agents": [
      {
        "id": "AGENT-001",
        "name": "Sarah Kim",
        "expertise": ["api", "integrations", "webhooks"],
        "currentLoad": 3,
        "maxCapacity": 5,
        "available": true
      },
      {
        "id": "AGENT-002",
        "name": "Mike Johnson",
        "expertise": ["billing", "accounts"],
        "currentLoad": 4,
        "maxCapacity": 5,
        "available": true
      },
      {
        "id": "AGENT-003",
        "name": "Lisa Chen",
        "expertise": ["api", "infrastructure", "performance"],
        "currentLoad": 2,
        "maxCapacity": 5,
        "available": true
      }
    ]
  }
}

{
  "ticketSummary": "Ticket #|$.get_ticket.ticketId|: |$.get_ticket.subject",
  "priorityLevel": "[|$.get_ticket.priority| Priority] |$.get_ticket.category| issue",
  "customerInfo": "$.get_ticket.customer.name| (|$.get_ticket.customer.tier| / |$.get_ticket.customer.plan|)",
  "reportedBy": "$.get_ticket.reportedBy.name| (|$.get_ticket.reportedBy.role|) - |$.get_ticket.reportedBy.email",
  "businessImpact": "Impact: |$.get_ticket.metadata.businessImpact| (|$.get_ticket.metadata.affectedUsers| users affected)",
  "slaDeadline": "SLA: |$.get_ticket.metadata.slaDeadline",
  "ticketTags": "Tags: |$.get_ticket.tags[*]",
  "isHighPriority": "$.get_ticket[?(@.priority==='high' || @.priority==='urgent')]",
  "isEnterprise": "$.get_ticket.customer[?(@.tier==='enterprise')]",
  "qualifiedAgents": "$.get_team.agents[?(@.expertise[*]==='api' && @.available===true)]",
  "bestAgent": "$.get_team.agents[?(@.expertise[*]==='api' && @.expertise[*]==='webhooks' && @.available===true && @.currentLoad<@.maxCapacity)]",
  "lowLoadAgents": "$.get_team.agents[?(@.currentLoad<=3 && @.available===true)]",
  "availableCapacity": "$.get_team.agents[?(@.available===true)].maxCapacity",
  "assignTo": "$.get_team.agents[?(@.id==='AGENT-001' || @.id==='AGENT-003')][0].name"
}

{
  "ticketSummary": "Ticket #TKT-10234: API Integration Issues",
  "priorityLevel": "[high Priority] technical issue",
  "customerInfo": "Acme Corp (enterprise / professional)",
  "reportedBy": "Tom Anderson (CTO) - [email protected]",
  "businessImpact": "Impact: high (45 users affected)",
  "slaDeadline": "SLA: 2025-10-08T14:15:00Z",
  "ticketTags": "Tags: api,webhooks,rate-limiting",
  "isHighPriority": [{"ticketId": "TKT-10234", ...full ticket object}],
  "isEnterprise": [{"id": "CUST-5678", "name": "Acme Corp", "tier": "enterprise", ...}],
  "qualifiedAgents": [
    {"id": "AGENT-001", "name": "Sarah Kim", "expertise": ["api", "integrations", "webhooks"], "currentLoad": 3, "maxCapacity": 5, "available": true},
    {"id": "AGENT-003", "name": "Lisa Chen", "expertise": ["api", "infrastructure", "performance"], "currentLoad": 2, "maxCapacity": 5, "available": true}
  ],
  "bestAgent": [
    {"id": "AGENT-001", "name": "Sarah Kim", "expertise": ["api", "integrations", "webhooks"], "currentLoad": 3, "maxCapacity": 5, "available": true}
  ],
  "lowLoadAgents": [
    {"id": "AGENT-001", "name": "Sarah Kim", ...},
    {"id": "AGENT-003", "name": "Lisa Chen", ...}
  ],
  "availableCapacity": [5, 5, 5],
  "assignTo": "Sarah Kim"
}

Intelligent Routing: This example demonstrates complex filtering to find the best-matched agent based on expertise (api AND webhooks), availability, and current workload.

Marketing Campaign Analysis

Scenario: Multi-Channel Campaign Performance

Analyze campaign performance across email, social, and paid channels.

Source Data

{
  "get_campaign": {
    "campaignId": "CAMP-Q4-2025",
    "name": "Q4 Product Launch",
    "startDate": "2025-10-01",
    "endDate": "2025-12-31",
    "budget": 50000,
    "channels": [
      {
        "name": "email",
        "sent": 25000,
        "delivered": 24500,
        "opened": 9800,
        "clicked": 2450,
        "converted": 245,
        "revenue": 122500,
        "cost": 5000
      },
      {
        "name": "social",
        "impressions": 500000,
        "engagement": 15000,
        "clicks": 7500,
        "converted": 150,
        "revenue": 75000,
        "cost": 12000
      },
      {
        "name": "paid_search",
        "impressions": 750000,
        "clicks": 22500,
        "converted": 675,
        "revenue": 337500,
        "cost": 18000
      }
    ],
    "topPages": [
      {"url": "/product", "visits": 45000, "conversionRate": 0.025},
      {"url": "/pricing", "visits": 32000, "conversionRate": 0.045},
      {"url": "/demo", "visits": 18000, "conversionRate": 0.085}
    ]
  }
}

Mapping Configuration

{
  "campaignName": "Campaign: |$.get_campaign.name| (|$.get_campaign.campaignId|)",
  "campaignPeriod": "$.get_campaign.startDate| to |$.get_campaign.endDate",
  "totalBudget": "Budget: $|$.get_campaign.budget",
  "channelNames": "$.get_campaign.channels[*].name",
  "emailPerformance": "Emails: |$.get_campaign.channels[?(@.name==='email')].sent| sent, |$.get_campaign.channels[?(@.name==='email')].opened| opened",
  "emailConversions": "$.get_campaign.channels[?(@.name==='email')].converted",
  "emailRevenue": "$.get_campaign.channels[?(@.name==='email')].revenue",
  "emailROI": "$.get_campaign.channels[?(@.name==='email')].revenue",
  "topPerformer": "$.get_campaign.channels[?(@.revenue===@max(@..revenue))].name",
  "highROIChannels": "$.get_campaign.channels[?(@.revenue>@.cost*5)]",
  "totalConversions": "$.get_campaign.channels[*].converted",
  "totalRevenue": "$.get_campaign.channels[*].revenue",
  "totalSpend": "$.get_campaign.channels[*].cost",
  "bestConvertingPage": "$.get_campaign.topPages[?(@.conversionRate===@max(@..conversionRate))].url",
  "highTrafficPages": "$.get_campaign.topPages[?(@.visits>=30000)]",
  "demoPageStats": "$.get_campaign.topPages[?(@.url==='/demo')]"
}

Result

{
  "campaignName": "Campaign: Q4 Product Launch (CAMP-Q4-2025)",
  "campaignPeriod": "2025-10-01 to 2025-12-31",
  "totalBudget": "Budget: $50000",
  "channelNames": ["email", "social", "paid_search"],
  "emailPerformance": "Emails: 25000 sent, 9800 opened",
  "emailConversions": [245],
  "emailRevenue": [122500],
  "emailROI": [122500],
  "topPerformer": ["paid_search"],
  "highROIChannels": [
    {
      "name": "email",
      "sent": 25000,
      "delivered": 24500,
      "opened": 9800,
      "clicked": 2450,
      "converted": 245,
      "revenue": 122500,
      "cost": 5000
    },
    {
      "name": "paid_search",
      "impressions": 750000,
      "clicks": 22500,
      "converted": 675,
      "revenue": 337500,
      "cost": 18000
    }
  ],
  "totalConversions": [245, 150, 675],
  "totalRevenue": [122500, 75000, 337500],
  "totalSpend": [5000, 12000, 18000],
  "bestConvertingPage": ["/demo"],
  "highTrafficPages": [
    {"url": "/product", "visits": 45000, "conversionRate": 0.025},
    {"url": "/pricing", "visits": 32000, "conversionRate": 0.045}
  ],
  "demoPageStats": [
    {"url": "/demo", "visits": 18000, "conversionRate": 0.085}
  ]
}

Performance Analysis: Use filters to identify top-performing channels (revenue===@max), high-ROI channels (revenue>cost*5), and best converting pages.

Healthcare Patient Management

Scenario: Patient Appointment Coordination

Coordinate patient appointments across multiple departments and providers.

Source Data
Mapping Configuration
Result

{
  "get_patient": {
    "patientId": "PAT-9876",
    "firstName": "Emma",
    "lastName": "Wilson",
    "dob": "1985-03-15",
    "mrn": "MRN-123456",
    "insurance": {
      "provider": "HealthCare Plus",
      "policyNumber": "HCP-9876543",
      "groupNumber": "GRP-001",
      "status": "active"
    },
    "primaryCare": {
      "provider": "Dr. James Chen",
      "providerId": "PROV-456",
      "department": "Internal Medicine"
    },
    "conditions": [
      {"name": "Hypertension", "status": "controlled"},
      {"name": "Type 2 Diabetes", "status": "managed"}
    ],
    "allergies": ["Penicillin", "Latex"],
    "medications": [
      {"name": "Lisinopril", "dosage": "10mg", "frequency": "daily"},
      {"name": "Metformin", "dosage": "500mg", "frequency": "twice daily"}
    ]
  },
  "get_appointments": {
    "upcoming": [
      {
        "appointmentId": "APT-001",
        "date": "2025-10-15",
        "time": "09:00",
        "provider": "Dr. James Chen",
        "department": "Internal Medicine",
        "type": "follow-up",
        "status": "confirmed"
      },
      {
        "appointmentId": "APT-002",
        "date": "2025-10-22",
        "time": "14:30",
        "provider": "Dr. Sarah Martinez",
        "department": "Endocrinology",
        "type": "consultation",
        "status": "pending"
      },
      {
        "appointmentId": "APT-003",
        "date": "2025-11-05",
        "time": "10:00",
        "provider": "Lab Services",
        "department": "Laboratory",
        "type": "lab_work",
        "status": "scheduled"
      }
    ],
    "past": [
      {
        "appointmentId": "APT-000",
        "date": "2025-09-20",
        "provider": "Dr. James Chen",
        "notes": "Blood pressure stable, continue current medications"
      }
    ]
  }
}

{
  "patientName": "$.get_patient.firstName| |$.get_patient.lastName",
  "patientDOB": "DOB: |$.get_patient.dob| (MRN: |$.get_patient.mrn|)",
  "insuranceInfo": "$.get_patient.insurance.provider| - Policy #|$.get_patient.insurance.policyNumber",
  "insuranceStatus": "Coverage: |$.get_patient.insurance.status",
  "primaryPhysician": "Primary: |$.get_patient.primaryCare.provider| (|$.get_patient.primaryCare.department|)",
  "activeConditions": "$.get_patient.conditions[?(@.status!=='resolved')]",
  "allergiesAlert": "⚠️ ALLERGIES: |$.get_patient.allergies[*]",
  "currentMedications": "$.get_patient.medications[*].name",
  "medicationDetails": "$.get_patient.medications[*].name| |$.get_patient.medications[*].dosage| |$.get_patient.medications[*].frequency",
  "nextAppointment": "$.get_appointments.upcoming[0].date| at |$.get_appointments.upcoming[0].time| with |$.get_appointments.upcoming[0].provider",
  "confirmedAppointments": "$.get_appointments.upcoming[?(@.status==='confirmed')]",
  "pendingAppointments": "$.get_appointments.upcoming[?(@.status==='pending')]",
  "upcomingLabWork": "$.get_appointments.upcoming[?(@.type==='lab_work')]",
  "appointmentCount": "$.get_appointments.upcoming.length",
  "nextFollowUp": "$.get_appointments.upcoming[?(@.type==='follow-up')][0]",
  "specialistVisits": "$.get_appointments.upcoming[?(@.department!=='Internal Medicine' && @.department!=='Laboratory')]"
}

{
  "patientName": "Emma Wilson",
  "patientDOB": "DOB: 1985-03-15 (MRN: MRN-123456)",
  "insuranceInfo": "HealthCare Plus - Policy #HCP-9876543",
  "insuranceStatus": "Coverage: active",
  "primaryPhysician": "Primary: Dr. James Chen (Internal Medicine)",
  "activeConditions": [
    {"name": "Hypertension", "status": "controlled"},
    {"name": "Type 2 Diabetes", "status": "managed"}
  ],
  "allergiesAlert": "⚠️ ALLERGIES: Penicillin,Latex",
  "currentMedications": ["Lisinopril", "Metformin"],
  "medicationDetails": "Lisinopril 10mg daily,Metformin 500mg twice daily",
  "nextAppointment": "2025-10-15 at 09:00 with Dr. James Chen",
  "confirmedAppointments": [
    {
      "appointmentId": "APT-001",
      "date": "2025-10-15",
      "time": "09:00",
      "provider": "Dr. James Chen",
      "department": "Internal Medicine",
      "type": "follow-up",
      "status": "confirmed"
    }
  ],
  "pendingAppointments": [
    {
      "appointmentId": "APT-002",
      "date": "2025-10-22",
      "time": "14:30",
      "provider": "Dr. Sarah Martinez",
      "department": "Endocrinology",
      "type": "consultation",
      "status": "pending"
    }
  ],
  "upcomingLabWork": [
    {
      "appointmentId": "APT-003",
      "date": "2025-11-05",
      "time": "10:00",
      "provider": "Lab Services",
      "department": "Laboratory",
      "type": "lab_work",
      "status": "scheduled"
    }
  ],
  "appointmentCount": 3,
  "nextFollowUp": {
    "appointmentId": "APT-001",
    "date": "2025-10-15",
    "time": "09:00",
    "provider": "Dr. James Chen",
    "department": "Internal Medicine",
    "type": "follow-up",
    "status": "confirmed"
  },
  "specialistVisits": [
    {
      "appointmentId": "APT-002",
      "date": "2025-10-22",
      "time": "14:30",
      "provider": "Dr. Sarah Martinez",
      "department": "Endocrinology",
      "type": "consultation",
      "status": "pending"
    }
  ]
}

HIPAA Compliance: When working with healthcare data, ensure all JSON path mappings comply with privacy regulations. Never log or expose PHI in non-compliant systems.

Financial Transaction Processing

Scenario: Payment Reconciliation

Match payments across multiple payment processors and accounts.

{
  "get_transactions": {
    "accountId": "ACC-2025-456",
    "period": "2025-10",
    "transactions": [
      {
        "id": "TXN-001",
        "date": "2025-10-08",
        "type": "payment_received",
        "amount": 1299.00,
        "currency": "USD",
        "method": "credit_card",
        "processor": "Stripe",
        "processorId": "ch_3Abc123",
        "customer": "CUST-789",
        "status": "completed",
        "fees": 39.57
      },
      {
        "id": "TXN-002",
        "date": "2025-10-08",
        "type": "refund_issued",
        "amount": -99.00,
        "currency": "USD",
        "method": "credit_card",
        "processor": "Stripe",
        "processorId": "re_3Def456",
        "customer": "CUST-456",
        "status": "completed",
        "fees": -2.97
      },
      {
        "id": "TXN-003",
        "date": "2025-10-07",
        "type": "payment_received",
        "amount": 4999.00,
        "currency": "USD",
        "method": "wire_transfer",
        "processor": "Bank",
        "processorId": "WIRE-789",
        "customer": "CUST-123",
        "status": "pending",
        "fees": 25.00
      },
      {
        "id": "TXN-004",
        "date": "2025-10-07",
        "type": "payment_received",
        "amount": 299.00,
        "currency": "USD",
        "method": "paypal",
        "processor": "PayPal",
        "processorId": "PAY-456789",
        "customer": "CUST-321",
        "status": "completed",
        "fees": 8.97
      },
      {
        "id": "TXN-005",
        "date": "2025-10-06",
        "type": "chargeback",
        "amount": -1299.00,
        "currency": "USD",
        "method": "credit_card",
        "processor": "Stripe",
        "processorId": "cb_3Ghi789",
        "customer": "CUST-555",
        "status": "under_review",
        "fees": 15.00
      }
    ]
  }
}

Reconciliation Tips: Use filters to separate transaction types, identify pending items, flag disputes, and calculate totals by processor for financial reporting.

Next Steps

Reference Guide

Complete syntax tables and troubleshooting

Advanced Techniques

Performance optimization and best practices

Filters & Expressions

Review filtering techniques

Basic Syntax

Return to fundamentals

Practice Makes Perfect: Try recreating these examples in your own flows. Start with simple mappings and gradually add filters and advanced patterns.

Get Started

Flows

Agents

Account Management

Advanced

E-commerce Order Processing

Scenario: Process New Order

User Management & Authorization

Scenario: User Profile Enrichment

CRM & Sales Pipeline

Scenario: Lead Scoring & Qualification

Inventory Management

Scenario: Stock Level Monitoring

Customer Support Ticket Routing

Scenario: Intelligent Ticket Assignment

Marketing Campaign Analysis

Scenario: Multi-Channel Campaign Performance

Healthcare Patient Management

Scenario: Patient Appointment Coordination

Financial Transaction Processing

Scenario: Payment Reconciliation

Next Steps

Reference Guide

Advanced Techniques

Filters & Expressions

Basic Syntax

Get Started

Flows

Agents

Account Management

Advanced

​E-commerce Order Processing

​Scenario: Process New Order

​User Management & Authorization

​Scenario: User Profile Enrichment

​CRM & Sales Pipeline

​Scenario: Lead Scoring & Qualification

​Inventory Management

​Scenario: Stock Level Monitoring

​Customer Support Ticket Routing

​Scenario: Intelligent Ticket Assignment

​Marketing Campaign Analysis

​Scenario: Multi-Channel Campaign Performance

​Healthcare Patient Management

​Scenario: Patient Appointment Coordination

​Financial Transaction Processing

​Scenario: Payment Reconciliation

​Next Steps

Reference Guide

Advanced Techniques

Filters & Expressions

Basic Syntax

E-commerce Order Processing

Scenario: Process New Order

User Management & Authorization

Scenario: User Profile Enrichment

CRM & Sales Pipeline

Scenario: Lead Scoring & Qualification

Inventory Management

Scenario: Stock Level Monitoring

Customer Support Ticket Routing

Scenario: Intelligent Ticket Assignment

Marketing Campaign Analysis

Scenario: Multi-Channel Campaign Performance

Healthcare Patient Management

Scenario: Patient Appointment Coordination

Financial Transaction Processing

Scenario: Payment Reconciliation

Next Steps