Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

API Connection to NICE

paullefrancois
6 - Meteoroid

Anyone out in Alteryxland have success creating workflows to retrieve data from the NICE platform?

 

I have created the needed call URL and am able to successfully connect. However, I am continuously being met with {"message": "Unauthorized"} returned from the call. 

 

I am able to call the same API with the same credentials using Postman. 

 

Thank you in advance! 

8 REPLIES 8
BrandonB
Alteryx
Alteryx

My guess is that Postman is handling some of the auth steps behind the scenes that you aren't seeing. Can you click on the "Code" button on the right hand side of Postman and view the cURL equivalent? It is most likely using either basic authentication which base64 encodes a username/password, or it is using an oauth flow. 

 

I have a write up on API calls in Alteryx that can be found here: https://community.alteryx.com/t5/Engine-Works/APIs-for-Beginners-Integrate-All-the-Systems/ba-p/8074... 

mutama
Alteryx
Alteryx

Hi @paullefrancois,


To build upon @BrandonB ’s excellent solution, you can enhance this further by building a custom connector (installed within Alteryx Designer), once you’ve successfully connected to NICE & fetch the data via API as illustrated by Brandon.

 

Here’s a good supplementary guide as well on how to build your own custom macro/connector: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Guide-to-Creating-Your-Own-Connecto... 

 

Hope this helps! 😊

paullefrancois
6 - Meteoroid

Thank you VERY much for jumping in. All is good now. 

RenaKadakia928
5 - Atom

Can you share the URL and configurations you used to setup this API? I am running into issues and receiving errors with my setup. Thanks!

BrandonB
Alteryx
Alteryx

@RenaKadakia928 what errors are you seeing and what API documentation are you referencing? 

RenaKadakia928
5 - Atom

"code" : "Bad Request",
"details" : "com.fasterxml.jackson.core.JsonParseException: Unrecognized token 'accessKeyId': was expecting (JSON String, Number, Array, Object or token 'null', 'true' or 'false')\n at [Source: (org.springframework.util.StreamUtils$NonClosingInputStream); line: 1, column: 13]",

NithinK
7 - Meteor

Hi,

 

I am trying to establish a connection to NICE and download a Report using the "Download" tool in Alteryx Designer and I receive the following error message with no code.

 

Due to several simultaneous report requests yours cannot be delivered at this moment. Please try to run it again at another time

 

@paullefrancois @RenaKadakia928 - could you please share the "URL/workflow/download tool configuration" you are using to establish the connection?

 

I am currently using the below URL and it throws me the error

 

https://home-c35.nice-incontact.com/ReportService/DataDownloadHandler.ashx?CDST=usingmytokenhere&PresetDate=1&Format=CSV&IncludeHeaders=True&AppendDate=False

 

 

@BrandonB @mutama is there an API documentation specific to NICE (CXOne)?

 

BrandonB
Alteryx
Alteryx

Hi @NithinK to be transparent, I'm not an expert in NICE or CXOne, but a search online returned this documentation: https://help.nice-incontact.com/content/recording/dataextractionapi.htm 

 

Because this isn't Alteryx specific content I can't comment on whether or not this is the right documentation and endpoints for your purposes, but it would appear so. From the link above there is also a section that points you at all of the endpoints that are available. 

Labels