Accessing Workday reports in alteyrx

Question

Hi

We have just started to use workday and i want to pull a workday report directly into Alteryx.

I have worked out that I can produce a Json url which works using the download tool in Alteryx if there are no filter but when I filter I get the following message

400 : Validation error occurred. Element type "wdr:Company" must be followed by either attribute specifications, ">" or "/>".

has anyone, does anyone have a step by step way as to how I can import the data directly from Workday into Alteryx

this the end of the url

...BI_Customer_Invoice_Lines?Company%21WID=98801189f36310011b370cf4d4c40000&format=json

Thanks

Mark

Mark_Stuart_CW · Answer

Hi

Thank for the response, worked out it was the below setting that was ticked

Unticked it and all working

Chaoued · Answer

@Mark_Stuart_CW Check the RaaS URL format : https://.workday.com/ccx/service/customreport2//?format=json Apply filters : ?Company!WID=98801189f36310011b370cf4d4c40000&format=json --> Make sure there are no XML fragments in the URL. The error suggests the filter might include XML tags (wdr:Company) instead of just query parameters. Test the URL in a browser first: If it works in the browser, it should work in Alteryx. Use Alteryx Download Tool: Method: GET URL: Your validated RaaS URL Authentication: Workday usually requires Basic Auth (username + password or API key). Parse JSON in Alteryx: After Download Tool, use JSON Parse Tool to extract fields.