Importing json with jsonlite results in error

Asked Jun 28 '18 at 11:42

Active Jun 28 '18 at 13:13

Viewed 485 times

I'm simply trying to read a file.json with the read_json() function from the jsonlite package.

I get this error:

mydata <- read_json(path="file.json",simplifyVector = TRUE)
Error in parse_con(txt, bigint_as_char) : parse error: trailing garbage
          custom_questions_json": "" } {   "id": 15730670,   "lodged_a
                     (right here) ------^

edited Jun 28 '18 at 13:13

codeteq

1,502
7
13

asked Jun 28 '18 at 11:42

delcast

What are the contents of the file? – Evan Knowles Jun 28 '18 at 11:45
post the json file. It seems it's not valid! – codeteq Jun 28 '18 at 11:45
@codeteq I really can't. It has private info. – delcast Jun 28 '18 at 11:47
then remove all whitespace from the json. not within the content of course. – codeteq Jun 28 '18 at 11:47
@EvanKnowles just logs. I think the problem could be that the type of info stored varies type and structure. – delcast Jun 28 '18 at 11:48
@codeteq how can I do this in R please? – delcast Jun 28 '18 at 11:48
1

I refer you to a post on SO, have a look: https://stackoverflow.com/questions/26519455/error-parsing-json-file-with-the-jsonlite-package/26522000 – codeteq Jun 28 '18 at 11:49

Importing json with jsonlite results in error

0 Answers0