topic Re: Retrieving data from AT&T RingCentral using REST connector in App Development

Retrieving data from AT&T RingCentral using REST connector

mikegrattan — Thu, 17 Oct 2024 22:51:11 GMT

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!

Re: Retrieving data from AT&T RingCentral using REST connector

marksouzacosta — Fri, 18 Oct 2024 15:59:13 GMT

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

Re: Retrieving data from AT&T RingCentral using REST connector

mikegrattan — Fri, 25 Oct 2024 15:02:46 GMT

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-connector.htm

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-REST-connection/Connection-examples.htm

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.

Re: Retrieving data from AT&T RingCentral using REST connector

mikegrattan — Wed, 30 Oct 2024 22:28:26 GMT

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.

Re: Retrieving data from AT&T RingCentral using REST connector

marksouzacosta — Thu, 31 Oct 2024 18:16:02 GMT

Hi @mikegrattan ,

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

A little more zoom on the body part:

Regards,

Mark Costa