How to pass a variable in url in fromJSON command

Question

I am trying to pass a variable in the url and flatten using jsonlite, but i am not able to pass variable pages using the loop. How do i loop using FromJSON?

pages<- list()
for(i in 1:20) {
mydata <- fromJSON("https:www.example.com/page="+i+"&access_token=xyz", flatten = TRUE) 
}
filings <-rbind.pages(pages)

Steef Gregor · Accepted Answer · 2014-11-15T00:46:10.593

1

What about this?

pages<- list()
for(i in 1:20) {
  mydata <- fromJSON(paste("https:www.example.com/page=", i, "&access_token=xyz", sep = "+"), flatten = TRUE)
}
filings <-rbind.pages(pages)

edited Nov 15 '14 at 00:46

answered Nov 15 '14 at 00:37

Steef Gregor

544
1
7
21

you are missing the flatten=TRUE which is quite important for the nested json objects. – user3570187 Nov 15 '14 at 00:43
Answer modified, copy it simply to the end of fromJSON function. – Steef Gregor Nov 15 '14 at 00:47
it is only giving 1 page information after i do the rbind. – user3570187 Nov 15 '14 at 00:47
The for loop work correctly. The mistake is in the last line of your code. Try something like rbind(mydata) or provide reproducible data. – Steef Gregor Nov 15 '14 at 00:51
yes it was able to retrieve the pages but it is not rbinding them. – user3570187 Nov 15 '14 at 00:56

How to pass a variable in url in fromJSON command

1 Answers1

Linked