I just started to use MetaBase last week. Yet I managed to retrieve data via API from R.
But now I am facing to problem of the limit of rows that the API returns (10.000). Is there a way to change this limitation?
Once connected in my metabase session (metabase_session) the piece of code used to get the results from a query is:
data <- list( ‘database’= DB_ID, ‘native’= list(‘query’= query), ‘type’= ‘native’)
data_json <- jsonlite::toJSON(data, auto_unbox=TRUE)
req <- httr::POST(paste0(metabase_session$base_url, "/dataset",""), httr::add_headers( "Content-Type" = "application/json", "X-Metabase-Session" = metabase_session$token ), body = data_json )
I have tried to add in data_json ‘limit’=15000 but didn’t manage to get more than 10k results.
Any help would be apreciated,