How to use elements from response in WITH CONNECTION

[UraniumSpoon]

I'm trying to query a paginated website, that returns a mis-formatted "Next" value, and I need to read that 'next' value into the "URL" field of the WITH CONNECTION call. How would I go about doing that? 

I essentially need this:

TempTable:
SQL SELECT
"__KEY_root",
(SELECT
"__KEY__links",
"__FK__links",
(SELECT
"href",
"type",
"__FK_next"
FROM "next" FK "__FK_next")
FROM "_links" PK "__KEY__links" FK "__FK__links")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION(URL "api.example.com" & $(links/next/href));

Where `$(links/next/href)` is the value contained in the response at that location.

[Vu_Nguyen]

Hi, could you give an example of how the URL with pagination parameter looks like? Is it  something like https://api.example.com/links/next/href ?