My question is not how to call a web page in code but rather what the correct architecture for it would be.
I have an MVC web app that displays certain data from our database when the user visits a page. The data in question comes from another site, and I need to load it into our database once an hour by calling the other site's web service.
My question is, should I have a separate Windows Service running on my server that calls the page and inserts the relevant data into our database, or should this be done on a timer directly from the web app? That seems like it would be a weird way to go about it but perhaps this is standard? We already have a program running on the server that calls an ashx handler once every so often and I could easily write a controller to handle this, I'm just curious what the current best approach is. I did some searching for timer events on the server side in web apps and while I found answers, there were also a lot of "it sounds like you are going down a rabbit hole/XY problem/etc and I'd like to know the proper way.