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 (Windows) or Command+Option+Enter (Mac).
Syntax
(
reference
, option
) - reference: The anchor 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>Function Reference).
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, 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, 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, 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, Alias, Type, Value, PromptType. 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, 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, 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, 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, Alias, Type, Value, PromptType. 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 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 |
30 | Schedule start date | |
31 | Schedule end date | |
32 | Schedule type | |
33 | Schedule repetition interval | |
34 | Schedule data in cron expression format |
Examples
=TRANSPOSE((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 |
=(A1,101) returns column data information and includes a header.
Name | Alias | Type |
|---|---|---|
Worker Name | [XML Alias] | INSTANCE |
Dependents | [XML Alias] | INSTANCES |
=(A1,102) returns report column details 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 |
=(A1,103) returns report prompt information and includes a header.
Name | Alias | Type |
|---|---|---|
Effective Date | [XML Alias] | DATE |
Cost Centers | [XML Alias] | INSTANCES |
=(A1,104) returns report prompt details and includes a header.
Name | Alias | Type | Value | PromptType |
|---|---|---|---|---|
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 (Windows) or Command+Option+Enter (Mac) so Worksheets can use all the cells it needs for the results.