Web extraction

Pulls a single value out of a JSON API and drops it into a sentence on the page, with text before and after it.

A published Confluence table headed Our Apps with columns for app, installs, rating and reviews, listing Capable for Confluence, Calendar for Confluence, Diagrams for Confluence and Approval for Confl
Several extractions can sit in one table, each cell holding a value fetched from a live source.

For the one live number a page needs, install counts, a repository's star count, today's temperature, an exchange rate, without embedding a whole dashboard. You give it a JSON endpoint and a JSONPath to the field you want, plus a prefix and suffix so the value reads as a sentence rather than a bare figure. The value is fetched through Capable's authenticated proxy when the page is viewed and cached for fifteen minutes, and numbers are formatted with thousands separators. A Presets menu fills in five worked examples so you can see the shape of a working configuration.


#See it

Every example below is a real macro on this page, not a screenshot, and each one is a configuration taken from a page somebody actually built. Open this page in the editor to see how any of them is set up.

#London Temperature

N/A°C

#Settings

A JSON source, a path into it and the optional text either side are all the macro needs.

Setting

Values

What it changes

Format

JSON (the only option in the dropdown)

Which parser is used. See caveats, this is effectively fixed.

URL

Any http(s) endpoint returning JSON. Fetched through Capable's authenticated URL proxy with a 10-second timeout, up to 4 attempts with exponential backoff (1s, 2s, 4s), plus a small per-macro jitter so many macros on one page do not fire at once.

The endpoint to read. Required together with the path.

XPath/JSONPath

A JSONPath. The supported subset is: `$` or empty (the whole document), `$.a.b.c` (dotted property access), `$.a.b[0].c` (a specific array index, with optional property), and `$.a.b[*].c` (every element's property, joined with ", "). Anything else returns the literal text "Invalid JSONPath format".

Selects the value. A path that does not resolve renders "Property not found", "Array index not found" or "Target is not an array" as the value.

Prefix

Free text

Printed immediately before the value. Kept even when the value cannot be fetched, so the sentence still reads.

Suffix

Free text

Printed immediately after the value. Note the default is not empty, a macro inserted without touching this field says "… installs".

Presets

London Temperature, GitHub Repository Stars, Bitcoin Price, Exchange Rate, Atlassian Marketplace Downloads

Each fills format, URL, path, prefix and suffix in one click.



The largest family, and the most precise.