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 Workday API?

DataPrepChad
10 - Fireball

Has anyone created a custom connector to the Workday API? Wanted to check with the Community prior to building one out.

 

Thanks! 

 

 

22 REPLIES 22
MichaelSu
Alteryx Alumni (Retired)

Hi Workday Thread,

 

Trying to connect to the Workday Web Report and receiving the error "invalid format for date text = 2019-12-12.

 

Any ideas?

 

Thanks,

Mike

john_miller9
11 - Bolide

Hi Michael - can you provide some additional detail?

 

Does the report execute without issue if you open in a browser?  Is there a date prompt that you are trying to update?  Which part of the string are you replacing?  

 

4brianatchley
5 - Atom

hello John - so is it possible to have excel linked to workday so that data can be imported into an excel tab instantly and thereby avoiding the need to manually log in to workday and run report and extract and copy and paste every time I want the latest data?  Is this something you could show me? 

FFFool
9 - Comet

@4brianatchley 

 

I'm sure it's possible, but you would need to pass your credentials somehow. This isn't really the forum for Workday to Excel linkage. If you have any questions about pulling the data into Alteryx, I can do my best to help. 

4brianatchley
5 - Atom
Thanks. I'll keep digging.
4brianatchley
5 - Atom

Thanks. I'll keep digging. I thought he was specifically referring to workday and excel. 

cambiukpytou
5 - Atom

Mind sharing how you built out the connector?

abruno
5 - Atom

Hello,

 

May you please share how you built out a connector?

 

Thanks!

pjohnsonbohan91
Alteryx
Alteryx

Bump for answer on this thread

To start, I am a complete Alteryx newcomer, literally 2nd day using/testing the tool. However I am an experienced Workday Admin so naturally this thread was one of the first places I came to. 

Let me share my solution in hopes it inspires/helps those in the future. Big FYI, for my use case I wanted to see if I could make a WQL call (which is a REST API call to Workday) using a Bearer token as my method of authentication. I understand that may be a lot more complex then your standard RAAS (report as a service), but note that Workday Community already has a nice guide on how to authenticate using basic auth and call a RAAS.

 

1. In Workday, create an API Client for Integrations and assigned the scopes/areas you want to allow your API Client to access. The remainder of the steps are in Alteryx.

2. Create a 'text input' module (see screenshot for the 3 data points entered - note for WQL call, the heading must be 'query' as shown)

 Joseph_Accountant_0-1685730627058.png

3. Create a 'download' module, and uncheck the DCM, and for the field use the token URL from the text input module. Nothing needed on the headers or connection tabs, but on the payload tab see screenshot below for how to pass your client id, client secret, refresh token, and grant type (as we are getting an access token we need to use the 'post' http method).

 
 

Joseph_Accountant_5-1685730867903.pngJoseph_Accountant_3-1685730833475.png

 

4. I then used a select module to filter out the data I didn't need, and I used a parse JSON module to parse the 'downloaddata' to extract the access token from the download step.

 

5. Next is the filter, to single out the access_token from the rest of the downloaddata that was parsed.

Joseph_Accountant_6-1685731056084.png

 

6. Next is a formula module. It is very important to call the output column 'authorization' - see screenshot below

Joseph_Accountant_7-1685731147651.png

 

7. The final step is another download module, similar to the last one, uncheck DCM, and this time use the WQL URL from the text input step. The only Header needed is the 'authorization' value. The payload tab is a 'get' call this time, and here I just pass along the 'query' from the text input at the beginning of the flow.

Joseph_Accountant_8-1685731182025.pngJoseph_Accountant_9-1685731240412.pngJoseph_Accountant_10-1685731329776.png

 

8. That should be it, after you run the flow, you should be getting a JSON 'downloaddata' from the 2nd download module, you can then parse it and transform it however you need the data. 

 

 

I hope this guide helps someone else out or at least gives some ideas on how to connect Alteryx to Workday using an API Client. As I am new to the Alteryx community, I would appreciate a thumbs up if you do find this guide helpful.

Labels