Can anyone figure out Domo?

[cornfeedhobo]

I have been trying a few variations and can not figure out how to properly setup the service for Domo.

https://developer.domo.com/docs/authentication/overview-4

[oshliaer]

Did you try connect thru curl? I can't do that.

It returns

{
    "status": 401,
    "statusReason": "Internal Server Error",
    "path": "/v1/users",
    "message": "com.domo.bedrock.service.exception.UnauthorizedException: Full authentication is required to access this resource",
    "toe": ""
}

[cornfeedhobo]

Oh, yeah, maybe I should have mentioned that first, I can do this just fine with curl. Getting a token is easy, as are subsequent queries.

[oshliaer]

How can I get subsequent queries? In my attempts

> source AT=access_token
> curl -v -H "Authorization:'bearer $AT'" "https://api.domo.com/v1/users"
...
401
...

I'll see if it's possible to receive a token without an authorization with this library..

[cornfeedhobo]

Yeah their documentation isn't great. Here is a working example (you'll need jq installed, but can adapt it):

export DOMO_OAUTH_ID=...
export DOMO_OAUTH_SECRET=...
export DOMO_TOKEN="$(curl -u "$DOMO_OAUTH_ID:$DOMO_OAUTH_SECRET" "https://api.domo.com/oauth/token?grant_type=client_credentials&scope=data%20user%20dashboard" | jq -r .access_token)"
curl -H "Authorization: bearer $DOMO_TOKEN" "https://api.domo.com/v1/datasets"

[cornfeedhobo]

I should probably also mention that I have tried using .setParam('grant_type', 'client_credentials') as well as using a custom handler like FitBit, but those didn't work either.

[oshliaer]

@cornfeedhobo

Ok. I have a patch for this. But I didn't testing this with rfc6749's capability.

Will you use it as is?

[cornfeedhobo]

Is this something you'd be committing to master? What's the patch?

As for giving it a try, sure. But I have no idea how you use a branch of a library if that's what you are looking to do. Google scripts is pretty new to me. I'm just used to normal development...

[oshliaer]

@cornfeedhobo

This lib does not support Client Credentials Grant yet.

As can you see from Setup you may use /dist installation instead linking the library. Do it

1. Unbind the library from your project
2. Create a gs file with name Underscore.gs. Save the content from ./master/dist/Underscore.gs to there.
3. Create a gs file with name OAuth2.gs. Save the content from the patch to there.
4. Update your code with Domo

It works fine for me https://script.google.com/d/1_cTGT4xUjacppxhfbF-wXuF0tFFk8fYjM1XXIWqGSBVK6sEDK1luYpmb/edit?usp=sharing

[cornfeedhobo]

@oshliaer This looks good to me. Did a small scan through the diff, and a test worked. Thanks! Any hope this will make it to master and a new release pushed?

[oshliaer]

@cornfeedhobo

I opened the new issue #82. I'll add Domo API code as an example to there.

It seems that the current issue can be closed.

Cheers!

[oshliaer]

@cornfeedhobo there are some examples

POST request

var url = 'https://api.domo.com/v1/users';
    var response = UrlFetchApp.fetch(url, {
      method: 'post',
      'contentType': 'application/json',
      headers: {
        Authorization: 'Bearer ' + service.getAccessToken()
      },
      payload: JSON.stringify({
        'email': email,
        'role': 'Admin',
        'name': 'Name Name',
      })
    });
    Logger.log(response.getResponseCode());
    var result = JSON.parse(response.getContentText());
    Logger.log(JSON.stringify(result, null, 2));

PUT request

var url = 'https://api.domo.com/v1/users/' + id;
var response = UrlFetchApp.fetch(url, {
  method: 'put',
  'contentType': 'application/json',
  headers: {
    Authorization: 'Bearer ' + service.getAccessToken()
  },
  payload: JSON.stringify({
    'id': id,
    'role': 'Admin',
    'email': email,
    'name': 'Anonymous',
  })
});
var result = JSON.parse(response.getContentText());
Logger.log(JSON.stringify(result, null, 2));

[cornfeedhobo]

Awesome. I started chipping away last night to put together what I need. Thanks again.

[shashankgaur]

Hi @oshliaer

I tried using the Domo API code for my own API to request token via client_credentials. I did following steps:

1. Removed OAuth2 library from Resources
2. Copied both OAuth2.gs and Underscore.gs files in the project.
3. Added the getService() function as defined in the Code.gs of Domo API.

However, I still get error that getAccessToken is not defined in the function getService? Am I missing something? I am able to use the normal OAuth2 library but can not get a new token using it.

Thank you