How to get third party api and store into my database

I am working on a project using Laravel-5.8. I have a database with various tables. The source of data to be displayed is from third party apis.

I want to each external api on a table in my database and also do automatic update from time-to-time.

How do I achieve this?

Thank you

Best Answer

Level 88

Well, it's an API, right? You can do the API request to retrieve the data and store it in the database. Guzzle is a good library for that: https://medium.com/laravel-5-the-right-way/using-guzzlehttp-with-laravel-1dbea1f633da

If you want to run it automatically from time-to-time you need to use a cronjob: https://laravel.com/docs/7.x/scheduling

Level 75

Also most api's have instructions on the data retrieval. Most are JSON, but I have seen XML and CSV as well.

Please or to participate in this conversation.