DNS Error

[Taco1175]

Hi @bplmp! This is wonderful!

I have set up my variables in Script Properties (legacy editor), but am still getting a DNS error of: Exception: DNS error: http://nullapi/session. This makes me think for some reason it isn't referencing the properties I've set up. Any thoughts?

Thanks!

[wclock]

Hey @bplmp I'm having the same issue at @Taco1175

[MaxBrevini]

Hey the same happens here. Any solution yet?

[Daviswalker-Avo]

Any solution on the DNS error? It seems to be coming from the function "getToken"

[Eliagandolfi]

I had the the same issue because I didn't realize my domain is of the form https://mycompany.metabaseapp.com/ instead of https://mycompany.metabase.com/

it may not be this issue thou, but the script works now great for me

[jrolom]

Hey @Eliagandolfi - where did you change the domain in the script? Thank you

[Taco1175]

You change this in the script properties itself, not in the code from what I remember.

On Thu, Sep 8, 2022, 7:38 PM Joan Rojas @.***> wrote:

Hey @Eliagandolfi https://github.com/Eliagandolfi - where did you change the domain in the script? Thank you

— Reply to this email directly, view it on GitHub https://github.com/bplmp/metabase-google-sheets-add-on/issues/4#issuecomment-1241370456, or unsubscribe https://github.com/notifications/unsubscribe-auth/AVHK3M6F3SVKJCXKSNKGJDLV5KBITANCNFSM5CILZGOQ . You are receiving this because you were mentioned.Message ID: @.***>

[pjatx]

This happens if you forget to set the required script properties (variables) in the Google Apps Script settings. Missed that step and was defining them in the code and this fixed it for me.

[noelwar]

Can someone help me and tell me where exactly I need to change the env variables? And I can't seem to get to the legacy viewer as well.

[pjatx]

@noelwar

[noelwar]

You're amazing. Thank you so much!

On Thu, 2 Feb 2023, 7:28 pm Philip Johnson, @.***> wrote:

@noelwar https://github.com/noelwar [image: SCR-20230202-b12] https://user-images.githubusercontent.com/5004634/216344366-640c2686-c07f-4de5-852e-5178b28bccb6.png

— Reply to this email directly, view it on GitHub https://github.com/bplmp/metabase-google-sheets-add-on/issues/4#issuecomment-1413788780, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARRZUDVNNDBRJ7XJFIPOCE3WVO4PDANCNFSM5CILZGOQ . You are receiving this because you were mentioned.Message ID: @.***>

[pjatx]

@noelwar anytime! This got me back in the day as well : ) Happy I could help.

[isaberamos]

Hi @pjatx Isn't the token value generated automatically? If not, can you explain how you got the token value?

[pjatx]

@isaberamos I believe you need to generate an api token via metabase

[isaberamos]

@pjatx It worked! Thanks!

[isaberamos]

Hi guys, is it possible to update this data extracted from metabase in real time without import the question?

[sunilkumar19-ai]

I was getting Exception: DNS error: http://nullapi/session while connecting Metabase to google sheets via Appscript . How can I overcome it ?