WorkDay Tutorial-Simple XML

Simple XML is particularly useful for basic desktop integrations, in which a knowledgeable user wants to integrate with other reporting tools such as Microsoft Excel or Crystal Reports. With Simple XML, the complexity of Workday XML is distilled into basic XML elements that are simple to understand and can be processes by many desktop applications. 

Simple XML results in XML that is easier to read and understand than Workday XML. Here are a couple of key examples of how it is different: 

·       Single-instance fields are changed to simple string-type elements. 

·       Multi-instance fields are changed to simple string-type elements. 

·       Multi-instance fields within the primary business object are changed to simple string-type elements, with a semi-colon separating each value.

 

·       Data fields that only contain dates (that is, they do not contain times) output dates only, with no times or offset from GMT.

 

Workday XML is the default output of an EIB unless an alternate output is selected or a custom transformation is applied.



OTHER OUTPUTS 

CSV 

The CSV (comma-separated values) output option is likely to be used by a user wanting to import data into a spreadsheet as simply and as quickly as possible. No knowledge of XML or schemas is required. 

RSS 

RSS stands for Really Simple Syndication. It is an XML standard for publishing frequently updated content over the Internet. Common examples of such content are news headlines and blog postings. 

GData 

The GData output option is useful for integrations with Google gadgets and other cases where it is desirable to allow programmatically access to this data format. 

JSON 

The JSON (JavaScript Object Notation) output the option is provided for use in system-to-system integrations where this data the format is required.