Schedule workflow to update Football Match database

jakemorissette · 2024-08-18T19:07:18.007Z

Hi

I’ve set up the pictured API Workflow and button click to trigger the API workflow to add the EPL football matches from the current day to my ‘Match’ database.

This works, so when the button is clicked - all matches from the current day are added to the database.

I’d like to update what I have (or create a different workflow) to schedule updates to the ‘Match’ database automatically only when match results are available - so when match final scores are available, the match results are added to the database.

Any suggestions or thoughts on how best to do this?

Thanks for any help!

api workflow 2918×511 32.8 KB

button click 2896×612 56.4 KB

HariPrasad · 2024-08-18T19:20:30.732Z

Hey Jake,

There’s 2 ways you can solve this issue and set up automatic data updation.

You can set up the webhook from the 3 rd party service which sends you the match data. This set up helps you in updating the data in realtime.
You can set up a recurring event in which it’ll trigger itself in a scheduled interval and will update only if data are available if not it’ll just trigger again and it’ll be a never ending loop which can be controlled in scheduled workflow tabs

Let me know if this helps

Cheers

timzyroyalz · 2024-08-18T19:58:14.271Z

you can get web hook or the param from the third party’s API, set the API to run when current page user is active. that is it will stop working when there is no activity on the page

jakemorissette · 2024-08-19T19:40:28.320Z

Thanks, this was helpful. Have found adding an action at the end of my backend API workflow help with making it recursive. Will just now add conditions to only take the result of match status is full time.