title: architecture for get and store api request data
body: <p>This is more of a architectural questions. An external platform had product and price information for let's say, books. There is an API available to get this information.</p>
  
  <p>What I read is that it should be possible to create a function in Javascript and connect the Javascript to a page where you want to show the data on my own website. This would mean that for each page request an API-call is made. Since the requested information only changes once a day maximum this does not sound the most efficient solution.</p>
  
  <p>Can someone advise a better solution? Something into the direction of a similar php or javascript function that does the request on the background, schedule an update and import the data into mysql? If so, what language would be most common. </p>
  
  <p>I need the solution for a Joomla/php/mysql environment </p>