Best Approach to Integrating Workday Data into ServiceNow without duplicate record

[jjunio31]

Hi everyone,

I'm new to ServiceNow integrations (Workday and other external systems), and we have a requirement where Workday will be the source of truth. We need to ensure that user records integrated from Workday do not create duplicate entries in ServiceNow, specifically in the sys_user, sn_hr_core_profile, and cmn_location tables.

One key requirement is that if a record already exists, it should be updated instead of creating a new one (upsert logic). If no matching record is found, a new record should be inserted.

I’m not yet familiar with how integrations work in ServiceNow, and I also don’t know whether the data will be integrated via a scheduled job (batch sync) or on-demand (real-time sync). Can anyone provide guidance on the different integration approaches and which method might be best suited for this requirement?

How can we ensure that duplicate records are prevented while integrating the data?

Thanks in advance!

[Ankur Bawiskar]

@jjunio31 

are you planning to use spoke for this?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[jjunio31]

Hi @Ankur Bawiskar, 

Yes, we will be using the spoke for this. We want to utilize the OOB as much as possible. Do you have any idea on how to achieve the requirements above?

[Ankur Bawiskar]

@jjunio31 

you will have to check the documentation for the spoke

If my response helped please mark it correct and close the thread so that it benefits future readers.

[jjunio31]

I've already read some documentation but couldn't find an answer. Do you know of any docs that contain something similar to this requirement? As much as I want to try it on my PDI, the Workday spoke is not available on PDI.