Goodreads Developers discussion

Hi everyone,

I'm not very familiar with APIs or developing, so although my question is basic, I'd appreciate any assistance as I'm having trouble finding a solution for it myself. I'm trying to return a list of all an author's works and am having trouble with the limit of 30 results per request. I'm trying to make this list in Google Sheets with the following:

=importXML("https://www.goodreads.com/author/list......", "//GoodreadsResponse/author/books/*/title")

and get the first 30 results. I know I can add "&page=2" to the end to get the next page, but is there a way to either:

1) return a higher number than 30 results, or
2) reference the total number of books in the XPath query to get the number of pages needed from there?

Any help would be appreciated.

Thank you.

Try to add: per_page=50 key to url - in some requests it is working

Oleg wrote: "Try to add: per_page=50 key to url - in some requests it is working"

Thanks Oleg!