Google BigQuery REST Response Parser

This Forge component helps OutSystems developers work with Google BigQuery REST API responses when a full OAuth flow or Google SDK cannot be used.

When BigQuery is accessed directly via REST (for example, using externally managed authentication), query results are returned in a schema-based JSON format that is difficult to consume in OutSystems. This component converts those responses into a clean, row-based JSON array that can be used immediately in UI, APIs, and logic.

What’s included

• Extension with a single action:
  Parse — accepts a raw BigQuery REST API JSON response and returns a standard JSON array of objects

• Test screen:
  A built-in screen that lets you paste BigQuery REST responses, run the parser, and preview the transformed output for validation and troubleshooting

Key benefits

• No Google SDK dependencies

• No OAuth handling required

• Lightweight and deterministic

• Designed specifically for OutSystems constraints

Typical usage

1. Call BigQuery via REST using external authentication

2. Pass the response JSON to the Parse action

3. Use the returned JSON directly in your OutSystems application