Google apps script urlfetch encoding URL

google-apps-script urlfetch
Pigcowpig picture Pigcowpig · Aug 29, 2012 · Viewed 24.4k times · Source

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 characters in the URL that are being misinterpreted (e.g. quotation marks and parentheses).

I have tried to encode the URL with the command below but I am assuming that I am double encoding some of the characters and that is causing a problem.

var encodedURL = encodeURIComponent(pageURL)

Answer

TMan picture TMan · Aug 29, 2012

Try using

baseURL + encodeURIComponent(parameterString)

Where you include the parameters you're passing to the base URL you are querying as the value passed to the encodeURIComponent function. This post may be of use to you:

Encode URL in JavaScript?

If you encode the entire URL, like it looks like you are doing above, you're encoding more than just the parameters, which I assume would be where your problem lies.

Related questions

How to use UrlFetchApp with credentials? Google Scripts

I am trying to use Google Scripts UrlFetchApp to access a website with a basic username and password. As soon as I connect to the site a popup appears that requires authentication. I know the Login and Password, however I …

Read More
How to catch UrlFetchApp.fetch exception

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 script not continue and …

Read More
How to send a JSON payload with UrlFetchApp service?

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", "contentType" : "application/json", "headers" : { "Authorization" : "Basic <Base64 of user:password&…

Read More