DNS error: http://undefined (line 215, file "Code")

[kaner1178]

I am getting the above error if I try to debug the code in the script editor. Any ideas?

Line 215 is copied below:
var jsondata = UrlFetchApp.fetch(url, fetchOptions);

[otaviobonder-deel]

Me too.

The script runs fine when I open the spreadsheet, but I'm trying to create a button to run it and I'm getting the same problem.

[jackcarey]

I've only see this error when accidentally forgetting the import URL. Are you definitely passing a URL to importJSON?

[kaner1178]

Thanks for getting back to me, but I was able to get it to work!!

…

On Thu, Jun 14, 2018 at 7:23 PM jackcarey ***@***.***> wrote: I've only see this error when accidentally forgetting the import URL. Are you definitely passing a URL to importJSON? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#78 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/Ak8RmKr70FL76rzl83-APBvo8Ud99Jnwks5t8vBggaJpZM4TkDas> .

[venturaEffect]

I've the same issue.

I'm running the script. Tried to put the url from this formula:

=transpose(importjson(concatenate("https://maps.googleapis.com/maps/api/geocode/json?address="&B2&"mountain","&key=API-KEY"),"/results/geometry/location/lat","noHeaders"))

like this:

var jsondata = UrlFetchApp.fetch("https://maps.googleapis.com/maps/api/geocode/json?address="&B2&"&key=API-KEY", fetchOptions);

But get this error:

ReferenceError: "B2" is not defined. (line 215, file "ImportJSON")

Any suggestion?

Really appreciate

[venturaEffect]

Thanks for getting back to me, but I was able to get it to work!!
…
On Thu, Jun 14, 2018 at 7:23 PM jackcarey @.***> wrote: I've only see this error when accidentally forgetting the import URL. Are you definitely passing a URL to importJSON? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#78 (comment)>, or mute the thread https://github.com/notifications/unsubscribe-auth/Ak8RmKr70FL76rzl83-APBvo8Ud99Jnwks5t8vBggaJpZM4TkDas .

How did you get it?

[yamato0010]

Hi, I am still having the same issue. How do you guys solve it? Highly Appreciated.

[evenflowvisualart]

Me too.

The script runs fine when I open the spreadsheet, but I'm trying to create a button to run it and I'm getting the same problem.

Guys, any luck? I want to add button too. Thanks.