I've been trying to fetch full history from SF on Job history based on 4 fields, but so far with the Odata API I've not been able to do so..Ideally I would like to see the start and end date for when customstring1 has in fact changed (not for all entries in job info), but by what I've understood the function in the adapter won't be able to get me that and I would have to resort to either complex groovy or javascript (if such an example is available that would be highly appreciated!).
With the standard connector it won't allow me to use toDate/FromDate/similar things that the oData api would recognize in for instance postman with an instruction, so I seem to be stuck to the standard fields that job info offers for filtering which do not seem to support in getting multiple records per employee. My current Get query looks something like this (I've already tried to use last modified date, start date and end date for filtering, but nothing really seems to be getting me historical records for employees. Any thoughts on how to leverage this better or do I really need to use the SFAPI API/scripting/something else instead?
Example current query in the SF adapter:
Operation: Query(GET)
ResourcePath :EmpJob?$select=seqNumber,startDate,userId,endDate,customString1Nav/externalCode&$expand=customString1Nav&$filter=customString1Nav/externalCode ne null
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.