Overriding current work schedule using Loader without using Assignment ID

Hi,

We need to end date current work schedules assigned at assignment level and assign new work schedule, but when we try it using spreadsheet & HDL, we are getting below overlapping error.

"You can't assign a schedule of the same category and with an overlapping date range more than once. (PER-1530569)"

For ex: current schedule is from 3/1/22 to 12/31/2049; Now, we are passing start date as 3/1/22 & end date as 7/1/23 in HDL/HSDL. it is not end dating the end date, instead throwing overlap error.

If we pass ScheduleAssignmentId, then the issue is not there; but extracting Assignment ID every time in bulk for client is not a feasible solution.