Insert or update customer record

Overview

In this scenario, we show how to insert or update a customer’s master data without sending an email to the customer.

XML


<?xml version="1.0" encoding="UTF-8"?>
<kanaRoot>
<EventRequest Id="" CompanyName="default" CampaignName="camp1">
<Customer EmailAddress="[email protected]" First_Name="Jane" Last_Name="Doe"
City="Menlo Park" State="CA"
SendEmail="false"
Subscription="ignore"
>
</Customer>
</EventRequest>
</kanaRoot>


Result

If a customer with the email address, [email protected], does not exist in the CUSTOMER_MASTER table, then a new record will be added. If the customer does exist in the database, the record will be updated with the corresponding customer data. The CUST_SUBSCRIPTION table is left alone.

A new row is inserted into the EVENT_QUEUE table with status_code = 3 (handled) for each <Customer> element.

No email is sent.