jsonlite::stream_in throwing error in R Error in (function (..., row.names = NULL, check.rows = FALSE, check.names = TRUE

Question

It was all working fine but then suddenly one day I started getting this error. I've a json field in DB table and i'm trying to parse it

ahoy_prop <- jsonlite::stream_in(textConnection(ahoy_events_acc$properties, encoding = "UTF-8"))

But its showing this error now -

Error in (function (..., row.names = NULL, check.rows = FALSE, check.names = TRUE,  : 
  arguments imply differing number of rows: 1, 0

Answer 1

It's hard to tell without an example text, but here's a way to find which of the elements is causing a parsing problem.

vec <- c('{"a":[1],"b":[2,3]}', '{', '')
out <- lapply(vec, function(z) try(jsonlite::stream_in(textConnection(z, encoding="UTF-8")), silent=TRUE))
#  Imported 1 records. Simplifying...
#  Imported 0 records. Simplifying...

which(sapply(out, inherits, "try-error"))
# [1] 2
vec[2]
# [1] "{"