MCP use case: questions that take several steps

- route:
    id: search-customers
    from:
      uri: ai-tool:search_customers
      parameters:
        title: Search customers
        description: >-
          Find customers by part of their name, email address or phone number. Returns id, name,
          email, phone, city and tier for every match (several people can share a name, so check
          the email or city before acting for one of them). Use the id with get_customer or
          list_orders.
        tags: acme
        parameter.query: string
        parameter.query.description: Part of a name, email or phone number, such as "Priya", "jordan.k@" or "900103"
        parameter.query.required: true
        readOnlyHint: true
        idempotentHint: true
      steps:
        - setHeader:
            name: pattern
            simple: "%${header.query}%"
        - to: "sql:select id, name, email, phone, city, tier from customers where name ilike :#pattern or email ilike :#pattern or phone like :#pattern order by name, id?dataSource=jdbc:rustsql:mem:acme"
        - choice:
            when:
              - simple: "${body.size()} == 0"
                steps:
                  - setBody:
                      simple: '{"matches": [], "note": "No customer matches \"${header.query}\". Try part of the name, the email or the phone number."}'
            otherwise:
              steps:
                - marshal:
                    json: {}

- route:
    id: list-orders
    from:
      uri: ai-tool:list_orders
      parameters:
        title: List orders
        description: >-
          List orders, newest first, filtered by customer, status and/or creation date. Statuses:
          pending (not paid), paid (waiting to ship), shipped, delivered, cancelled, returned.
          Returns id, customer, status, dates and total; use get_order for the items.
        tags: acme
        parameter.customerId: integer
        parameter.customerId.description: Only this customer's orders (id from search_customers)
        parameter.status: string
        parameter.status.description: Only orders with this status
        parameter.status.enum: pending,paid,shipped,delivered,cancelled,returned
        parameter.createdFrom: string
        parameter.createdFrom.description: Only orders created on or after this date, YYYY-MM-DD
        parameter.createdTo: string
        parameter.createdTo.description: Only orders created on or before this date, YYYY-MM-DD
        readOnlyHint: true
        idempotentHint: true
      steps:
        - setHeader:
            name: cid
            simple: "${header.customerId ?: 0}"
        - setHeader:
            name: st
            simple: "${header.status ?: ''}"
        - setHeader:
            name: dfrom
            simple: "${header.createdFrom ?: '1900-01-01'}"
        - setHeader:
            name: dto
            simple: "${header.createdTo ?: '2999-12-31'}"
        - to: "sql:select o.id, o.customer_id, c.name as customer, o.status, o.created, o.shipped, o.delivered, o.total, o.refunded from orders o join customers c on c.id = o.customer_id where (:#cid = 0 or o.customer_id = :#cid) and (:#st = '' or o.status = :#st) and o.created >= :#dfrom and o.created <= :#dto order by o.created desc, o.id desc?dataSource=jdbc:rustsql:mem:acme"
        - marshal:
            json: {}

cd examples/agents/mcp-shop
cameleer run shop.camel.yaml --properties application.properties