API Connection to Workday API?

[DataPrepChad]

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

Thanks! 

[FelipeVarzeas]

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

[apathetichell]

https://stackoverflow.com/questions/77449676/workday-rest-api-wql

does that help?

[FelipeVarzeas]

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

[s_graham]

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]

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

[apathetichell]

@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.