Salesforce - UPlay
Salesforce is cloud-based platform that provides customer relationship management software and applications focused on sales, customer service and marketing automation etc.
Objective
To sync UPlay customer data between Avalon and Salesforce to achieve a 360-degree view of the customer in Salesforce, to personalize emails/campaigns and increase user productivity by providing aligned customer information across ClubWide.
API integration was implemented on 26 May 2024.
Data-push scenario
New customer data
Yes
No
UPlay newsletter subscription
Yes
No
Update customer data
Yes
Yes
Delete customer data
No
No
Trigger data-push point (Avalon -> Salesforce)
Avalon will trigger data-push to Salesforce at following 2 points, based on UPlay customers' action.
(a) At initial (first time) login to UPlay via LinkPass
(b) Whenever UPlay customers update their profile in UPlay.
* Action is completed by Sitefinity where retrieves data from Avalon.
Trigger data-push point (Salesforce -> Avalon)
Salesforce will trigger data-push to Avalon at following points.
API field mapping
UPlay_Customer_ID
N
Single value
First Name
Y
Single value
Last Name
N
Single value
Email Address
N
Single value
Gender
Y
Single value
Male, Female
Birth Date
Y
Single value
Segment
N
Single value
NTUC (Silver) Member, Friends of UPlay, Public
Recency
N
Multiple value
No purchases yet, Within last fortnight,
Within last 1 month,
Within last 3 months,
Within last 6 months,
Within last 18 months
Frequency
N
Multiple value
10 or more within the last 12 months,
1-3 purchases within last 12 months,
No purchases yet
Monetary
N
Multiple value
$201 or more $101-$200 $51-$100 $21-$50 $20 or less No purchases yet
Source Code
N
Single value
UA HPA
UA FBMA
UA HPA
CAN
N
Single value
ExchangeID
N
Single value
NRIC
Y
Single value
Union
N
Multiple value
Refer to union listing
Membership
N
Multiple value
SMMWU (union)
NTUC Link Member (Black Plus! card)
NTUC Member (Silver Plus! card)
Newsletter subscribe
Y
Single value
Yes, No
Signup / Unsubscribed Date
N
Single value
Last_Modified_Date
N
Marital Status
Y
Single value
Single, Married, Divorce, Widowed
Kids
Y
Single value
Interests
Y
Multiple value
Badminton, Baking, Bowling, Crafts, Cyber, Cycling, Dancing, Dragon, ESports, Financial, Food, Futsal, Gardening, Golf, Pets, Photography, Running, Sepak Takraw, Singing, Swimming, Travel, Volunteering, Wellness, Wine
Purchase Categories
N
Multiple value
Multiple values are represented in JSON array, separated with comma.
Picklist values, especially those highlighted in orange, are defined by Salesforce, and both Avalon and Salesforce must be in-sync. Eg: If Salesforce adds 1 new value to Interests (Basketball), Avalon must be notified to add. Otherwise, API processing will fail.
API endpoints
UAT
https://ntucclub--uat.sandbox.my.salesforce.com/
PROD
https://ntucclub.lightning.force.com/services/data/v58.0/sobjects/account
Last updated