Excel-style formulas for business data

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"#1042"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"Austin"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"Ceramic mug"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"CAP-01"

{
  "company": "Acme Outdoor",
  "departments": [
    {
      "name": "Sales",
      "cost-center": "CC-200",
      "employees": [
        {
          "id": "E-101",
          "name": "james miller",
          "title": "Account Executive",
          "salary": 92000,
          "started": "2021-04-12",
          "state": "CA",
          "skills": [
            "negotiation",
            "hubspot"
          ],
          "quota": {
            "2025": 480000,
            "2026": 560000
          }
        },
        {
          "id": "E-102",
          "name": "emily davis",
          "title": "Sales Manager",
          "salary": 128000,
          "started": "2018-09-03",
          "state": "TX",
          "skills": [
            "forecasting",
            "salesforce"
          ],
          "bonus": 15000
        }
      ]
    },
    {
      "name": "Operations",
      "cost-center": "CC-300",
      "employees": [
        {
          "id": "E-201",
          "name": "michael brown",
          "title": "Ops Analyst",
          "salary": 78000,
          "started": "2024-01-08",
          "state": "TX",
          "skills": [
            "sql",
            "excel"
          ]
        },
        {
          "id": "E-202",
          "name": "sarah wilson",
          "title": "Director of Operations",
          "salary": 165000,
          "started": "2016-02-29",
          "state": "NY",
          "skills": [
            "netsuite",
            "sql",
            "lean"
          ],
          "terminated_at": null
        }
      ]
    }
  ]
}

"CC-200"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

null

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

{
  "orderId": "#1042",
  "email": "olivia.hart@example.com",
  "city": "Austin",
  "items": 3,
  "paid": false
}

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

{
  "customer": {
    "name": "Olivia Hart",
    "zip": "78701"
  },
  "total": 105
}

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"{\"sku\":\"MUG-11\",\"qty\":2}"

{
  "payload": "{\"event\":\"refund\",\"amount\":19.99,\"order\":\"#1042\"}"
}

19.99

{
  "company": "Acme Outdoor",
  "departments": [
    {
      "name": "Sales",
      "cost-center": "CC-200",
      "employees": [
        {
          "id": "E-101",
          "name": "james miller",
          "title": "Account Executive",
          "salary": 92000,
          "started": "2021-04-12",
          "state": "CA",
          "skills": [
            "negotiation",
            "hubspot"
          ],
          "quota": {
            "2025": 480000,
            "2026": 560000
          }
        },
        {
          "id": "E-102",
          "name": "emily davis",
          "title": "Sales Manager",
          "salary": 128000,
          "started": "2018-09-03",
          "state": "TX",
          "skills": [
            "forecasting",
            "salesforce"
          ],
          "bonus": 15000
        }
      ]
    },
    {
      "name": "Operations",
      "cost-center": "CC-300",
      "employees": [
        {
          "id": "E-201",
          "name": "michael brown",
          "title": "Ops Analyst",
          "salary": 78000,
          "started": "2024-01-08",
          "state": "TX",
          "skills": [
            "sql",
            "excel"
          ]
        },
        {
          "id": "E-202",
          "name": "sarah wilson",
          "title": "Director of Operations",
          "salary": 165000,
          "started": "2016-02-29",
          "state": "NY",
          "skills": [
            "netsuite",
            "sql",
            "lean"
          ],
          "terminated_at": null
        }
      ]
    }
  ]
}

[
  "2025: $480,000",
  "2026: $560,000"
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"list of 3"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  "MUG-11",
  "TEE-M",
  "CAP-01"
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  {
    "sku": "MUG-11",
    "lineTotal": 29
  },
  {
    "sku": "TEE-M",
    "lineTotal": 22
  },
  {
    "sku": "CAP-01",
    "lineTotal": 54
  }
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  "KITCHEN",
  "GIFT"
]

{
  "company": "Acme Outdoor",
  "departments": [
    {
      "name": "Sales",
      "cost-center": "CC-200",
      "employees": [
        {
          "id": "E-101",
          "name": "james miller",
          "title": "Account Executive",
          "salary": 92000,
          "started": "2021-04-12",
          "state": "CA",
          "skills": [
            "negotiation",
            "hubspot"
          ],
          "quota": {
            "2025": 480000,
            "2026": 560000
          }
        },
        {
          "id": "E-102",
          "name": "emily davis",
          "title": "Sales Manager",
          "salary": 128000,
          "started": "2018-09-03",
          "state": "TX",
          "skills": [
            "forecasting",
            "salesforce"
          ],
          "bonus": 15000
        }
      ]
    },
    {
      "name": "Operations",
      "cost-center": "CC-300",
      "employees": [
        {
          "id": "E-201",
          "name": "michael brown",
          "title": "Ops Analyst",
          "salary": 78000,
          "started": "2024-01-08",
          "state": "TX",
          "skills": [
            "sql",
            "excel"
          ]
        },
        {
          "id": "E-202",
          "name": "sarah wilson",
          "title": "Director of Operations",
          "salary": 165000,
          "started": "2016-02-29",
          "state": "NY",
          "skills": [
            "netsuite",
            "sql",
            "lean"
          ],
          "terminated_at": null
        }
      ]
    }
  ]
}

[
  "Sales: James Miller",
  "Sales: Emily Davis",
  "Operations: Michael Brown",
  "Operations: Sarah Wilson"
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  {
    "order": "#1042",
    "sku": "MUG-11",
    "qty": 2
  },
  {
    "order": "#1042",
    "sku": "TEE-M",
    "qty": 1
  },
  {
    "order": "#1042",
    "sku": "CAP-01",
    "qty": 3
  }
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  "MUG-11/kitchen",
  "MUG-11/gift",
  "TEE-M/apparel",
  "CAP-01/apparel",
  "CAP-01/gift"
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  "1. Ceramic mug",
  "2. Logo tee",
  "3. Canvas cap"
]

{
  "company": "Acme Outdoor",
  "departments": [
    {
      "name": "Sales",
      "cost-center": "CC-200",
      "employees": [
        {
          "id": "E-101",
          "name": "james miller",
          "title": "Account Executive",
          "salary": 92000,
          "started": "2021-04-12",
          "state": "CA",
          "skills": [
            "negotiation",
            "hubspot"
          ],
          "quota": {
            "2025": 480000,
            "2026": 560000
          }
        },
        {
          "id": "E-102",
          "name": "emily davis",
          "title": "Sales Manager",
          "salary": 128000,
          "started": "2018-09-03",
          "state": "TX",
          "skills": [
            "forecasting",
            "salesforce"
          ],
          "bonus": 15000
        }
      ]
    },
    {
      "name": "Operations",
      "cost-center": "CC-300",
      "employees": [
        {
          "id": "E-201",
          "name": "michael brown",
          "title": "Ops Analyst",
          "salary": 78000,
          "started": "2024-01-08",
          "state": "TX",
          "skills": [
            "sql",
            "excel"
          ]
        },
        {
          "id": "E-202",
          "name": "sarah wilson",
          "title": "Director of Operations",
          "salary": 165000,
          "started": "2016-02-29",
          "state": "NY",
          "skills": [
            "netsuite",
            "sql",
            "lean"
          ],
          "terminated_at": null
        }
      ]
    }
  ]
}

[
  "E-101",
  "E-102",
  "E-201",
  "E-202"
]

{
  "total": 230,
  "pageSize": 100
}

[
  1,
  2,
  3
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

{
  "subtotal": 105,
  "total": 107.95
}

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "INV-2041",
  "INV-2042",
  "INV-2043",
  "INV-2045"
]

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "INV-2041",
  "INV-2043",
  "INV-2045"
]

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "INV-2041 (25 days)",
  "INV-2043 (45 days)",
  "INV-2045 (13 days)"
]

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "Brightpaws Pet Supply",
  "Harbor Freight Ops",
  "Lakeside Dental"
]

{
  "id": 5521,
  "subject": "Order #1042 arrived damaged - need refund",
  "body": "Hi, my order #1042 came with a broken mug. Can I get a refund? Thanks, Olivia",
  "priority": null,
  "customer_tier": "gold",
  "channel": "email",
  "created": "2026-09-14T09:12:00Z"
}

true

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

true

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "ap@brightpaws.com",
  "billing@northpeakcpa.com",
  "office@lakesidedental.com",
  "billing@northpeakcpa.com"
]

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

4

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

"INV-2042"

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "Harbor Freight Ops $3,920.50",
  "Brightpaws Pet Supply $1,250.00"
]

{
  "device": "PUMP-07",
  "readings": [
    {
      "ts": "2026-09-14T08:00:00Z",
      "temp_c": 61.2,
      "psi": 88
    },
    {
      "ts": "2026-09-14T08:05:00Z",
      "temp_c": 64.8,
      "psi": 91
    },
    {
      "ts": "2026-09-14T08:10:00Z",
      "temp_c": 79.5,
      "psi": 97
    }
  ]
}

[
  64.8,
  79.5
]

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "West",
  "East",
  "Central"
]

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

true

{
  "id": 5521,
  "subject": "Order #1042 arrived damaged - need refund",
  "body": "Hi, my order #1042 came with a broken mug. Can I get a refund? Thanks, Olivia",
  "priority": null,
  "customer_tier": "gold",
  "channel": "email",
  "created": "2026-09-14T09:12:00Z"
}

"priority-queue"

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "INV-2041 -> ar-team",
  "INV-2042 -> auto-reminder",
  "INV-2043 -> finance-lead",
  "INV-2044 -> archive",
  "INV-2045 -> ar-team"
]

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "#ar-west",
  "#ar-east",
  "#ar-west",
  "#ar-central",
  "#ar-east"
]

{
  "id": 5521,
  "subject": "Order #1042 arrived damaged - need refund",
  "body": "Hi, my order #1042 came with a broken mug. Can I get a refund? Thanks, Olivia",
  "priority": null,
  "customer_tier": "gold",
  "channel": "email",
  "created": "2026-09-14T09:12:00Z"
}

"billing"

{
  "ref": "PO-77810"
}

"purchasing"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"auto-approve"

{
  "device": "PUMP-07",
  "readings": [
    {
      "ts": "2026-09-14T08:00:00Z",
      "temp_c": 61.2,
      "psi": 88
    },
    {
      "ts": "2026-09-14T08:05:00Z",
      "temp_c": 64.8,
      "psi": 91
    },
    {
      "ts": "2026-09-14T08:10:00Z",
      "temp_c": 79.5,
      "psi": 97
    }
  ]
}

"page-on-call"

{
  "received": "2026-09-14T22:40:00Z"
}

"after-hours-queue"

{
  "date": "2026-09-13"
}

"weekend"

{
  "state": "TX",
  "subtotal": 98.0,
  "rates": [
    {
      "state": "CA",
      "rate": 0.0725
    },
    {
      "state": "NY",
      "rate": 0.04
    },
    {
      "state": "TX",
      "rate": 0.0625
    }
  ],
  "reps": [
    {
      "region": "West",
      "rep": "James Miller",
      "slack": "@james"
    },
    {
      "region": "East",
      "rep": "Emily Davis",
      "slack": "@emily"
    },
    {
      "region": "Central",
      "rep": "Michael Brown",
      "slack": "@michael"
    }
  ],
  "lead": {
    "company": "Lakeside Dental",
    "state": "TX",
    "employees": 42,
    "source": "typeform",
    "region": "Central"
  }
}

"Michael Brown"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"Hold"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"No note"

{
  "company": "Acme Outdoor",
  "departments": [
    {
      "name": "Sales",
      "cost-center": "CC-200",
      "employees": [
        {
          "id": "E-101",
          "name": "james miller",
          "title": "Account Executive",
          "salary": 92000,
          "started": "2021-04-12",
          "state": "CA",
          "skills": [
            "negotiation",
            "hubspot"
          ],
          "quota": {
            "2025": 480000,
            "2026": 560000
          }
        },
        {
          "id": "E-102",
          "name": "emily davis",
          "title": "Sales Manager",
          "salary": 128000,
          "started": "2018-09-03",
          "state": "TX",
          "skills": [
            "forecasting",
            "salesforce"
          ],
          "bonus": 15000
        }
      ]
    },
    {
      "name": "Operations",
      "cost-center": "CC-300",
      "employees": [
        {
          "id": "E-201",
          "name": "michael brown",
          "title": "Ops Analyst",
          "salary": 78000,
          "started": "2024-01-08",
          "state": "TX",
          "skills": [
            "sql",
            "excel"
          ]
        },
        {
          "id": "E-202",
          "name": "sarah wilson",
          "title": "Director of Operations",
          "salary": 165000,
          "started": "2016-02-29",
          "state": "NY",
          "skills": [
            "netsuite",
            "sql",
            "lean"
          ],
          "terminated_at": null
        }
      ]
    }
  ]
}

"false / true"

{
  "company": "Acme Outdoor",
  "departments": [
    {
      "name": "Sales",
      "cost-center": "CC-200",
      "employees": [
        {
          "id": "E-101",
          "name": "james miller",
          "title": "Account Executive",
          "salary": 92000,
          "started": "2021-04-12",
          "state": "CA",
          "skills": [
            "negotiation",
            "hubspot"
          ],
          "quota": {
            "2025": 480000,
            "2026": 560000
          }
        },
        {
          "id": "E-102",
          "name": "emily davis",
          "title": "Sales Manager",
          "salary": 128000,
          "started": "2018-09-03",
          "state": "TX",
          "skills": [
            "forecasting",
            "salesforce"
          ],
          "bonus": 15000
        }
      ]
    },
    {
      "name": "Operations",
      "cost-center": "CC-300",
      "employees": [
        {
          "id": "E-201",
          "name": "michael brown",
          "title": "Ops Analyst",
          "salary": 78000,
          "started": "2024-01-08",
          "state": "TX",
          "skills": [
            "sql",
            "excel"
          ]
        },
        {
          "id": "E-202",
          "name": "sarah wilson",
          "title": "Director of Operations",
          "salary": 165000,
          "started": "2016-02-29",
          "state": "NY",
          "skills": [
            "netsuite",
            "sql",
            "lean"
          ],
          "terminated_at": null
        }
      ]
    }
  ]
}

15000.0

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

{
  "allInStock": true,
  "anyGift": true
}

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

4

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

3

{
  "qty": "12",
  "code": "A7"
}

{
  "qty": true,
  "code": false
}

{
  "zip": "02134",
  "count": 3
}

{
  "zip": true,
  "count": false
}

{
  "company": "Acme Outdoor",
  "departments": [
    {
      "name": "Sales",
      "cost-center": "CC-200",
      "employees": [
        {
          "id": "E-101",
          "name": "james miller",
          "title": "Account Executive",
          "salary": 92000,
          "started": "2021-04-12",
          "state": "CA",
          "skills": [
            "negotiation",
            "hubspot"
          ],
          "quota": {
            "2025": 480000,
            "2026": 560000
          }
        },
        {
          "id": "E-102",
          "name": "emily davis",
          "title": "Sales Manager",
          "salary": 128000,
          "started": "2018-09-03",
          "state": "TX",
          "skills": [
            "forecasting",
            "salesforce"
          ],
          "bonus": 15000
        }
      ]
    },
    {
      "name": "Operations",
      "cost-center": "CC-300",
      "employees": [
        {
          "id": "E-201",
          "name": "michael brown",
          "title": "Ops Analyst",
          "salary": 78000,
          "started": "2024-01-08",
          "state": "TX",
          "skills": [
            "sql",
            "excel"
          ]
        },
        {
          "id": "E-202",
          "name": "sarah wilson",
          "title": "Director of Operations",
          "salary": 165000,
          "started": "2016-02-29",
          "state": "NY",
          "skills": [
            "netsuite",
            "sql",
            "lean"
          ],
          "terminated_at": null
        }
      ]
    }
  ]
}

[
  "James Miller: band 1",
  "Emily Davis: band 2"
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"Olivia Hart"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"olivia.hart@example.com"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"TX-78701"

{
  "name": "  Acme   Outdoor  "
}

"[Acme   Outdoor]"

{
  "sku": "TEE-M-BLK-2026"
}

{
  "family": "TEE",
  "year": "2026",
  "size": "M"
}

{
  "email": "emily.davis@northpeakcpa.com"
}

"northpeakcpa.com"

{
  "tags": "vip, wholesale , net-30"
}

[
  "vip",
  "wholesale",
  "net-30"
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"MUG-11, TEE-M, CAP-01"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"Order #1042 for Austin"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"415-555-0134"

{
  "card": "4111111111111111"
}

"************1111"

{
  "file": "orders-2026-09-14.CSV"
}

{
  "isOrders": true,
  "isCsv": true
}

{
  "id": 5521,
  "subject": "Order #1042 arrived damaged - need refund",
  "body": "Hi, my order #1042 came with a broken mug. Can I get a refund? Thanks, Olivia",
  "priority": null,
  "customer_tier": "gold",
  "channel": "email",
  "created": "2026-09-14T09:12:00Z"
}

"Hi, my order #1042 came with..."

{
  "id": 5521,
  "subject": "Order #1042 arrived damaged - need refund",
  "body": "Hi, my order #1042 came with a broken mug. Can I get a refund? Thanks, Olivia",
  "priority": null,
  "customer_tier": "gold",
  "channel": "email",
  "created": "2026-09-14T09:12:00Z"
}

16

{
  "sms": "Your order #1042 has shipped and arrives Thursday."
}

"one SMS"

{
  "n": 42
}

"0000042"

(no input: the formula stands alone)

"A€"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

105

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

107.95

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"$107.95"

{
  "amount": 19.98765
}

{
  "round": 19.99,
  "up": 19.99,
  "down": 19.98
}

{
  "state": "TX",
  "subtotal": 98.0,
  "rates": [
    {
      "state": "CA",
      "rate": 0.0725
    },
    {
      "state": "NY",
      "rate": 0.04
    },
    {
      "state": "TX",
      "rate": 0.0625
    }
  ],
  "reps": [
    {
      "region": "West",
      "rep": "James Miller",
      "slack": "@james"
    },
    {
      "region": "East",
      "rep": "Emily Davis",
      "slack": "@emily"
    },
    {
      "region": "Central",
      "rep": "Michael Brown",
      "slack": "@michael"
    }
  ],
  "lead": {
    "company": "Lakeside Dental",
    "state": "TX",
    "employees": 42,
    "source": "typeform",
    "region": "Central"
  }
}

7.11

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

{
  "avg": 1473.1,
  "min": 480.0,
  "max": 3920.5
}

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

5

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "INV-2041 17.0%",
  "INV-2042 6.5%",
  "INV-2043 53.2%",
  "INV-2044 8.3%",
  "INV-2045 14.9%"
]

{
  "total": "1,299.50"
}

2599

{
  "units": 47,
  "perBox": 12
}

{
  "boxes": 3,
  "loose": 11
}

{
  "delta": -42.789
}

{
  "trunc": -42,
  "abs": 42.789,
  "sign": -1
}

{
  "mrr": 12000,
  "growth": 0.08
}

30218

{
  "v": 144
}

{
  "sqrt": 12,
  "log10": 3,
  "ln": 2,
  "pi": 3.1416
}

{
  "amount": 1234.5
}

"1.234,50"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"Sep 14, 2026 3:42 PM"

{
  "d": "09/14/2026"
}

"2026-09-14"

{
  "due": "2026-09-30",
  "today": "2026-09-14"
}

16

{
  "invoiced": "2026-09-14"
}

"2026-10-14"

{
  "run": "2026-09-14"
}

{
  "from": "2026-09-07",
  "to": "2026-09-13"
}

{
  "d": "2026-09-14"
}

{
  "y": 2026,
  "m": 9,
  "day": 14,
  "wd": 2
}

{
  "t": "2026-09-14T15:42:10Z"
}

{
  "h": 15,
  "m": 42,
  "s": 10
}

(no input: the formula stands alone)

"Thursday, December 31"

(no input: the formula stands alone)

"2026-09-14T08:00:00"

(no input: the formula stands alone)

"17:30:00.000"

{
  "t": "2026-09-14T15:42:10Z"
}

"2026-09-14 11:42"

{
  "company": "Acme Outdoor",
  "departments": [
    {
      "name": "Sales",
      "cost-center": "CC-200",
      "employees": [
        {
          "id": "E-101",
          "name": "james miller",
          "title": "Account Executive",
          "salary": 92000,
          "started": "2021-04-12",
          "state": "CA",
          "skills": [
            "negotiation",
            "hubspot"
          ],
          "quota": {
            "2025": 480000,
            "2026": 560000
          }
        },
        {
          "id": "E-102",
          "name": "emily davis",
          "title": "Sales Manager",
          "salary": 128000,
          "started": "2018-09-03",
          "state": "TX",
          "skills": [
            "forecasting",
            "salesforce"
          ],
          "bonus": 15000
        }
      ]
    },
    {
      "name": "Operations",
      "cost-center": "CC-300",
      "employees": [
        {
          "id": "E-201",
          "name": "michael brown",
          "title": "Ops Analyst",
          "salary": 78000,
          "started": "2024-01-08",
          "state": "TX",
          "skills": [
            "sql",
            "excel"
          ]
        },
        {
          "id": "E-202",
          "name": "sarah wilson",
          "title": "Director of Operations",
          "salary": 165000,
          "started": "2016-02-29",
          "state": "NY",
          "skills": [
            "netsuite",
            "sql",
            "lean"
          ],
          "terminated_at": null
        }
      ]
    }
  ]
}

[
  "Michael Brown: 2 yrs",
  "Sarah Wilson: 10 yrs"
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"2026-09"

(no input: the formula stands alone)

"2026-10-07"

{
  "body": "(XML text, shown below)"
}

<PurchaseOrder number="PO-77810" date="2026-09-12">
  <Vendor>
    <Name>Summit Paper Co.</Name>
    <Id>V-3301</Id>
  </Vendor>
  <ShipTo>
    <City>Denver</City>
    <State>CO</State>
  </ShipTo>
  <Lines>
    <Line no="1">
      <Sku>PAP-A4</Sku>
      <Qty>40</Qty>
      <UnitPrice>6.25</UnitPrice>
    </Line>
    <Line no="2">
      <Sku>TON-K</Sku>
      <Qty>4</Qty>
      <UnitPrice>89.00</UnitPrice>
    </Line>
    <Line no="3">
      <Sku>ENV-10</Sku>
      <Qty>10</Qty>
      <UnitPrice>12.40</UnitPrice>
    </Line>
  </Lines>
</PurchaseOrder>

"Summit Paper Co."

{
  "body": "(XML text, shown below)"
}

<PurchaseOrder number="PO-77810" date="2026-09-12">
  <Vendor>
    <Name>Summit Paper Co.</Name>
    <Id>V-3301</Id>
  </Vendor>
  <ShipTo>
    <City>Denver</City>
    <State>CO</State>
  </ShipTo>
  <Lines>
    <Line no="1">
      <Sku>PAP-A4</Sku>
      <Qty>40</Qty>
      <UnitPrice>6.25</UnitPrice>
    </Line>
    <Line no="2">
      <Sku>TON-K</Sku>
      <Qty>4</Qty>
      <UnitPrice>89.00</UnitPrice>
    </Line>
    <Line no="3">
      <Sku>ENV-10</Sku>
      <Qty>10</Qty>
      <UnitPrice>12.40</UnitPrice>
    </Line>
  </Lines>
</PurchaseOrder>

"PO-77810"

{
  "body": "(XML text, shown below)"
}

<PurchaseOrder number="PO-77810" date="2026-09-12">
  <Vendor>
    <Name>Summit Paper Co.</Name>
    <Id>V-3301</Id>
  </Vendor>
  <ShipTo>
    <City>Denver</City>
    <State>CO</State>
  </ShipTo>
  <Lines>
    <Line no="1">
      <Sku>PAP-A4</Sku>
      <Qty>40</Qty>
      <UnitPrice>6.25</UnitPrice>
    </Line>
    <Line no="2">
      <Sku>TON-K</Sku>
      <Qty>4</Qty>
      <UnitPrice>89.00</UnitPrice>
    </Line>
    <Line no="3">
      <Sku>ENV-10</Sku>
      <Qty>10</Qty>
      <UnitPrice>12.40</UnitPrice>
    </Line>
  </Lines>
</PurchaseOrder>

[
  "PAP-A4",
  "TON-K",
  "ENV-10"
]

{
  "body": "(XML text, shown below)"
}

<PurchaseOrder number="PO-77810" date="2026-09-12">
  <Vendor>
    <Name>Summit Paper Co.</Name>
    <Id>V-3301</Id>
  </Vendor>
  <ShipTo>
    <City>Denver</City>
    <State>CO</State>
  </ShipTo>
  <Lines>
    <Line no="1">
      <Sku>PAP-A4</Sku>
      <Qty>40</Qty>
      <UnitPrice>6.25</UnitPrice>
    </Line>
    <Line no="2">
      <Sku>TON-K</Sku>
      <Qty>4</Qty>
      <UnitPrice>89.00</UnitPrice>
    </Line>
    <Line no="3">
      <Sku>ENV-10</Sku>
      <Qty>10</Qty>
      <UnitPrice>12.40</UnitPrice>
    </Line>
  </Lines>
</PurchaseOrder>

730.0

{
  "body": "(XML text, shown below)"
}

<PurchaseOrder number="PO-77810" date="2026-09-12">
  <Vendor>
    <Name>Summit Paper Co.</Name>
    <Id>V-3301</Id>
  </Vendor>
  <ShipTo>
    <City>Denver</City>
    <State>CO</State>
  </ShipTo>
  <Lines>
    <Line no="1">
      <Sku>PAP-A4</Sku>
      <Qty>40</Qty>
      <UnitPrice>6.25</UnitPrice>
    </Line>
    <Line no="2">
      <Sku>TON-K</Sku>
      <Qty>4</Qty>
      <UnitPrice>89.00</UnitPrice>
    </Line>
    <Line no="3">
      <Sku>ENV-10</Sku>
      <Qty>10</Qty>
      <UnitPrice>12.40</UnitPrice>
    </Line>
  </Lines>
</PurchaseOrder>

[
  {
    "po": "PO-77810",
    "line": 1,
    "sku": "PAP-A4",
    "amount": 250.0
  },
  {
    "po": "PO-77810",
    "line": 2,
    "sku": "TON-K",
    "amount": 356
  },
  {
    "po": "PO-77810",
    "line": 3,
    "sku": "ENV-10",
    "amount": 124
  }
]

{
  "body": "(XML text, shown below)"
}

<PurchaseOrder number="PO-77810" date="2026-09-12">
  <Vendor>
    <Name>Summit Paper Co.</Name>
    <Id>V-3301</Id>
  </Vendor>
  <ShipTo>
    <City>Denver</City>
    <State>CO</State>
  </ShipTo>
  <Lines>
    <Line no="1">
      <Sku>PAP-A4</Sku>
      <Qty>40</Qty>
      <UnitPrice>6.25</UnitPrice>
    </Line>
    <Line no="2">
      <Sku>TON-K</Sku>
      <Qty>4</Qty>
      <UnitPrice>89.00</UnitPrice>
    </Line>
    <Line no="3">
      <Sku>ENV-10</Sku>
      <Qty>10</Qty>
      <UnitPrice>12.40</UnitPrice>
    </Line>
  </Lines>
</PurchaseOrder>

"TON-K"

{
  "body": "(XML text, shown below)"
}

<PurchaseOrder number="PO-77810" date="2026-09-12">
  <Vendor>
    <Name>Summit Paper Co.</Name>
    <Id>V-3301</Id>
  </Vendor>
  <ShipTo>
    <City>Denver</City>
    <State>CO</State>
  </ShipTo>
  <Lines>
    <Line no="1">
      <Sku>PAP-A4</Sku>
      <Qty>40</Qty>
      <UnitPrice>6.25</UnitPrice>
    </Line>
    <Line no="2">
      <Sku>TON-K</Sku>
      <Qty>4</Qty>
      <UnitPrice>89.00</UnitPrice>
    </Line>
    <Line no="3">
      <Sku>ENV-10</Sku>
      <Qty>10</Qty>
      <UnitPrice>12.40</UnitPrice>
    </Line>
  </Lines>
</PurchaseOrder>

3

{
  "body": "(XML text, shown below)"
}

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <correlationId>req-5531</correlationId>
  </soap:Header>
  <soap:Body>
    <GetCustomerResponse>
      <customer>
        <id>C-88</id>
        <name>Lakeside Dental</name>
        <tier>gold</tier>
      </customer>
    </GetCustomerResponse>
  </soap:Body>
</soap:Envelope>

"Lakeside Dental"

{
  "body": "(XML text, shown below)"
}

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <correlationId>req-5531</correlationId>
  </soap:Header>
  <soap:Body>
    <GetCustomerResponse>
      <customer>
        <id>C-88</id>
        <name>Lakeside Dental</name>
        <tier>gold</tier>
      </customer>
    </GetCustomerResponse>
  </soap:Body>
</soap:Envelope>

"req-5531"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"<?xml version=\"1.0\" encoding=\"UTF-8\"?><order><id>#1042</id><city>Austin</city><items>3</items></order>"

{
  "line": "1042,Olivia Hart,2026-09-14,129.45,TX",
  "quoted": "1043|\"Davis, Emily\"|2026-09-15|88.00|NY",
  "header": "order_id,customer,date,total,state"
}

[
  "1042",
  "Olivia Hart",
  "2026-09-14",
  "129.45",
  "TX"
]

{
  "line": "1042,Olivia Hart,2026-09-14,129.45,TX",
  "quoted": "1043|\"Davis, Emily\"|2026-09-15|88.00|NY",
  "header": "order_id,customer,date,total,state"
}

{
  "orderId": 1042,
  "customer": "Olivia Hart",
  "date": "2026-09-14",
  "total": 129.45,
  "state": "TX"
}

{
  "line": "1042,Olivia Hart,2026-09-14,129.45,TX",
  "quoted": "1043|\"Davis, Emily\"|2026-09-15|88.00|NY",
  "header": "order_id,customer,date,total,state"
}

[
  "order_id",
  "customer",
  "date",
  "total",
  "state"
]

{
  "line": "1042,Olivia Hart,2026-09-14,129.45,TX",
  "quoted": "1043|\"Davis, Emily\"|2026-09-15|88.00|NY",
  "header": "order_id,customer,date,total,state"
}

"Davis, Emily"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"#1042,Hart,105.00,TX"

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "INV-2041,Brightpaws Pet Supply,1250.00",
  "INV-2042,Northpeak CPA,480.00",
  "INV-2043,Harbor Freight Ops,3920.50",
  "INV-2045,Northpeak CPA,1100.00"
]

{
  "line": "0001042HART      OLIVIA    20260914000012945TX"
}

{
  "id": "0001042",
  "last": "HART",
  "first": "OLIVIA"
}

{
  "line": "0001042HART      OLIVIA    20260914000012945TX"
}

129.45

{
  "line": "0001042HART      OLIVIA    20260914000012945TX"
}

"2026-09-14"

{
  "line": "0001042HART      OLIVIA    20260914000012945TX"
}

{
  "id": 1042,
  "name": "Olivia Hart",
  "date": "2026-09-14",
  "amount": 129.45,
  "state": "TX"
}

{
  "name": "HART",
  "amount": 129.45
}

"HART      000012945"

{
  "order_id": 1042,
  "amount": 129.45,
  "event_ts": "2026-09-14T15:42:10.123Z",
  "region": "West",
  "attributes": {
    "channel": "web",
    "device": "mobile",
    "utm_source": "newsletter"
  },
  "items": [
    {
      "sku": "MUG-11",
      "qty": 2
    },
    {
      "sku": "CAP-01",
      "qty": 3
    }
  ]
}

{
  "id": 1042,
  "amount": 129.45,
  "region": "West"
}

{
  "order_id": 1042,
  "amount": 129.45,
  "event_ts": "2026-09-14T15:42:10.123Z",
  "region": "West",
  "attributes": {
    "channel": "web",
    "device": "mobile",
    "utm_source": "newsletter"
  },
  "items": [
    {
      "sku": "MUG-11",
      "qty": 2
    },
    {
      "sku": "CAP-01",
      "qty": 3
    }
  ]
}

"web/mobile"

{
  "order_id": 1042,
  "amount": 129.45,
  "event_ts": "2026-09-14T15:42:10.123Z",
  "region": "West",
  "attributes": {
    "channel": "web",
    "device": "mobile",
    "utm_source": "newsletter"
  },
  "items": [
    {
      "sku": "MUG-11",
      "qty": 2
    },
    {
      "sku": "CAP-01",
      "qty": 3
    }
  ]
}

5

{
  "order_id": 1042,
  "amount": 129.45,
  "event_ts": "2026-09-14T15:42:10.123Z",
  "region": "West",
  "attributes": {
    "channel": "web",
    "device": "mobile",
    "utm_source": "newsletter"
  },
  "items": [
    {
      "sku": "MUG-11",
      "qty": 2
    },
    {
      "sku": "CAP-01",
      "qty": 3
    }
  ]
}

"region=West/date=2026-09-14"

{
  "order_id": 1042,
  "amount": 129.45,
  "event_ts": "2026-09-14T15:42:10.123Z",
  "region": "West",
  "attributes": {
    "channel": "web",
    "device": "mobile",
    "utm_source": "newsletter"
  },
  "items": [
    {
      "sku": "MUG-11",
      "qty": 2
    },
    {
      "sku": "CAP-01",
      "qty": 3
    }
  ]
}

[
  {
    "order_id": 1042,
    "sku": "MUG-11",
    "qty": 2,
    "channel": "web"
  },
  {
    "order_id": 1042,
    "sku": "CAP-01",
    "qty": 3,
    "channel": "web"
  }
]

{
  "state": "TX",
  "subtotal": 98.0,
  "rates": [
    {
      "state": "CA",
      "rate": 0.0725
    },
    {
      "state": "NY",
      "rate": 0.04
    },
    {
      "state": "TX",
      "rate": 0.0625
    }
  ],
  "reps": [
    {
      "region": "West",
      "rep": "James Miller",
      "slack": "@james"
    },
    {
      "region": "East",
      "rep": "Emily Davis",
      "slack": "@emily"
    },
    {
      "region": "Central",
      "rep": "Michael Brown",
      "slack": "@michael"
    }
  ],
  "lead": {
    "company": "Lakeside Dental",
    "state": "TX",
    "employees": 42,
    "source": "typeform",
    "region": "Central"
  }
}

0.0725

{
  "state": "TX",
  "subtotal": 98.0,
  "rates": [
    {
      "state": "CA",
      "rate": 0.0725
    },
    {
      "state": "NY",
      "rate": 0.04
    },
    {
      "state": "TX",
      "rate": 0.0625
    }
  ],
  "reps": [
    {
      "region": "West",
      "rep": "James Miller",
      "slack": "@james"
    },
    {
      "region": "East",
      "rep": "Emily Davis",
      "slack": "@emily"
    },
    {
      "region": "Central",
      "rep": "Michael Brown",
      "slack": "@michael"
    }
  ],
  "lead": {
    "company": "Lakeside Dental",
    "state": "TX",
    "employees": 42,
    "source": "typeform",
    "region": "Central"
  }
}

0.04

{
  "state": "TX",
  "subtotal": 98.0,
  "rates": [
    {
      "state": "CA",
      "rate": 0.0725
    },
    {
      "state": "NY",
      "rate": 0.04
    },
    {
      "state": "TX",
      "rate": 0.0625
    }
  ],
  "reps": [
    {
      "region": "West",
      "rep": "James Miller",
      "slack": "@james"
    },
    {
      "region": "East",
      "rep": "Emily Davis",
      "slack": "@emily"
    },
    {
      "region": "Central",
      "rep": "Michael Brown",
      "slack": "@michael"
    }
  ],
  "lead": {
    "company": "Lakeside Dental",
    "state": "TX",
    "employees": 42,
    "source": "typeform",
    "region": "Central"
  }
}

{
  "company": "Lakeside Dental",
  "owner": "Michael Brown",
  "notify": "@michael"
}

{
  "state": "TX",
  "subtotal": 98.0,
  "rates": [
    {
      "state": "CA",
      "rate": 0.0725
    },
    {
      "state": "NY",
      "rate": 0.04
    },
    {
      "state": "TX",
      "rate": 0.0625
    }
  ],
  "reps": [
    {
      "region": "West",
      "rep": "James Miller",
      "slack": "@james"
    },
    {
      "region": "East",
      "rep": "Emily Davis",
      "slack": "@emily"
    },
    {
      "region": "Central",
      "rep": "Michael Brown",
      "slack": "@michael"
    }
  ],
  "lead": {
    "company": "Lakeside Dental",
    "state": "TX",
    "employees": 42,
    "source": "typeform",
    "region": "Central"
  }
}

[
  "James Miller covers West",
  "Emily Davis covers East",
  "Michael Brown covers Central"
]

{
  "state": "TX",
  "subtotal": 98.0,
  "rates": [
    {
      "state": "CA",
      "rate": 0.0725
    },
    {
      "state": "NY",
      "rate": 0.04
    },
    {
      "state": "TX",
      "rate": 0.0625
    }
  ],
  "reps": [
    {
      "region": "West",
      "rep": "James Miller",
      "slack": "@james"
    },
    {
      "region": "East",
      "rep": "Emily Davis",
      "slack": "@emily"
    },
    {
      "region": "Central",
      "rep": "Michael Brown",
      "slack": "@michael"
    }
  ],
  "lead": {
    "company": "Lakeside Dental",
    "state": "TX",
    "employees": 42,
    "source": "typeform",
    "region": "Central"
  }
}

0

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  {
    "sku": "MUG-11",
    "title": "Ceramic mug",
    "qty": 2,
    "price": 14.5,
    "tags": [
      "kitchen",
      "gift"
    ],
    "lineTotal": 29
  },
  {
    "sku": "TEE-M",
    "title": "Logo tee",
    "qty": 1,
    "price": 22,
    "tags": [
      "apparel"
    ],
    "lineTotal": 22
  },
  {
    "sku": "CAP-01",
    "title": "Canvas cap",
    "qty": 3,
    "price": 18,
    "tags": [
      "apparel",
      "gift"
    ],
    "lineTotal": 54
  }
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  {
    "sku": "MUG-11",
    "title": "Ceramic mug",
    "quantity": 2,
    "price": 14.5,
    "tags": [
      "kitchen",
      "gift"
    ]
  },
  {
    "sku": "TEE-M",
    "title": "Logo tee",
    "quantity": 1,
    "price": 22,
    "tags": [
      "apparel"
    ]
  },
  {
    "sku": "CAP-01",
    "title": "Canvas cap",
    "quantity": 3,
    "price": 18,
    "tags": [
      "apparel",
      "gift"
    ]
  }
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  {
    "sku": "MUG-11",
    "qty": 2
  },
  {
    "sku": "TEE-M",
    "qty": 1
  },
  {
    "sku": "CAP-01",
    "qty": 3
  }
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  {
    "sku": "MUG-11",
    "qty": 2,
    "price": 14.5
  },
  {
    "sku": "TEE-M",
    "qty": 1,
    "price": 22
  },
  {
    "sku": "CAP-01",
    "qty": 3,
    "price": 18
  }
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

{
  "first_name": "olivia",
  "last_name": "hart",
  "email": "olivia.hart@example.com",
  "phone": "(415) 555-0134",
  "address": {
    "city": "Austin",
    "state": "TX",
    "zip": "78701"
  }
}

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "INV-2043 2026-07-31",
  "INV-2044 2026-08-01",
  "INV-2041 2026-08-20",
  "INV-2045 2026-09-01",
  "INV-2042 2026-09-30"
]

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "INV-2041 30+",
  "INV-2042 current",
  "INV-2043 30+",
  "INV-2044 30+",
  "INV-2045 current"
]

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  {
    "region": "West",
    "open": 5170.5
  },
  {
    "region": "East",
    "open": 1580.0
  },
  {
    "region": "Central",
    "open": 0
  }
]

{
  "device": "PUMP-07",
  "readings": [
    {
      "ts": "2026-09-14T08:00:00Z",
      "temp_c": 61.2,
      "psi": 88
    },
    {
      "ts": "2026-09-14T08:05:00Z",
      "temp_c": 64.8,
      "psi": 91
    },
    {
      "ts": "2026-09-14T08:10:00Z",
      "temp_c": 79.5,
      "psi": 97
    }
  ]
}

97

{
  "email": "office@lakesidedental.com"
}

true

{
  "zip": "78701-1234"
}

true

{
  "id": 5521,
  "subject": "Order #1042 arrived damaged - need refund",
  "body": "Hi, my order #1042 came with a broken mug. Can I get a refund? Thanks, Olivia",
  "priority": null,
  "customer_tier": "gold",
  "channel": "email",
  "created": "2026-09-14T09:12:00Z"
}

true

{
  "asOf": "2026-09-14",
  "invoices": [
    {
      "number": "INV-2041",
      "customer": "Brightpaws Pet Supply",
      "amount": 1250.0,
      "due": "2026-08-20",
      "status": "open",
      "region": "West",
      "email": "ap@brightpaws.com"
    },
    {
      "number": "INV-2042",
      "customer": "Northpeak CPA",
      "amount": 480.0,
      "due": "2026-09-30",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    },
    {
      "number": "INV-2043",
      "customer": "Harbor Freight Ops",
      "amount": 3920.5,
      "due": "2026-07-31",
      "status": "open",
      "region": "West",
      "email": null
    },
    {
      "number": "INV-2044",
      "customer": "Lakeside Dental",
      "amount": 615.0,
      "due": "2026-08-01",
      "status": "paid",
      "region": "Central",
      "email": "office@lakesidedental.com"
    },
    {
      "number": "INV-2045",
      "customer": "Northpeak CPA",
      "amount": 1100.0,
      "due": "2026-09-01",
      "status": "open",
      "region": "East",
      "email": "billing@northpeakcpa.com"
    }
  ]
}

[
  "INV-2041: ok",
  "INV-2042: ok",
  "INV-2043: no billing email",
  "INV-2044: ok",
  "INV-2045: ok"
]

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

[
  "id",
  "currency",
  "note"
]

{
  "user": "api",
  "key": "test-key-123"
}

"Basic YXBpOnRlc3Qta2V5LTEyMw=="

{
  "data": "SGVsbG8sIE9saXZpYQ=="
}

"Hello, Olivia"

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

"ecb874311f1566ea"

{
  "q": "Lakeside Dental & Ortho"
}

"https://api.example.com/search?q=Lakeside%20Dental%20%26%20Ortho"

{
  "q": "Lakeside%20Dental%20%26%20Ortho"
}

"Lakeside Dental & Ortho"

{
  "comment": "(XML text, shown below)"
}

<b>Great</b> service & fast

"<b>Great</b> service & fast"

{
  "t": "Smith & Sons <LLC>"
}

"Smith & Sons <LLC>"

{
  "doc": "Order #1042 shipped. Order #1042 shipped. Order #1042 shipped."
}

true

{
  "id": "#1042",
  "created_at": "2026-09-14T15:42:10Z",
  "customer": {
    "first_name": "olivia",
    "last_name": "hart",
    "email": "  Olivia.Hart@Example.com ",
    "phone": "(415) 555-0134",
    "address": {
      "city": "Austin",
      "state": "TX",
      "zip": "78701"
    }
  },
  "financial_status": "pending",
  "currency": "USD",
  "line_items": [
    {
      "sku": "MUG-11",
      "title": "Ceramic mug",
      "qty": 2,
      "price": 14.5,
      "tags": [
        "kitchen",
        "gift"
      ]
    },
    {
      "sku": "TEE-M",
      "title": "Logo tee",
      "qty": 1,
      "price": 22,
      "tags": [
        "apparel"
      ]
    },
    {
      "sku": "CAP-01",
      "title": "Canvas cap",
      "qty": 3,
      "price": 18,
      "tags": [
        "apparel",
        "gift"
      ]
    }
  ],
  "discount": 5,
  "shipping": 7.95,
  "note": null
}

null

(no input: the formula stands alone)

true

(no input: the formula stands alone)

36