The following custom Google sheet function fi...

[Steve_Langert]

The following custom Google sheet function finds the author of a book from Goodreads’ website by passing the ISBN of the book to the function.

Can we do this from within Appsheet?

Is this webhooks?

function GETAUTHOR(ISBN) {

ISBN = encodeURIComponent(ISBN);

var url = ‘https://www.goodreads.com/search/index.xml?key=[MY KEY]&q=’ + ISBN;

var response = UrlFetchApp.fetch(url).getContentText();

var xml = XmlService.parse(response);

var root = xml.getRootElement();

var author = root

.getChild(‘search’)

.getChild(‘results’)

.getChild(‘work’)

.getChild(‘best_book’)

.getChild(‘author’)

.getChild(‘name’)

.getValue();

return author; }