Metabase API Authentication

Get Help
1

Hello,

I’m trying to authenticate using api/session/google_auth via Postman.

But I don’t know what information I am supossed to set to param token .

Can somebody help me?

Thanks

1 Like
2

Solved requesting api/session

3

Hey can you help answer this?
I am trying to use the metabase API to get data into a google sheet (without making the question public)

Can you help?

4

Hey manghat!

Sure.

My problem was that the account I was trying to authenticate was configured to authenticate via Google SSO.

So, first set up an account where you can authenticate using only its email and password.

Then, you need to request Metabase API to authenticate.. like this:

image
image1091×221 16 KB

Finally, use this endpoint to get question results:

image
image1463×537 38 KB

When you make this second request... You must provide X-Metabase-Session header with the value retrived from first request (session endpoint)...Example:

image
image1087×210 16 KB

You need any help, let me know :slight_smile:

1 Like
5

Just to make it easier for everyone, here’s the links:
https://github.com/metabase/metabase/wiki/Using-the-REST-API
https://github.com/metabase/metabase/blob/master/docs/api-documentation.md

2 Likes
6

Thanks flamber :slight_smile:

7

Thank you Gustavo!

1 Like
8

Hey Gustavo,

Would you mind sharing the actual app script code? :see_no_evil: I am a mood developer and have been trying to do a URL request, but it has not been working.
This is what I tried :

function myFunction() {
  var url = "https://metabaseurl.com/api/session";
  var headers = {
             "contentType": "application/json",
             "body":{"username": "email", "password": "password"}
             };

  var response = UrlFetchApp.fetch(url, headers);
  var text = response.getResponseCode();
  Logger.log(text);
}

If it understand correctly, i need to get this response and then submit another request for that specific query I want the data of. I am unable to get a response from the above code on app script. :frowning:

PS: also, what happens if I want to use some filters for the same query?

9

@manghat I’m pretty sure sending body inside of headers is not actually seen as the body, but rather as a header called body.
Most other frameworks calls it payload - but I don’t know what “mood” is, perhaps you should link to that framework/language.

The best way to learn the API, is to just use Metabase while having your browser developer Network-tab open and looking at the request, and what data is being send/received.

10

Hey @manghat,

Do you still need help?

Sorry for the delay to answer…

My account was linked to my last company email and I left there before the July 12th (when you answered asking for help). So I was not able to receive any notification.

Regards,

Gustavo