We have base database where the Candidate records are created/update/deleted. In elasticsearch we are using es generated ID. However database do not know the ES ID generated for the record. In a batch process we are fetching the 500 records from DB and sending them to ES but we do not know which records needs to insert and which record needs to update. Also we do not know the ES ID of already updated records.
Using CURL request in BULK is there any way we can first check whether the record is present or not using unique email address of each record. If it is present then send Update request or if it is not present then send Insert request.
Is there any way we can write the script inside the BULK call?