ExpandIDTypes Parameter (Connect-Workday Cmdlet)
Whether to expand multiple ID types when they appear in reports. Only has an effect for queries using the Reports as a Service (RaaS) API.
Syntax
Connect-Workday -ExpandIDTypes SwitchParameter
Data Type
bool
Default Value
false
Remarks
Every Workday entity is identified by a WID (a GUID generated by Workday) but some types of entities have other types of identifiers. For example, a Workday country record for the United States would be identified using the "US" country code in addition to its WID.
By default the {i collects all these IDs under one column and produce an aggregate.
This is the value of the Country_Reference.ID column for the US record:
<wd:Country_Reference> <wd:ID type="WID">abcdef1234567890</wd:ID> <wd:ID type="Country_Code">US</wd:ID> </wd:Country_Reference>
If this option is enabled, the {i instead produces a separate column for each ID type. For the US record:
- The column Country_Reference.ID.WID is set to abcdef1234567890
- The column Country_Reference.ID.Country_Code is set to US