Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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! 

 

 

25 REPLIES 25
FelipeVarzeas
6 - Meteoroid

Hey Joseph,

Thank you so much for that, I was able to authenticate into the tenant after following these steps. At this moment I am trying to query something from the tenant, but even though the WQL works in the tenant, when I use it in the Alteryx flow it keeps returning a S21 error (not found: null).

Is it possible that you could share a sample WQL to bring, for example, the workers data from the GMS demo tenant?

 

This is the query I've tried:

SELECT firstName, location FROM allWorkers

 

Thanks in advance

FelipeVarzeas
6 - Meteoroid

It does, thank you! besides adding the wql btw api and version, the URL was also missing the /data at the end.

s_graham
6 - Meteoroid

Joseph, could you provide any more guidance on the workday set up side? trying to figure out getting the credentials. we just implemented and im working with my admin on how to get this running, but your method of requesting the token in the first call and then requesting the data in the next is what i have always used for oauth in alteryx. 

megaron
5 - Atom

Can anyone show the steps to config the download tool in order to download Workday's web enabled csv file?

 

CSV link: "https://services1.myworkday.com/ccx/service/customreport2/sie/1001006802/CR_People_Analytics_-_End_o..."

 

connection.jpg

 

error.jpg

apathetichell
19 - Altair

@megaron --- try setting up

https://services1.myworkday.com/ccx/service/customreport2 -- as your base URL

and then include: 

/sie/1001006802/CR_People_Analytics_-_End_of_Month_FX_Rates?format=csv -- as a field.

pass that in and append it. looks like this newfangled Download tool wants too parts for a DCM managed API --- one a connection part - two a specific endpoint.

Labels