Hi Folks I want to get an access token & data from the Genesys Purecloud API. I have tried various ways to put the information into the download tool but have not been able to get a token, let alone data! The Genesys DeveloperForum doesn’t mention Alteryx & the Alteryx Community doesn’t mention Purecloud. Attached is my workflow (2018.4). Below are pics of each tool as well as links to the doco that specifies the input, the requests & the JSON response containing the token. Don't know what I am doing wrong, but hope someone out there can spot it 🙂 Susan * Here is my input data (client credentials are deidentified). When I use the real ClientID & Secret & derived Authorization, I get the same DownloadData & Headers as with these dummy values* * These are the steps to base encode ClientID&Secret for the Authorization field* * * * Here is the download tool (I have also tried using the other URL fields from the above text input):* * * Whether I check TokenPost on the Payload tab or not, I get the same result in DownloadData & DownloadHeaders * * * * The DownloadData field contains (contextid varies): {"message":"HTTP 404 Not Found","code":"not found","status":404,"contextId":"5b25a7b0-191d-4b3c-8846-44255f518204","details":[],"errors":[]} * The DownloadHeaders field contains: HTTP/1.1 200 Connection Established Proxy-Agent: Zscaler/6.0 HTTP/1.1 404 Not Found Content-Type: application/json Content-Length: 140 Connection: keep-alive Date: Wed, 20 May 2020 22:33:39 GMT ININ-Correlation-Id: 5b25a7b0-191d-4b3c-8846-44255... * Instructions on URLs, variables and values re:* The API URL (https://developer.mypurecloud.com/api/rest/)* * The requests (https://developer.mypurecloud.com/api/rest/authorization/use-client-credentials.html)* PullGenesysAPIData v02 AlteryxTest.yxmd

Hi Everyone I am posting a solution to my problem in case it helps anyone else out there to use Alteryx to pull Genesys PureCloud data. The attached workflow (2018.4) successfully pulls Client Credential data from our PureCloud instance. The entities and permissions in the Download Data field match the first page of Role data found at https://apps.mypurecloud.com.au/directory/#/admin/directory/rolesV2. Setting up the Download tools with the correct URL, Header & Payload was a process of trying different settings suggested by the Genesys doco & tutorials. There may be many solutions, but this setup worked for me: * Before you can run the workflow, you need to set up an Oauth client for Client Credentials as per https://help.mypurecloud.com/articles/create-an-oauth-client/ * To get the client credential token* Populate the text input tool in the ‘Get access token’ container* Host (URL for Australia): https://login.mypurecloud.com.au/oath/token * Copy ClientID and Secret from the OAUTH client you created * grant_type: client_credentials * Create the Authorization field. Thanks to @Kane Glendenning who helped me populate this correctly:* UrlEncode the Client Secret and Client ID * ‘Basic ‘ before the encoded string * Fill in the Download tool: Note the Payload tab has a* custom HTTP action (which I was unable to pass in as a field for some reason) & * drop down selection of Content-Type * To pull client credential data* Populate the text input tool in the ‘Get data’ container:* HostGet: https://api.mypurecloud.com.au/api/v2/authorization/roles * GetURL: GET /api/v2/users/me HTTP/1.1 * Content-Type: application/json * Create the Authorization field using the downloaded data: [token_type]+” “+[access_token] * Fill in the Download tool Here are examples of the parsed * Token data: * Role data* The pic below shows the 1st 2 records of the entity data but only a small subset of the 383 fields (multiple fields for 51 different permission policies). * * The entities match the first page of Role data found at https://apps.mypurecloud.com.au/directory/#/admin/directory/rolesV2 Hope this helps someone!! All the best Susan

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Download access token & data from the Genesys Purecloud API

Susan

Hi Folks

I want to get an access token & data from the Genesys Purecloud API. I have tried various ways to put the information into the download tool but have not been able to get a token, let alone data!

The Genesys DeveloperForum doesn’t mention Alteryx & the Alteryx Community doesn’t mention Purecloud.

Attached is my workflow (2018.4).

Below are pics of each tool as well as links to the doco that specifies the input, the requests & the JSON response containing the token.

Don't know what I am doing wrong, but hope someone out there can spot it 🙂

Susan

Here is my input data (client credentials are deidentified). When I use the real ClientID & Secret & derived Authorization, I get the same DownloadData & Headers as with these dummy values
These are the steps to base encode ClientID&Secret for the Authorization field
Here is the download tool (I have also tried using the other URL fields from the above text input):
3. Whether I check TokenPost on the Payload tab or not, I get the same result in DownloadData & DownloadHeaders
The DownloadData field contains (contextid varies):

{"message":"HTTP 404 Not Found","code":"not found","status":404,"contextId":"5b25a7b0-191d-4b3c-8846-44255f518204","details":[],"errors":[]}

The DownloadHeaders field contains:

HTTP/1.1 200 Connection Established

Proxy-Agent: Zscaler/6.0

HTTP/1.1 404 Not Found

Content-Type: application/json

Content-Length: 140

Connection: keep-alive

Date: Wed, 20 May 2020 22:33:39 GMT

ININ-Correlation-Id: 5b25a7b0-191d-4b3c-8846-44255...

Instructions on URLs, variables and values re:
1. The API URL (https://developer.mypurecloud.com/api/rest/)
2. The requests (https://developer.mypurecloud.com/api/rest/authorization/use-client-credentials.html)

PullGenesysAPIData v02 AlteryxTest.yxmd

API

Download

Accepted answers

Susan

Hi Everyone

I am posting a solution to my problem in case it helps anyone else out there to use Alteryx to pull Genesys PureCloud data.

The attached workflow (2018.4) successfully pulls Client Credential data from our PureCloud instance. The entities and permissions in the Download Data field match the first page of Role data found at https://apps.mypurecloud.com.au/directory/#/admin/directory/rolesV2.

Setting up the Download tools with the correct URL, Header & Payload was a process of trying different settings suggested by the Genesys doco & tutorials.

There may be many solutions, but this setup worked for me:

Before you can run the workflow, you need to set up an Oauth client for Client Credentials as per https://help.mypurecloud.com/articles/create-an-oauth-client/
To get the client credential token
1. Populate the text input tool in the ‘Get access token’ container
  1. Host (URL for Australia): https://login.mypurecloud.com.au/oath/token
  2. Copy ClientID and Secret from the OAUTH client you created
  3. grant_type: client_credentials
2. Create the Authorization field. Thanks to @Kane Glendenning who helped me populate this correctly:
  1. UrlEncode the Client Secret and Client ID
  2. ‘Basic ‘ before the encoded string
3. Fill in the Download tool: Note the Payload tab has a
  1. custom HTTP action (which I was unable to pass in as a field for some reason) &
  2. drop down selection of Content-Type

To pull client credential data
1. Populate the text input tool in the ‘Get data’ container:
  1. HostGet: https://api.mypurecloud.com.au/api/v2/authorization/roles
  2. GetURL: GET /api/v2/users/me HTTP/1.1
  3. Content-Type: application/json
2. Create the Authorization field using the downloaded data: [token_type]+” “+[access_token]
3. Fill in the Download tool

Here are examples of the parsed

Token data:

Role data
- The pic below shows the 1st 2 records of the entity data but only a small subset of the 383 fields (multiple fields for 51 different permission policies).

- The entities match the first page of Role data found at https://apps.mypurecloud.com.au/directory/#/admin/directory/rolesV2

Hope this helps someone!!

All the best

Susan

PullGenesysAPIData v03 Deidentified.yxmd

All comments

mattreynolds

Looks like they're using OAuth.

This means you'll likely need two Download Tools:

1. First one to present your credentials and receive a token in return. Double check which parts of the payload are base64 encoded, it may just be the credentials individually.

2. Second download tool to pass the token to an API. The URI you have below may be scrubbed, but its likely that it will be of the form "https://api.mypurecloud.com.au/api/rest/api/v2/..."

Working with web services like this, it can be helpful to use a tool like Postman (https://www.postman.com/) to get the two requests down, and then build out the Alteryx tools to fit.

As an alternative, you could probably leverage the Python SDK (https://developer.mypurecloud.com/api/rest/client-libraries/python/) and a Python tool to connect to the site.

Hope this helps!

Matt

Susan

Thanks for responding Matt

Agreed re Oauth & 2 download tools. I have checked the B64 encoding too. If I ever get to the 2nd download tool I will try that URI "https://api.mypurecloud.com.au/api/rest/api/v2/..." !

I was hoping not to have to go down the postman & python paths, but you suggesting them makes me think that might have to be the next step

- they have tutorials with Python code eg https://developer.mypurecloud.com/api/tutorials/oauth-client-credentials/?language=python&step=1.

- & if I can install postman I might work through...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/APIs-in-Alteryx-cURL-and-Download-Tool/ta-p/31522.

Fingers crossed, let's see what another day brings!

Susan

Hi Everyone

I am posting a solution to my problem in case it helps anyone else out there to use Alteryx to pull Genesys PureCloud data.

Setting up the Download tools with the correct URL, Header & Payload was a process of trying different settings suggested by the Genesys doco & tutorials.

There may be many solutions, but this setup worked for me:

Before you can run the workflow, you need to set up an Oauth client for Client Credentials as per https://help.mypurecloud.com/articles/create-an-oauth-client/
To get the client credential token
1. Populate the text input tool in the ‘Get access token’ container
  1. Host (URL for Australia): https://login.mypurecloud.com.au/oath/token
  2. Copy ClientID and Secret from the OAUTH client you created
  3. grant_type: client_credentials
2. Create the Authorization field. Thanks to @Kane Glendenning who helped me populate this correctly:
  1. UrlEncode the Client Secret and Client ID
  2. ‘Basic ‘ before the encoded string
3. Fill in the Download tool: Note the Payload tab has a
  1. custom HTTP action (which I was unable to pass in as a field for some reason) &
  2. drop down selection of Content-Type

To pull client credential data
1. Populate the text input tool in the ‘Get data’ container:
  1. HostGet: https://api.mypurecloud.com.au/api/v2/authorization/roles
  2. GetURL: GET /api/v2/users/me HTTP/1.1
  3. Content-Type: application/json
2. Create the Authorization field using the downloaded data: [token_type]+” “+[access_token]
3. Fill in the Download tool

Here are examples of the parsed

Token data:

Role data
- The pic below shows the 1st 2 records of the entity data but only a small subset of the 383 fields (multiple fields for 51 different permission policies).

- The entities match the first page of Role data found at https://apps.mypurecloud.com.au/directory/#/admin/directory/rolesV2

Hope this helps someone!!

All the best

Susan

PullGenesysAPIData v03 Deidentified.yxmd

jayviz

This really helps and I had an already working API workflow which no longer works when they authorization API. I am able to generate the token , however when I am using that token to read the Data API it fails.

Slightly different from your method, I am using Authorization as "Bearer "+[access_token].. It fails with "{"faultcode":"Server", "faultstring":"Authorization Failed"}".

Any thoughts ?

tracysackellares

Hi, my colleague and I were very happy to find your workflow. Our company recently started using PureCloud. We are reviewing your PureCloud access workflow and are curious whether you have had to update it since 2020. We appreciate any help you can provide.

Thank you,

Tracy Sackellares

Susan

Hi @jayviz & @tracysackellares,

I am so glad my workflow helped you!! I did that as a POC 2 years ago now and haven't touched it since. It proved that we could get data from PureCloud & that was all we needed. So I am sorry, but I can't offer any advice other than what I recorded in the original posts, & obviously things could have changed since then.

It would be great if you could post the issues and solutions you find, so others can benefit.

All the best, Susan

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703