Skip to content
HOW TO

Retrieve Report Data

Goal

Retrieve the current body or metadata for a Runline report.

Prerequisites

  • A full topic or matching report group and report name.
  • Access to the report's environment and secret, when required.
  • Enough clear worksheet space for the expected result shape.

Steps

1. Build the topic from shared report identifiers.

2. Use U.GET for the report body or U.GET_METADATA for metadata fields.

=U.GET($B$2,$B$3,1,,)

3. For large or changing shapes, combine retrieval with U.PASTE, U.REGION, or U.PAD rather than assuming a fixed output footprint.

Result

The requested report page or metadata is returned to the worksheet and can feed downstream formulas.

Common Variations

  • Select a page by name or index.
  • Use U.GET_METADATA for freshness and report annotations without expanding the report body.
  • Use U.PASTE when a controlled destination range is more appropriate than a spill result.

Troubleshooting

  • If the wrong page appears, check the report_page input and page numbering after any cache filter.
  • If a spill result is blocked, clear or relocate adjacent content.
  • If the result is stale, trace the topic, subscription trigger, and any intermediate cache separately.