python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - urlfetch

Returned Error 400 Request failed Apps script

I have this code that I use to create PDF from spreadsheets and I modified it to use it in another spreadsheet and now I'm getting this error. Exception: Request failed for https://docs.google.com ret...
test-img

Vivian Roberts

google-apps-script

pdf-generation

urlfetch

Votes: 0

Answers: 1

Latest Answer

Change this: var url = 'https://docs.google.com/spreadsheets/d/'+sheetName+'/export?exportFormat=pdf&format=pdf' To this: var url = 'https://docs.google.com/spreadsheets/d/'+ss2.getId()+'/export?...
test-img

Emel

google sheet importhtml with click show more

I'm trying to import NHL data from https://www.espn.com/nhl/stats/player/_/view/skating/table/offensive/sort/goals/dir/desc The problem is that I can't import the 733 rows because of a "Show more...
test-img

Vincent Coulombe

google-apps-script

google-sheets

web-scraping

google-sheets-formula

urlfetch

Votes: 0

Answers: 2

Latest Answer

You can extract main informations with this script function hockey() { var url = 'https://site.web.api.espn.com/apis/common/v3/sports/hockey/nhl/statistics/byathlete?region=us&lang=en&conten...
test-img

Mike Steelson

Workaround for 403 error when using URLFETCH with Google Apps Script (external website)

I've used sof for many years (I almost always found all my answers!) but I'm quite stuck for the current project so this is the first time I post here. :) I want to get the product price from www.herm...
test-img

hykth

google-apps-script

web-scraping

http-status-code-403

google-custom-search

urlfetch

Votes: 0

Answers: 0

Twitter Api v1.1 post multipart request (append endpoint) from Google apps script always gives a error

In the below function, I got an error response from Twitter as "Bad request". //param1 file === DriveApp.getFileById() //param2 init === returned object of initTwitterUpload function //param...
test-img

Praveen Murugan

api

google-apps-script

multipartform-data

twitter-oauth

urlfetch

Votes: 0

Answers: 1

Latest Answer

I found an answer. Thanks to me, Replace this appendTwitterUpload function with the one in the question and it will work great. function appendTwitterUpload(file,init,service) { var options = nu...
test-img

Praveen Murugan

Posts

Questions

Blogs

Jobs