Jeremy_L | 2019-10-16 03:29:44 UTC | #1
Hi all,
Complete newbie question here.
My employer uses PureCloud to run outbound voice campaigns, and I'm interested in exploring how the API could allow us to automate tasks like obtaining records of the dial attempts and connected calls, so that we can transform and store this data for internal records.
I'd like to play around with the API and investigate what's possible without involving technical teams first, as they are time limited and this would be a low priority. However the only tool available to me currently is Excel - as I said, I'm a newbie!
A bit of Googling tells me that you can use VBA in Excel to complete API calls e.g. by sending an HTTP GET request. Has anyone been able to use this to complete queries to the PureCloud API? Is it compatible with the OAuth authentication?
anon28066628 | 2019-10-16 13:40:46 UTC | #2
Hi Jeremy, PureCloud uses OAuth. Please see the link below. Client Credentials grant type would be most appropriate for analytics.
Note that most API resources return JSON which may not map cleanly to a record-oriented, tabular format like Excel sheets.
https://developer.mypurecloud.com/api/rest/authorization/
Becky_Powell | 2019-10-16 13:56:26 UTC | #3
Hi Jeremy,
Have you seen our API Explorer tool? You can use it to call any of the PureCloud APIs - no tooling or coding necessary! :slight_smile:
--Becky
Jeremy_L | 2019-10-16 23:27:15 UTC | #4
Thanks, this gives me some direction but not sure how I would go about getting a Client Credentials Grant. I do know there's a JSON library for Excel VBA that you can download which would solve the ability to interpret the data and bring it into Excel though.
Jeremy_L | 2019-10-16 23:27:59 UTC | #5
Hi Becky, yes I've used the API Explorer tool for one-off requests - however not sure how it could be used programmatically/without human involvement.
anon28066628 | 2019-10-17 13:42:25 UTC | #6
There are some libraries available that could help (below). Essentially for Client Credentials you just need to make HTTP requests with support for headers and base-64 encoding.
https://github.com/VBA-tools/VBA-Web/wiki/Authentication
Becky_Powell | 2019-10-17 13:55:17 UTC | #7
Hi Jeremy - here are the instructions for creating an OAuth client in PureCloud: https://help.mypurecloud.com/articles/create-an-oauth-client/.
system | 2019-11-17 14:09:06 UTC | #8
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 6254