I would like to import a csv file to my Carto account using R. I know the csv has been generated, and I'm able to save it in other locations.
Running the code to upload this file to Carto appears to be successful (see success message below), yet I'm unable to find/retrieve the csv in my carto account.
Here is the code I'm using to import my csv:
apiurl <- "https://"MY ACCOUNT".carto.com/api/v1/imports/?api_key= "MY API KEY" inputFile <- "MyFile.csv" writeLines(inputFile) resp<-POST(apiurl, body=upload_file("MyFile.csv"), encode="multipart") content(resp)
I'm pretty sure the code I'm using is correct, since it generates this message:
content(resp) $item_queue_id  "(a unique alphanumeric string) " $success  TRUE
... but where is my csv?