Hi everyone,
Instead of me spending another 6 hours trying to be a detective, I thought I would ask here instead :)
I'm basically trying to create a table with all the countries rom the restcountries.com api. I need this in a table that stays up to date, and the table will link with several important other tables in my DB. Im working on a language application, so this is key for me to nail.
I had initially looked at old documentaiton and youtube videos explaining how to use loop to iterate through items, however, I noticed that there was a new functionality called 'Add bulk Records'. Only issue is that it's one video on a few minutes explaining one use case that does not fit mine.
Has anyone used this 'Add Bulk Records' and knows how I should set it up with my API so my table stays up to date with the API (or whatever is best practise).
Please help me save another 6 hours digging the internet, hehe
