I am trying to write a piece of code for R to fetch data from an api with the following command:
data <- read.csv("https://...../api/dataservice?sql = select * from db where name IN (?)")
The parenthesis are where I need to input 218 different name tags. How can I do this programmatically? It is possible to write down few of them, but over 200 is not possible. Is there a way this? Can I use a character vector containing the names?
sql=DROP TABLE students; --? $\endgroup$