API Connection to NICE

[paullefrancois]

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! 

[BrandonB · Accepted solution]

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]

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]

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

[RenaKadakia928]

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]

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

[RenaKadakia928]

"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]

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]

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.