Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ?