Adaptive Insights connection

[anutakki67]

Hi,

I have to start collecting the data from Workday Adaptive. I am looking at how to make the connection. I checked the messages in community, and I came across a thread of how to work with data in workday adaptive but not connection.

Any suggestions will be helpful.

Thank You ,

[Rhys_Cooper]

Hi @anutakki67 . Please can you expand on what type of connection you are after. Typically workday offers API connectivity which you can interact with using the donwload tool in alteryx. this involves the owner of the workday instance creating you a service account to allow the api connection. Happy to elaborate further if an API connection is what you mean.

Thanks

[anutakki67]

Hi @Rhys_Cooper ,  Yes, can you please elaborate on the API connection.

Thank you in advance.

[klambert]

Hi, 

I have this API set up and working. You want to start with a text input that is the API link eg "https://api.adaptiveinsights.com/api/v31"

Then the download tool.

In the download tool grab the url from the input, and output the data as a string.

In the headers tab, the content-type should be application/xml.

In the payload tab, right at the bottom you then enter your query string. This is an example from mine, but you can grab similar from the documentation.

This then should output the data into an xml string which you can then parse and manipulate.

I have set this up for work, so if you get stuck just shout.

<?xml version='1.0' encoding='UTF-8'?>
<call method="exportData" callerName="alteryx">
<credentials login="xxxx-your user email - xxxx" password="xxx--your password--xx"/>
<version name="Version HERE" isDefault="false"/>
<format useInternalCodes="true" includeUnmappedItems="false"/>
<filters>
   <accounts>
     	<account code="account code here" isAssumption="false" includeDescendants="true"/>
   </accounts>
   <timeSpan start="01/2025" end="12/2025"/>
</filters>
<rules includeZeroRows="false" includeRollupAccounts="true" markInvalidValues="false" markBlanks="false">
   <currency useCorporate="true"/>
</rules>
</call>