anil.recoil.org / slop
My agentic slop goes here. Not intended for anyone else!
fork atom
slop / jmap / docs / queries / 10-comprehensive-multi-method.md
at 2e57b99c7facfca67595741b51d79f40df77fa2b 12 kB view raw view code

Query 10: Comprehensive Multi-Method Email Dashboard#

Use Case Description#

A comprehensive dashboard query that combines multiple JMAP methods to provide a complete email management overview: recent activity, mailbox statistics, thread summaries, and system status. This demonstrates advanced JMAP usage with complex result reference chains.

Key JMAP Concepts Used#

  • Complex result reference chains: Multiple levels of method dependencies
  • Batch operations: Efficient multi-method requests
  • Mailbox statistics: Using server-computed counts and states
  • Thread aggregation: Grouping emails by conversation
  • System state monitoring: Tracking account-wide changes
  • Advanced filtering: Multiple simultaneous filter conditions

JMAP Request#

{
  "using": ["urn:ietf:params:jmap:core", "urn:ietf:params:jmap:mail"],
  "methodCalls": [
    [
      "Mailbox/get",
      {
        "accountId": "u12345678",
        "ids": null,
        "properties": [
          "id", "name", "role", "totalEmails", "unreadEmails", 
          "totalThreads", "unreadThreads", "parentId", "sortOrder"
        ]
      },
      "mb0"
    ],
    [
      "Email/query",
      {
        "accountId": "u12345678",
        "filter": {
          "operator": "AND",
          "conditions": [
            {
              "hasKeyword": "$seen",
              "value": false
            },
            {
              "after": "2024-08-20T00:00:00Z"
            }
          ]
        },
        "sort": [{"property": "receivedAt", "isAscending": false}],
        "limit": 10
      },
      "eq0"
    ],
    [
      "Email/query", 
      {
        "accountId": "u12345678",
        "filter": {
          "operator": "AND",
          "conditions": [
            {
              "hasKeyword": "$flagged"
            },
            {
              "hasKeyword": "$seen",
              "value": false
            }
          ]
        },
        "sort": [{"property": "receivedAt", "isAscending": true}],
        "limit": 5
      },
      "eq1"
    ],
    [
      "Thread/get",
      {
        "accountId": "u12345678",
        "#ids": {
          "resultOf": "eq0",
          "name": "Email/query",
          "path": "/ids/*/threadId"
        }
      },
      "th0"
    ],
    [
      "Email/get",
      {
        "accountId": "u12345678",
        "#ids": {
          "resultOf": "eq0", 
          "name": "Email/query",
          "path": "/ids"
        },
        "properties": [
          "id", "threadId", "mailboxIds", "keywords", "from", "to", "subject",
          "receivedAt", "hasAttachment", "preview", "size"
        ]
      },
      "eg0"
    ],
    [
      "Email/get",
      {
        "accountId": "u12345678",
        "#ids": {
          "resultOf": "eq1",
          "name": "Email/query", 
          "path": "/ids"
        },
        "properties": [
          "id", "threadId", "mailboxIds", "keywords", "from", "subject",
          "receivedAt", "preview", "size"
        ]
      },
      "eg1"
    ],
    [
      "EmailSubmission/query",
      {
        "accountId": "u12345678",
        "filter": {
          "after": "2024-08-23T00:00:00Z"
        },
        "sort": [{"property": "created", "isAscending": false}],
        "limit": 5
      },
      "sub0"
    ],
    [
      "VacationResponse/get",
      {
        "accountId": "u12345678", 
        "ids": ["singleton"]
      },
      "vr0"
    ],
    [
      "Identity/get",
      {
        "accountId": "u12345678",
        "ids": null,
        "properties": ["id", "name", "email", "mayDelete"]
      },
      "id0"
    ]
  ]
}

Expected Response Structure (Abbreviated)#

{
  "methodResponses": [
    [
      "Mailbox/get",
      {
        "accountId": "u12345678",
        "state": "mb9876543219",
        "list": [
          {
            "id": "Minbox",
            "name": "Inbox", 
            "role": "inbox",
            "totalEmails": 1247,
            "unreadEmails": 23,
            "totalThreads": 892,
            "unreadThreads": 18,
            "parentId": null,
            "sortOrder": 0
          },
          {
            "id": "Msent",
            "name": "Sent",
            "role": "sent",
            "totalEmails": 543,
            "unreadEmails": 0,
            "totalThreads": 421,
            "unreadThreads": 0, 
            "parentId": null,
            "sortOrder": 1
          },
          {
            "id": "Mdrafts",
            "name": "Drafts",
            "role": "drafts",
            "totalEmails": 7,
            "unreadEmails": 0,
            "totalThreads": 7,
            "unreadThreads": 0,
            "parentId": null,
            "sortOrder": 2
          },
          {
            "id": "Mvip",
            "name": "VIP",
            "role": null,
            "totalEmails": 34,
            "unreadEmails": 3,
            "totalThreads": 28,
            "unreadThreads": 3,
            "parentId": null,
            "sortOrder": 10
          }
        ],
        "notFound": []
      },
      "mb0"
    ],
    [
      "Email/query",
      {
        "accountId": "u12345678",
        "queryState": "q1234567900",
        "position": 0,
        "ids": ["Memail701", "Memail702", "Memail703"],
        "total": 23,
        "limit": 10
      },
      "eq0"  
    ],
    [
      "Email/query",
      {
        "accountId": "u12345678",
        "queryState": "q1234567901", 
        "position": 0,
        "ids": ["Memail801", "Memail802"],
        "total": 2,
        "limit": 5
      },
      "eq1"
    ],
    [
      "Thread/get",
      {
        "accountId": "u12345678",
        "state": "th9876543220",
        "list": [
          {
            "id": "Tthread701",
            "emailIds": ["Memail701", "Memail704", "Memail705"]
          },
          {
            "id": "Tthread702", 
            "emailIds": ["Memail702"]
          },
          {
            "id": "Tthread703",
            "emailIds": ["Memail703", "Memail706"]
          }
        ],
        "notFound": []
      },
      "th0"
    ],
    [
      "Email/get",
      {
        "accountId": "u12345678",
        "state": "s9876543220",
        "list": [
          {
            "id": "Memail701",
            "threadId": "Tthread701",
            "mailboxIds": {"Minbox": true, "Mvip": true},
            "keywords": {"$flagged": true},
            "from": [{"email": "ceo@company.com", "name": "Jane CEO"}],
            "to": [{"email": "me@example.com", "name": "John Doe"}],
            "subject": "Q4 Strategic Review - Urgent Response Needed",
            "receivedAt": "2024-08-24T09:15:00Z",
            "hasAttachment": true,
            "preview": "John, we need to finalize the Q4 strategic plan by end of week...",
            "size": 4567
          }
        ],
        "notFound": []
      },
      "eg0"
    ],
    [
      "EmailSubmission/query",
      {
        "accountId": "u12345678",
        "queryState": "sq1234567900",
        "position": 0,
        "ids": ["ES401", "ES402", "ES403"],
        "total": 12,
        "limit": 5
      },
      "sub0"
    ],
    [
      "VacationResponse/get",
      {
        "accountId": "u12345678",
        "state": "vr9876543220",
        "list": [
          {
            "id": "singleton",
            "isEnabled": false,
            "fromDate": null,
            "toDate": null,
            "subject": null,
            "textBody": null,
            "htmlBody": null
          }
        ],
        "notFound": []
      },
      "vr0"
    ],
    [
      "Identity/get", 
      {
        "accountId": "u12345678",
        "state": "id9876543220",
        "list": [
          {
            "id": "I1",
            "name": "John Doe",
            "email": "john.doe@company.com",
            "mayDelete": false
          },
          {
            "id": "I2", 
            "name": "John D.",
            "email": "j.doe@personal.com",
            "mayDelete": true
          }
        ],
        "notFound": []
      },
      "id0"
    ]
  ]
}

Explanation of Key Features#

Dashboard Components Overview#

This comprehensive query provides a complete email management dashboard with:

  1. Mailbox Statistics - Server-computed counts and folder organization
  2. Recent Activity - Latest unread emails with full context
  3. Priority Items - Flagged unread emails requiring attention
  4. Thread Context - Conversation information for recent emails
  5. Outgoing Activity - Recent email submissions and delivery status
  6. System Status - Vacation response and identity configuration

Advanced Result Reference Patterns#

Multi-Level References:

{
  "#ids": {
    "resultOf": "eq0",
    "name": "Email/query", 
    "path": "/ids/*/threadId"
  }
}
  • Extracts thread IDs from all emails in first query
  • */threadId path syntax gets threadId from each email object
  • Enables batch Thread/get for conversation context

Parallel Processing:

  • Multiple Email/query operations run simultaneously
  • Independent Email/get calls for different result sets
  • System configuration calls (VacationResponse, Identity) run in parallel
  • Efficient batch processing reduces total request time

Dashboard Data Analysis#

Mailbox Health Metrics:

{
  "inbox": {"totalEmails": 1247, "unreadEmails": 23, "unreadThreads": 18},
  "vip": {"totalEmails": 34, "unreadEmails": 3, "unreadThreads": 3}
}

Key Performance Indicators:

  • Inbox Health: 23 unread out of 1,247 total (1.8% unread rate)
  • Thread Efficiency: 18 unread threads vs 23 unread emails (some multi-email threads)
  • VIP Attention: 3 unread VIP emails requiring priority attention
  • Draft Management: 7 draft emails needing completion

Dashboard Business Logic#

Priority Calculation:

  1. Urgent: Flagged + unread emails (immediate attention)
  2. Important: VIP folder unread emails (high priority)
  3. Recent: New emails from last few days (regular processing)
  4. Backlog: Older unread emails (cleanup candidates)

Workflow Optimization:

  • Process flagged emails first (most urgent)
  • Handle VIP folder communications next (relationship management)
  • Review recent inbox activity (daily workflow)
  • Schedule time for draft completion (pending communications)

Advanced Dashboard Queries#

Time-Based Activity Analysis:

{
  "filter": {
    "operator": "AND",
    "conditions": [
      {"after": "2024-08-24T00:00:00Z"},
      {"before": "2024-08-25T00:00:00Z"}
    ]
  }
}

Cross-Mailbox Priority Items:

{
  "filter": {
    "operator": "OR", 
    "conditions": [
      {"inMailbox": "Mvip"},
      {"hasKeyword": "$flagged"},
      {"hasKeyword": "urgent"}
    ]
  }
}

Thread Activity Monitoring:

{
  "filter": {
    "operator": "AND",
    "conditions": [
      {"hasKeyword": "$answered", "value": false},
      {"after": "2024-08-20T00:00:00Z"},
      {"from": "*@important-client.com"}
    ]
  }
}

Performance Optimization Strategies#

Batch Operation Benefits:

  • Single HTTP request for all dashboard data
  • Parallel server processing of independent queries
  • Reduced network latency and connection overhead
  • Atomic consistency across all dashboard components

Selective Property Loading:

  • Minimal property sets for overview data
  • Full properties only where needed for display
  • Efficient bandwidth usage for mobile clients
  • Faster response times for dashboard updates

Smart Caching Strategy:

  • Mailbox statistics change infrequently (cache longer)
  • Recent email queries change frequently (shorter cache)
  • System configuration rarely changes (long cache periods)
  • Thread information is relatively stable (moderate caching)

Dashboard Integration Patterns#

Real-Time Updates:

  • Use queryState values for change detection
  • Implement push notifications for high-priority items
  • Periodic dashboard refresh for activity monitoring
  • Delta updates for changed data only

Mobile Optimization:

  • Smaller result sets for bandwidth constraints
  • Progressive loading of secondary information
  • Offline caching of critical dashboard data
  • Touch-optimized priority item handling

Business Intelligence Integration:

  • Export dashboard metrics for trend analysis
  • Integration with productivity tracking systems
  • Communication pattern analysis for optimization
  • Performance metrics for email management efficiency