update-contact-email
Grading criteriawhat this conversation was scored against
DB end-state
{
"customers": {
"changed": [
{
"pk": {
"cust_id": "CUST-heritage-auto"
},
"fields": {
"email": [
"walter.pennington@example.com",
"walter.p@example.com"
]
}
}
]
}
}Judge rubric
The rep confirmed back to the customer that the email address was successfully updated to the new address (walter.p@example.com).(advisory)
Verdicts
DB end-statepassed
DB end-state matches the expected changeset.
Judge rubricpassed
judge: The rep explicitly confirmed the email was updated to walter.p@example.com.
Conversation
Hi, thanks for contacting PEICO — this is the service desk. How can I help you today?
Hi there! Thanks for picking up. I need to update the email address on my account. I'm cleaning up my inbox and want to switch it to a new one. Can you help me with that?
I'd be happy to help with that. First, I need to verify your identity. Could you please give me your full name and the email or phone number currently on file (and ideally your date of birth)?
Sure thing. My name is Walter Pennington. The email I have on file right now is walter.pennington@example.com. As for a phone number, I don't have one listed. My date of birth is November 2, 1957, if that helps.
⚙ query_db(SELECT cust_id, first_name, last_name, dob, email, phone FROM customers WHERE…)
{
"sql": "SELECT cust_id, first_name, last_name, dob, email, phone FROM customers WHERE lower(email)='walter.pennington@example.com' OR (lower(first_name)='walter' AND lower(last_name)='pennington')"
}{
"rows": [
{
"cust_id": "CUST-heritage-auto",
"first_name": "Walter",
"last_name": "Pennington",
"dob": "1957-11-02",
"email": "walter.pennington@example.com",
"phone": null
}
],
"row_count": 1,
"truncated": false
}Thanks, Walter — that all matches what we have on file. You're verified.
What's the new email address you'd like to use?
Great, thanks for verifying me. I'd like to change it to walter.p@example.com.
⚙ update_contact(CUST-heritage-auto, walter.p@example.com)
{
"cust_id": "CUST-heritage-auto",
"email": "walter.p@example.com"
}{
"ok": true,
"rows_affected": 1,
"changeset": {
"customers": {
"changed": [
{
"pk": {
"cust_id": "CUST-heritage-auto"
},
"fields": {
"email": [
"walter.pennington@example.com",
"walter.p@example.com"
]
}
}
]
}
}
}Done! Your email is now updated to walter.p@example.com. Is there anything else I can help you with?
No, that's all I needed. Thanks so much for taking care of that for me!
⚙ end_conversation()
{}{
"ok": true,
"note": "Deliver your closing message now."
}Thanks for being a valued PEICO customer — take care!