Accessing Workday reports in alteyrx

[Mark_Stuart_CW]

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

[Chaoued]

@Mark_Stuart_CW  

Check the RaaS URL format :
https://<tenant>.workday.com/ccx/service/customreport2/<tenant>/<report_path>?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.

[Mark_Stuart_CW]

Hi 

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

Unticked it and all working