Seeding Laravel DB from external API

user_15262440 0
Viewed 301

I'm new to Laravel. Maybe my questions are a little bit silly... Sorry...

The goal: There are some API resources and I need to take some selective data from them (It will be needed to make extra API queries from data which I already got before to get full sets of required values) and fill my DB tables with it (some as one to many, some as many to many).

The problem: What Laravel tools do I need to use to reach this goal? Is it factory, seeder or somewhat else? In addition I don't understand where I have to write the code for getting data from an external API and where (in terminal manually?) I have to initiate my DB tables filling.

Maybe someone could at least advise what to learn in the Laravel official documentation at first or some helpful reference to some article from which I will be clear how this process may be implemented in Laravel. I mean the tools' set and order to use them. Not the finished code implementation of course.

I will be grateful for any help. Thanks. Sorry for my non native English.

laravel php
1 Answers

Well, there are multiple ways of achieving what you want:

  1. One is to create a command where you are going to write code to fetch this data (using curl or any similar way). And then you manually run the command when you want with whatever arguments you want.
  2. Other one is to use the previous step and schedule it to run in a desired time with desired arguments.
  3. Other possible way is, if the external API can send data to a specific URL when some action occurs in that system, then you can create a normal Route and the API should point to this Route in your Laravel. It will be specific and only work for this API.
  4. Other one is to fetch data based on an event. Let's say that, if a user register, when this is successful, you are going to fetch User info from an external API using their email (let's say you want to get a profile picture from an API and the only way to get the user picture is sending the user's email). You can do so using Events.

There are more ways, but if you don't give too much context, then this is what I can share with you !

user_19988010
Related