Springboot microservice -> existing endpoint to be enhanced

Hi
I have a Job service written in Java Springboot. The job makes a call to an API endpoint & retrieves all the records.
It deletes the existing records in our table & creates the records in our table with the response received.

I would like to do the following
//TODO: Instead of deleting all records & recreating it, perform the following
For the given data:
1. Delete records from table that does not exist in API response
2. Find matching records in table + response & update data, if it exists
3. Insert records that does not exist in Table, but in API response

The following should be done after refining the method

For all the records in the table -> call another endpoint to retrieve further details. Based on the "type" of the record -> specific endpoint should be called. There are 3 endpoints to call (which take the same input & send same output format)
The input data is formatted using the values in the table-record
The response should be updated in the table-record.