This is somewhat a suitescript related question is there a way to analyze netsuite Data with R

I think if you just set up an ODBC connection to RStudio you can pull the data in and manipulate it

I may need to buy an ODBC driver then

Yeah i believe you need a SuiteAnalytics connect license to get access to the ODBC Connection

Ill check with CDATA - maybe theirs is cheaper

If you want a complicated way around it, you could write a RESTlet in netsuite to run a query and return the results. Then make a HTTP call from your R application to the restlet to retrieve the data. Could potentially write the RESTlet in a way that just consumes a SQL query and runs it.

i did that but im getting an invalid login attempt any idea why

It could be a number of things really. I guess for starters, make sure you have your RESTlet deployed. Youll need to generate access tokens. So create an integration for your RESTlet and get the consumer key and secret. Then create your user access tokens and secret. That's for OAuth 1. Youll also have to make sure youre using SHA-256 and not SHA-1 You could test the connection in Postman first.

Other options would be the REST or SOAP APIs. I'm not familiar enough with R to know what might be the easiest to work with. The benefit of the Restlet is that you get to customize the data format coming back to you.