Hi Bubble Community,
I’ve added an API in my Plugins API connector, and I’m looking to set up a cron job that runs daily at 11:55 AM and automatically fetches data from this API. The job should fetch data twice, with different URL parameters for each call, and insert the data into my daily attendance table.
Here’s the scenario:
- The API requires the following URL parameters:
- sdate and edate: These should be set to the current date in
yyyy-MM-ddformat. - startindex: This is
0for the first run and100for the second run. Both runs should happen at the same time.
- After fetching data from the API, I want to insert it into my daily attendance table. The format of the table is as follows:
- Employee Name
- Date
- In Time
- Out Time
- Duration
- The cron job should run daily and execute two times at 11:55 AM with the same parameters except for
startindex(0 for the first call and 100 for the second).
How can I achieve this in Bubble.io? Specifically:
- How do I set up the cron job to run daily at 11:55 AM?
- How can I dynamically set the
sdateandedateto the current date and manage different values forstartindex? - How can I structure the workflow to run twice with different startindex values and then insert the data into my attendance table?
Any guidance would be greatly appreciated!
Thank you!
