Question:I have been trying to learn how to use the Sheetdb api today seems easy but was wondering how would I take the sheets data and insert it to a mysql table. Like how would I do it and what would I need. Here is code in the controller right now:
So the data I get back looks like and array of objects so how would I insert this data to and existing empty mysql table? Any and all suggestions are appreciated. If you wish to recreate the whole project here is a link to a video for the initial setup https://www.youtube.com/watch?v=qaWc7Nlt2EE.
Answer:Hello I an attaching snippet
If you have better answer, please add a comment about this, thank you!