Skip to content
REFERENCE

U.GET

Summary

Used to retrieve reports published by Excel or another application

Syntax

=U.GET(report_group_or_topic, report_name, [report_page], [metadata], [environment])

Parameters

Parameter Required Description
report_group OR topic Yes Usually set to a field containing a valid topic, most commonly a cell containing a call to U.SUBSCRIBE. Otherwise, the group of reports to which the report belongs. Can also be a clickval name and the clickval's value will be returned
report_name Depends The name of the report, which is unique within the report group. This field is optional if the first field is set to a full topic
[report_page] No The name or index number of the page in the report to retrieve. The first page of the report is retrieved by default.
[metadata] No Collection of key/value pairs that can be used to annotate the request. Certain metadata entries are recognized by the U Add-in and/or server and are used to control various bits of functionality
[environment] No An optional routing override that can be used to get the report from a non-default environment.

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the requested report page. When no page is specified, the first page is returned by default.

Examples

=U.GET(C10)

=VLOOKUP(B25,U.GET(U.SUBSCRIBE(C8,C9)),2,FALSE)

=U.GET(C43,C44)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.