#Client ID and Client Secret were retrieved from the online explorer I created a tokens.csv file in the structure: "RefreshToken","AccessToken"īelow is my script that retrieved customer data from the QBO api sandbox. Some of this, like storing tokens in a csv, is not best practice, just a band-aid to test the code. I did get this "functional," but it is by no means good code. My ultimate goal for this project is for the script to automatically run on a nightly basis, connect to the API, and ETL the data into a Relational Database for reporting/analytics purposes. For QuickBooks Online, the redirect URL can be the localhost in the development environment, but if I want to connect to the production company(my company) data I will need a https redirect URL. Somehow, in R, I am not getting the access token and refresh token.Īnother concern, is that I am currently trying to connect to a development environment. There is also an Oauth 2.0 playground on Intuit Developer. I have connected to the API via Postman and it generates an access token allowing me to execute queries like the GET request in my code. httr-oauth file that is generated is filled with 284 rows of 32 characters. However, when I execute the GET command, it returns: Error in self$credentials$access_token :
#QUICKBOOKS ONLINE LOGIN THROUGH FRAME CODE#
When run the code above through QBOtoken, I go through the whole Oauth2.0 "dance" and get the response: Waiting for authentication in browser. GET(" * from Payment", config(token = QBOtoken))
Redirect_uri = " QBOtoken <- oauth2.0_token(endpoint = endPoint, Here is what I have so far: library(httr)ĮndPoint <- oauth_endpoint(request = NULL,
I am trying to access the QuickBooks online API via R.
0 kommentar(er)
