Workday integration: How do I pick which "addressDataList" to use in order to populate the sys_user table?

[Adrian Weber1]

Using Flow Designer, we are trying to populate address information into the sys_user table via the Workday integration hub.  Specifically, address information. 

However, Workday has multiple addresses defined for each employee (Work, home, shipping, etc.), and they are separated by "TypeReferenceID".  Some ID's also include a sub-reference for "addressUseForReferenceID", which we would also need to filter down to... 

How can we get Flow Designer to filter down to "TypeReferenceID = Home" and "if addressUseForReferenceID = Shipping", so that we can use the info to update the sys_user table? 

I've attached some screenshots... you can see how there are 2 entries for "addressDataList" in the first screenshot... we need to be able to pick one or the other, based on the "TypeReferenceID" or the "addressUseForReferenceID" values, if they are present...  

Any help would be greatly appreciated. 

Thank you! 

[Paul Lathrop1]

I think you'll need to use the XML parser and a script step that logically selects the appropriate ID. 

[Adrian Weber1]

Hi Paul, 

Thanks for your help!  We ended up having to write some scripts to navigate down through all of the options and get the data we were looking for.  Not easy, not fun, and definitely not GUI based...