API Odata V2 Events, empjob not pulling as of each event, but as of 1st employee record

[krutland1]

Hi, using Odata V2 API to pull events is not pulling correctly. Its returning the oldest record for the employee, not their empjob data as of the event start date (effective date). I want to see all events for employees within a date range and have their EmpJob / user data show as of the event start date. I can do this in reporting in successfactors (story & table reports) so I know it CAN work . 

When I run the API Call i get the first sequence of user data for any event. one EE has 10 events since being hired (including a promotion, manager changes, etc.) and on each of them shows his user detail as of his hire event (sequence 1)

I tried it 2 ways EmpJob without any Nav fields 

/odata/v2/EmpJob?$format=JSON&$select=localJobTitle,endDate,event,seqNumber,eventReason,jobTitle,startDate,managerId&$filter=userId eq '74395'&fromDate=2023-01-01&toDate=2025-03-28

and EmpJob with Nav fields

odata/v2/EmpJob?$format=JSON&$expand=eventReasonNav,employmentNav&$select=eventReasonNav/event,eventReasonNav/externalCode,eventReasonNav/name,eventReasonNav/startDate,eventReasonNav/status,eventReasonNav/internalCode,businessUnit,managerId,localJobTitle,userId&$filter=userId eq '74395'&fromDate=2023-01-01&toDate=2025-03-28