hello. I still can’t get R studio to connect to windsor.ai . Can anyone help me?
Hello, sure, what is the problem?
I was working with Niklas yesterday.
API key not valid… but it is.
‘api_key validation failed’
Ok, let me check quickly
require("httr") require("jsonlite") data_req <- GET("https://api.windsor.ai/windsor_attribution/public/conversions";, add_headers( "Authorization" = "Bearer API_KEY") ) journey_data <- content(data_req, "text") journey_data_json <- fromJSON(journey_data, flatten = TRUE) journey_data_df <- as.data.frame(journey_data_json)
just want to get that journey data frame… stuck at that point.
thank you for your help.
I’m still checking
What data are you trying to use in R?
right now… just trying to work my way through the tutorial.
eventually, calculate the NPV of all the different customer types and adjust the code to optimize for
But I can’t get either tutorial to work. - https://www.r-bloggers.com/2021/04/windsorair-package-foraccessing-windsor-ai-api-from-r/
Ok I think the first one you linked is outdated, I am still verifying if it works here though
outdated means that there is a new article somewhere with updated code that does work?
No I think we have to update it, the URL structure changed and was missed there
“data_req <- GET("https://api.windsor.ai/YOURUSERNAME/YOURUSERNAME_attribution/public/conversions? api_key=API_KEY")”
The above works here
extra " ?
No I think that was added by the chat here
I updated the article, it might be easier to copy from there
data_req <- GET("https://api.windsor.ai/USER_NAME/USER_NAME_attribution/public/conversions? api_key=API_KEY")
I got it. thanks.
may I ask your name? I’ve talked to 2 people so far
Sure, this is Octavian
thank you very much for your help.
some questions in general.
By the way we have a call scheduled in 30 minutes
we are talking… I thought it was with someone else.
Yes it was with Matthias, but he had to disconnect today
journey_data — what are my other options there?
Do you mean regarding filtering the conversions, for instance by date?
journey_data give me a predetermined set of columns… but what is the full list of columns to pick from?
Those are all the available columns for the journeys, for all the dates that we have in the database
I can help you to build queries to select subsets of those if you plan to run it often, and we can load more
days back if needed
OK. thank you.
How would I adjust this code to work too?
By the way there are more API details at API Documentation - Data and Marketing Attribution Modelling | Windsor.ai
right now, I have 7 days of data loaded in on my free trial but how many days will load with the $99/mo
Around 1 year is usually not a problem, it depends a bit on the data size mainly
Will you update the code on this article and just email it to me please? https://www.rbloggers.com/2021/04/windsorair-package-for-accessing-windsor-ai-api-from-r/
1 year of data takes about a day to load when I upgrade?
It again depends on the data size and the google APIs but I think it should be feasible in a day yes
I’ll let you take a breather now. I will prep for our call. This stuff is actually cool.
Sounds good! I think the R package has some dependencies that were just updated and it should be
updated accordingly, I will have a quick look!