Workday

[HenryJS]

Hi all

Please could someone advise the best way to extract / connect data from Workday HCM to Power BI?

thanks

[v-angzheng-msft · Accepted solution]

Hi, @HenryJS 

This connector may be useful to you Workday HCM (Preview)

Additional information online:

ZappySys has announced Generic SOAP / REST API connector which you can use to pull data from WorkDay SOAP Web Service in Power BI or other ODBC tools. Check below link Connect Workday in Power BI – Import SOAP Data

Here is sample SQL query

SELECT * FROM $
/*Below WITH clause is optional, uncomment parameter(s) values you like to set
which are different than DSN properties.
*/
WITH(
src='https://xxxxxxxxxx.workday.com/ccx/service/yyyyyyyyy/Human_Resources'
--,ElementsToTreatAsArray='wd:Worker'
--,DataConnectionType='HTTP'
--,SoapWssPasswordType='PasswordDigest'
--,UserName='testuser001'
--,CredentialType='SoapWss'
--,Filter='$.env:Envelope.env:Body.wd:Get_Workers_Response.wd:Response_Data.wd:Worker[*]'
--,RequestContentTypeCode='TextXmlUtf8'
--,RequestMethod='POST'
--,Header='SOAPAction: ""'
,RequestData='

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dgkallan]

Does anyone know if you need to know SQL to use this API?