argument "owner_id" is missing, with no default

[cklckl48]

Hi How are you and I hope you are doing well

I am executing this example SQL as follow:

intro_ds <- "https://data.world/jonloyens/an-intro-to-dataworld-dataset"
sample_query <- data.world::qry_sql(paste0( "SELECT t.Name, t.Height, s.AssistsPerGame ", "FROM DataDotWorldBBallTeam as t ", "JOIN DataDotWorldBBallStats as s ON t.Name = s.Name ", "ORDER BY s.AssistsPerGame DESC"))
data.world::query(sample_query, dataset = intro_ds
)

But I got Error in sprintf("%s/sql/%s/%s", getOption("dwapi.query_url"), owner_id, : argument "owner_id" is missing, with no default

Do you know how to fix that? I already added data.world::set_config(saved_cfg) and dwapi loaded

Kind regards

[brettandersonddw]

Hello @cklckl48 ,
Thanks for reaching out. This appears to be a bug that was introduced with the latest release (0.3.0) of the dwapi for R, which is used by the data.world package.
We're working on a fix for that, but in the meanwhile using dwapi version 0.2.2 should work for you:

remove.packages("dwapi")
install.packages("https://github.com/datadotworld/dwapi-r/archive/v0.2.2.tar.gz")
[restart R]

library("data.world")
intro_ds <- "https://data.world/jonloyens/an-intro-to-dataworld-dataset"
sample_query <- data.world::qry_sql(paste0( "SELECT t.Name, t.Height, s.AssistsPerGame ", "FROM DataDotWorldBBallTeam as t ", "JOIN DataDotWorldBBallStats as s ON t.Name = s.Name ", "ORDER BY s.AssistsPerGame DESC"))
data.world::query(sample_query, dataset = intro_ds
)

Regards,
Brett & the data.world team