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-15 00:46:10Z

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, 2014 at 0:46

answered Nov 15, 2014 at 0:37

Steef Gregor

5442 gold badges7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user3570187 Over a year ago

you are missing the flatten=TRUE which is quite important for the nested json objects.

Steef Gregor Over a year ago

Answer modified, copy it simply to the end of fromJSON function.

user3570187 Over a year ago

it is only giving 1 page information after i do the rbind.

Steef Gregor Over a year ago

The for loop work correctly. The mistake is in the last line of your code. Try something like rbind(mydata) or provide reproducible data.

user3570187 Over a year ago

yes it was able to retrieve the pages but it is not rbinding them.

Collectives™ on Stack Overflow

How to pass a variable in url in fromJSON command

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related