WD.LIVEDATA

Description

Returns live data (report) metadata based on the reference and option that you specify. Remember to submit the formula as an unconstrained formula using Ctrl+Alt+Enter (on Windows) or Command+Option+Enter (on Mac).

Syntax

WD.LIVEDATA(

reference

option

)

reference

: The root cell (top left cell) of the live data range.

option

: The metadata to return. Valid options are 0-4 , 100-104, and 10-29. If there are no results for the option, the function returns an error. Example: If you select option 3 (report prompts used) and there are no prompts in the report, the function returns the #N/A error. For detailed descriptions of the options, see the Function Reference in the User Guide (Help > User Guide).

Function Options and Descriptions

Option	Description	Notes
100	Report metadata (all). With header.	All metadata, as described in the rest of this table.
101	Report column metadata: Name, XML Alias, Type. With header.	Type values: STRING, STRINGS, STRING_RICH, NUMERIC, NUMERIC_UNITS, CURRENCY, DATE, DATES, DATE_TIME, TIME, BOOLEAN, BOOLEANS, URL, URLS, INSTANCE, INSTANCES
102	Columns included: Name, XML Alias, Type, Editable, Key. With header.	Type values: COLUMN, EXPRESSION, FORMULA, NOTE Editable values: TRUE/FALSE Key values: TRUE/FALSE
103	Report prompts used: Name, XML Alias, Type. With header.	Type values: STRING, STRINGS, STRING_RICH, NUMERIC, NUMERIC_UNITS, CURRENCY, DATE, DATES, DATE_TIME, TIME, BOOLEAN, BOOLEANS, URL, URLS, INSTANCE, INSTANCES
104	Report prompts with settings: Name, XML Alias, Type, Value, Prompt Type. With header.	Type values: STRING, STRINGS, STRING_RICH, NUMERIC, NUMERIC_UNITS, CURRENCY, DATE, DATES, DATE_TIME, TIME, BOOLEAN, BOOLEANS, URL, URLS, INSTANCE, INSTANCES Prompt Type values: AS_SPECIFIED, DO_NOT_USE, USE_DEFAULT
0	Report metadata (all). No header.	All metadata, as described in the rest of this table.
1	Report column metadata: Name, XML Alias, Type. No header.	Type values: STRING, STRINGS, STRING_RICH, NUMERIC, NUMERIC_UNITS, CURRENCY, DATE, DATES, DATE_TIME, TIME, BOOLEAN, BOOLEANS, URL, URLS, INSTANCE, INSTANCES
2	Columns included: Name, XML Alias, Type, Editable, Key. No header.	Type values: COLUMN, EXPRESSION, FORMULA, NOTE Editable values: TRUE/FALSE Key values: TRUE/FALSE
3	Report prompts used: Name, XML Alias, Type. No header.	Type values: STRING, STRINGS, STRING_RICH, NUMERIC, NUMERIC_UNITS, CURRENCY, DATE, DATES, DATE_TIME, TIME, BOOLEAN, BOOLEANS, URL, URLS, INSTANCE, INSTANCES
4	Report prompts with settings: Name, XML Alias, Type, Value, Prompt Type. No header.	Type values: STRING, STRINGS, STRING_RICH, NUMERIC, NUMERIC_UNITS, CURRENCY, DATE, DATES, DATE_TIME, TIME, BOOLEAN, BOOLEANS, URL, URLS, INSTANCE, INSTANCES Prompt Type values: AS_SPECIFIED, DO_NOT_USE, USE_DEFAULT
10	Workbook name
11	Sheet name
12	Cell	Root cell of live data
13	Report name
14	Report alias	Workday ID
15	Report description
16	Report type	ADVANCED_REPORT, MATRIX_REPORT, COMPOSITE_REPORT
17	Report async status	TRUE, FALSE
18	Report limit
19	Report key column count
20	Report multi-instance enabled	TRUE, FALSE
21	Report highlighted status	TRUE, FALSE
22	Table range name
23	Formula user
24	Last run user
25	Last run date	The date displays as a serial number; you can use Format Number Date to display the result using date formatting.
26	Last run time	In milliseconds
27	Last run row count
28	Next run user	Applicable if a refresh schedule exists
29	Next run date	Applicable if a refresh schedule exists

Examples

=TRANSPOSE(WD.LIVEDATA(A1,100)) returns all metadata and includes a header. The TRANSPOSE function puts the headers in a column for improved readability.

WorkbookName	Workbook Example
SheetName	Sheet1
Cell	A1
ReportName	Workday Report Example
ReportAlias	[Workday ID]
ReportDescription
ReportType	ADVANCED_REPORT
ReportAsync	FALSE
ReportLimit	0
ReportKeyColumnCount	1
ReportMultiInstanceEnabled	TRUE
ReportHighlightEnabled	TRUE
ReportTableName
FormulaUser	Logan McNeil
LastRunUser	Logan McNeil
LastRunDate	05/05/2021 11:09:17.928 PM
LastRunTime	426
LastRunRowCount	34
NextRunUser	Logan McNeil
NextRunDate	06/01/2021 7:00:00.000 AM

=WD.LIVEDATA(A1,101) returns column data details and includes a header.

Name	Alias	Type
Worker Name	[XML Alias]	INSTANCE
Dependents	[XML Alias]	INSTANCES

=WD.LIVEDATA(A1,102) returns report column information and includes a header.

Name	Alias	Type	Editable	Key
Employee ID	[XML Alias]	COLUMN	FALSE	TRUE
Worker Name	[XML Alias]	COLUMN	FALSE	FALSE
Dependents	[XML Alias]	COLUMN	FALSE	FALSE
Note1	[XML Alias]	NOTE	TRUE	FALSE
Formula1	[XML Alias]	FORMULA	TRUE	FALSE

=WD.LIVEDATA(A1,103) returns report prompt information and includes a header.

Prompt Name	Prompt Alias	Type
Effective Date	[XML Alias]	DATE
Cost Centers	[XML Alias]	INSTANCES

=WD.LIVEDATA(A1,104) returns report prompt details and includes a header.

Prompt Name	Prompt Alias	Type	Value	Prompt Type
Effective Date	[XML Alias]	DATE	4/15/2021	USE_DEFAULT
Cost Centers	[XML Alias]	INSTANCES	Value	DO_NOT_USE

Notes

This function is intended for use in array formulas. You submit array formulas with special keyboard shortcuts. We recommend that you use the unconstrained keyboard shortcut Ctrl+Alt+Enter (on Windows) or Command+Option+Enter (on Mac) so Worksheets can use all the cells it needs for the results.