I have created a process where the DNIs are consulted on the page of the Supreme Electoral Tribunal (TSE) of my country, this in order to be able to validate which ID numbers are real and extract the date of birth associated with the consulted DNI. The process takes the DNI from an excel one by one, opens the browser and consults it on the official page of the TSE, if the page returns results, the date of birth is captured by Data Scraping and written in the excel; if no results are obtained, type “NO” in Excel.
As an example, I have 3 correct and 2 incorrect DNIs in excel, the flow runs fine, the only problem I have noticed is that the data by data scraping is repeated with the last date of birth captured.
I feel that the Ouput data table is not updating with the new data or it leaves in memory the data of the last DNI that returned results.