Add example to extra data from a JSON response field

Repository metrics

Stars

26 stars (26 stars)

PR merge metrics

PR metrics pending (PR metrics pending)

Description

The trick is to cast the response into JSONB . For example:

> select response_body::jsonb ->> 'number' as num_people_in_space from net_http_request where url = 'http://api.open-notify.org/astros.json'

+---------------------+
| num_people_in_space |
+---------------------+
| 10                  |
+---------------------+

Contributor guide

Research direction

Review the documentation for the net http request table and add an example showing how to cast the response body to JSONB and extract fields using > and >> operators.

Tech stack

go

Domain

api

Issue type

Documentation

DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.

1

Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.

Under 1 hour

Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.

Active

ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.

Clear

Prerequisites

Git

Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.

90