How to use elements from response in WITH CONNECTION

UraniumSpoon — Tue, 28 Dec 2021 20:28:48 GMT

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.

Re: How to use elements from response in WITH CONNECTION

Vu_Nguyen — Tue, 21 May 2019 12:27:45 GMT

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 ?

topic Re: How to use elements from response in WITH CONNECTION in Connectivity & Data Prep

How to use elements from response in WITH CONNECTION

Re: How to use elements from response in WITH CONNECTION