Uploading API data to SQL database in R


I am trying to export data obtained from an API to a sql server. I found this guide that encourages to first save down the API data as a csv then import into SQL but I think this is a long winded approach.

I currently have attempted to use RMYSQL package to connect to sql server and then dbwritetable to insert the data into the sql but this is throwing an error. Are there any other approach to achieve this?

Thank you

RMySQL is an old package that has been superseded by RMariaDB

I would say, try with the new package and if you have a specific problem, please post a proper REPRoducible EXample (reprex) illustrating your issue.

1 Like

Thank you. I’ll give that a go!

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.