urlfetch Questions
5
Solved
I'm trying to POST to a web service that is expecting to get JSON as payload using Google Apps Script. I'm using the following code:
var options =
{
"method" : "post",
"c...
Serviette asked 4/6, 2012 at 20:57
1
Trying to scrape some classes from a website, to compile a spreadsheet report. I've only used Importxml briefly for common sites, which i have made work. However, how can we address cases where we ...
Earl asked 27/10, 2022 at 2:22
1
In Python I use as headers the "Request Headers" that are in the request captured using the browser's developer options and it works fine.
I tried the same with Apps Script, but UrlFetchA...
Georgeanngeorgeanna asked 28/9, 2022 at 15:11
2
Solved
I'm getting an error response from the API that I'm using, but Google scripts seems to truncate the message. How can I see the full message in Google scripts?
This is the message:
Request failed ...
Acidify asked 19/8, 2016 at 10:5
4
Solved
On Google App Engine (GAE) written in Python.
I am trying to issue an http post to cloud-speech-to-text api and using URI audio source (Google Cloud Storage Bucket Objects).
I am using the follow...
Artery asked 25/5, 2019 at 7:17
1
I am getting the following error in my Google sheet:
Service invoked too many times for one day: urlfetch
I know for a fact I am not making 100k calls, but I do have quite a few custom functions i...
Corrinecorrinne asked 15/11, 2019 at 21:38
1
Solved
I've been using ImportHTML to draw MLB stats from this link without issue: "https://widgets.sports-reference.com/wg.fcgi?css=1&site=br&url=%2Fleagues%2FMLB%2F2021-standard-battin...
Stedt asked 1/6, 2021 at 13:57
1
Solved
I want to retrieve tasks in a specified status from a list in Clickup but I keep getting an empty response.
Resources - https://jsapi.apiary.io/apis/clickup20/reference/0/tasks/get-tasks.html
In th...
Huesman asked 2/3, 2021 at 14:47
4
Solved
I have the following code in Google Apps Script which retrieves CSV data from a webpage via HTTP using basic authentication and places it into a spreadsheet:
CSVImport.gs
function parseCSVtoSheet(s...
Stinking asked 10/12, 2020 at 11:40
2
Solved
This SO answer correctly explains that since the require Node/JS library is not supported by Google Apps Script, the following code changes must be made to get Stripe to work properly in a GAS proj...
Cult asked 21/7, 2020 at 11:5
2
Solved
I created function in Google Apps Script, that works well when I run it in Google Apps Script. Output data returns to Google Sheets.
function testFunction11() {
var rng = SpreadsheetApp.getActive...
Freeliving asked 10/2, 2019 at 11:6
1
Solved
I have a .tsv file from a tool and I have to import it the Google Sheet (nearly) real-time for reports. This is my code for importing:
function importBigTSV(url) {return Utilities.parseCsv(UrlFe...
Trench asked 23/5, 2020 at 10:8
4
Solved
Is there any way to catch the exception from UrlFetchApp.fetch?
I thought I can use response.getResponseCode() to check the response code, but I'm not able to, for e.g when there is 404 error, the...
Amphibology asked 30/7, 2012 at 9:28
4
'www.mysite.com/mySecretKey1' redirects to 'www.othersite.com/mySecretKey2'
in G.AppsScript:
var response = UrlFetchApp.fetch("https://www.mysite.com/mySecretKey1");
var headerString = response...
Octane asked 24/11, 2014 at 5:3
2
Solved
Whenever I request an external URL using urlfetch on GAE I get the following warning:
WARNING 2012-03-16 15:37:21,474 urlfetch_stub.py:428] Stripped prohibited headers from URLFetch request: ['Con...
Stopper asked 16/3, 2012 at 15:41
2
Solved
Trying to grab data from a website using Google Apps Script to put it directly into a spreadsheet. The fetch does not seem to be working, where the Python requests equivalent works just fine.
Pyth...
Sinkhole asked 12/5, 2019 at 12:13
2
Solved
I am trying to run a MongoLab (REST based access to MongoDB) query via Google Apps Script. The URL is generated from the logger is shown below
https://api.mongolab.com/api/1/databases/abcd/collect...
Wivern asked 7/12, 2012 at 2:5
0
I need to return some data from a RESTful API service that is hosted on a non standard port 9091. I am using the following as a test harness:
var options = {
'method' : 'GET'
};
var result = U...
Gaberones asked 18/12, 2018 at 11:43
1
Solved
Solved
Thanks to Dimu Designs for helping out.
The following works.
function myFunction() {
var url = "https://api.fortnitetracker.com/v1/profile/pc/Ninja"; var apiKey = "xxx-xxx-xx...
Eohippus asked 18/8, 2018 at 10:58
2
I would like to use urlfetch to populate a spreadsheet with page data but the URL that I am trying to use is coming back with an error as an invalid argument. I think the problem is that I am using...
Punster asked 29/8, 2012 at 17:59
2
Solved
I'm looking to call UrlFetchApp.fetch() based on user input on a sheet but nothing happens. No errors, just silently ignores the call. Same goes for MailApp.sendEmail() and GmailApp.sendEmail()
Th...
Fitz asked 29/6, 2015 at 9:45
5
Solved
GAE - AppEngine - DeadlineExceededError: Deadline exceeded while waiting for HTTP response from URL:
I have a Google AppEngine application which runs great on my local machine. The app posts a image (from a url) to my facebook wall. However, when I deploy it to Google's servers, I get
an error:
...
Ploughshare asked 24/10, 2012 at 14:44
1
Solved
I would love to scape data from this website: https://finviz.com/screener.ashx?v=141&f=sh_avgvol_o500,sh_curvol_o2000,sh_price_u50&o=-volume
I want to scrape the whole table. I tried using...
Gyniatrics asked 26/9, 2017 at 1:55
4
Solved
I want to open a HTTPS connection in a Google App Engine app using the URLFetch service. To be able to verify the SSL certificate of the server my app is talking to, I am using my own keystore file...
Helvetic asked 24/10, 2012 at 3:12
2
I use the UrlFetchApp to send the user and pwd (method POST). After get the cookie, and use in other request (method GET). But this new request not working, I think that this cookie not has correct...
Depressor asked 14/12, 2014 at 22:5
1 Next >
© 2022 - 2025 — McMap. All rights reserved.