How to send data from a repeating to the database all at once

I have a problem that I’ve been trying to fix since yesterday. I have a repeating group full of job posts. I want to update the expiry date of all jobs posts all at once whenever a page is loaded. I would really appreciate some help. I have attached pictures below to help in better understanding.


On the screenshot above, I have a list of jobs. I need help on how to update the dates on the “Expires on” column for each job to the database whenever the page loads.
Any kind of help will be appreciated.

you can use bulk API to update the" expires on" field using the backend workflows.
or
you can use Database Trigger in backend to update a record when a change is made

if you want help with any of the above methods reply to this message

Hope this helps

The main issue is how to extract that data from the repeating group so that I can send it back to the database. I have tried using backend workflows but it did not work

Yeah… assuming it’s not thousands of things, just use Make Changes To A List Of Things

Can you please explain this further using screenshots if possible.

I pulled that data from a jobs scrapping API. After I’ve called the API, I send the results to the database. The API is sending back the job expiry dates in string format instead of dates. I am displaying the data in a repeating group then converting the date strings in date format. The main problem I am having is sending the dates in date format back to the database.
I have attached screenshots below


This screenshot shows how I am converting the date strings from string to date format.
The problem comes in when I try now to send the converted date displayed there as ''stringtodatetime A’s return" back to the database. For some reason I can’t access it.
I hope you understand the problem better.

So I have to call API again? This is going to be a problem since I already have over 2000 jobs on my website and I wanted to find a way to remove all expired job posts without deleting everything.

Yes, this is what I want to do. Send back the date to the database after conversion