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"> 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.