Back to the use case from the previous post - syncing users between SFDC and downstream apps. There are multiple approaches to getting the users from SFDC.
1. Scheduled job using SOQL to retrieve users that have been changed since the last run. The field - LastModifiedDate - can be used or even the SOQL SystemModStamp field e.g.
WHERE SystemModStamp >= LAST_N_DAYS:1
LAST_N_DAYS:1 - gives me any changes from yesterday.
I test this query in the adapter wizard - only Julius Martov, the user I was working on yesterday is returned.
I can, of course, add an integration parameter -
and use this in the query -
SOQL is -
SELECT AboutMe, AccountId,Alias, BadgeText, BannerPhotoUrl, CallCenterId, City, CommunityNickname, CompanyName, ContactId, Country, Department,Division,Email, EmailEncodingKey, EmployeeNumber,Extension,Fax, FirstName,IndividualId,IsActive, LanguageLocaleKey,LastLoginDate, LastName, ManagerId, MobilePhone, Phone, PostalCode, ProfileId,SenderEmail, SenderName, Signature, State,Street,Title, Username, UserRoleId, UserType, LastModifiedDate FROM USER WHERE LastModifiedDate >= &dateLastRun
The query parameter appears in the mapper and can be set to p_dateLastRun.