Retrieving data from AT&T RingCentral using REST connector

[mikegrattan]

I am having some issues getting the REST connector to pull the data I'm looking for on RingCentral. I've set up a REST application in the development console on ringcentral.com, and they provided the following:

• Client ID
• Secret
• JWT credential
• URL to query

The REST connector in Qlik, however, just has User ID and Password in the credentials area, so I am unsure how to proceed. Is there a way to use Client ID/Secret/JWT in the Qlik REST connector? Perhaps there are query parameters that I can use to pass this information to the API (cannot find this info on their site). 

Thanks for any guidance!

[marksouzacosta]

Hi @mikegrattan,

For REST APIs, I always recommend using Postman before going to Qlik. This will make your life a lot easier. If your parameters work in Postman, it will work in Qlik.

In any case, usually in Qlik Rest Connectors Client ID is the User ID and Secret is the Password.

Regards,

Mark Costa

[mikegrattan]

It seems like the problem might be OAuth. I was reading more about the REST connector in Qlik at it appears that OAuth is not supported. Unfortunately, the RingCentral REST API only accepts 3-legged OAuth or JWT, which is classified as another type of OAuth. 

What are my options at this point?

Update: I read here that OAuth is not supported: https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/REST-c...

and then I read here that OAuth is supported at least for the two examples given (Facebook and Linkedin): https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Create...

So, I'm wondering if the JWT flow in RingCentral might work even though it's an OAuth flow? I'll try it as soon as I get some more time to play with it.

[mikegrattan]

Hi Mark,

I worked with RingCentral tech support and got the API call to work in Postman. Now, I think I need help with getting it to work in the Qlik REST connector. Here are the parameters I need to set up:

Body: (in Postman it's set up for x-www-form-urlencoded)

Key: grant_type
Value: urn:ietf:params:oauth:grant-type:jwt-bearer
Key: assertion
Value: JWT token

Headers:

Key: Authorization
Value: Basic + base64_encoded ClientID +":" + Secret
Key: Accept
Value: application/json
Key: Content-Type
Value: application/x-www-form-urlencoded

I don't see a way to add keys to a body in the Qlik REST connector, so I added those keys to the Query Params section.

I added request information to the Request Body, such as:
{
"grouping": {
"groupBy": "CompanyNumbers",
"keys": []
}

I set authorization to Basic, but left user name and password blank, as those are passed in the Authorization key.

Everything else in the connector is left at default values. 

I'm getting the following error:

HTTP protocol error 401 (Unauthorized): 'Bearer' authentication schema provided by the web-service is not supported or your credentials are not valid.

[marksouzacosta]

Hi @mikegrattan ,

For your x-www-form-urlencoded can use the following:

A little more zoom on the body part:

Regards,

Mark Costa