Hello Team,
I am new to Workato, i am trying to build a data integration to sync data from Workday to SharePoint List.
I have employee data coming from Workday, which is also stored in a SharePoint list. My requirement is to set up a daily integration that checks for new employees in Workday and adds them to the SharePoint list. Additionally, the integration should identify any changes to existing employee records and update the SharePoint list accordingly.
What is the recommended way to achieve it without using Foreach loop?
JSON1=[
{
"lastName": "Smith",
"User_Name": "jsmith1",
"Email_-_Work": "jsmith@example.com",
"Company": "TechCorp",
"Position": "Developer",
"Legal_Last_Name": "Smith",
"Employee_ID": "12345"
},
{
"lastName": "Smith",
"User_Name": "jsmith2",
"Email_-_Work": "jsmith@example.com",
"Company": "TechCorp2",
"Position": "Developer",
"Legal_Last_Name": "Smith",
"Employee_ID": "12345"
}
{
"lastName": "Smith",
"User_Name": "jsmith3",
"Email_-_Work": "jsmith@example.com",
"Company": "TechCorp",
"Position": "Developer",
"Legal_Last_Name": "Smith",
"Employee_ID": "12345"
}
]
JSON2=[
{
"lastName": "Smith",
"User_Name": "jsmith1",
"Email_-_Work": "jsmith@example.com",
"Company": "TechCorp",
"Position": "Developer",
"Legal_Last_Name": "Smith",
"Employee_ID": "12345",
"ID": "1"
},
{
"lastName": "Smith",
"User_Name": "jsmith2",
"Email_-_Work": "jsmith@example.com",
"Company": "TechCorp3",
"Position": "Developer",
"Legal_Last_Name": "Smith",
"Employee_ID": "12345",
"ID": "2"
}
]
JSON1 is my main data source which should synced with SharePoint list, once we identify the changes, we can update/create in the SharePoint list, please note that SharePoint will have the extra column called "ID" which needs to be ignored when matching as this column is needed to update in SharePoint.
Any suggestions are highly appreciated.
