Build Table with API in a Loop

Jim_O — Wed, 05 Apr 2023 13:52:12 GMT

Hello!

I am very close to getting this running, but at the moment my code leaves me with the required number of rows, but the same 500 or so rows repeated over and over.

Any pointer would be much appreciated.

Here's my code:

// recTotal already found by a previous query = 111,532;

Let startAt = 0;
Let pageSize = 500;

[ABS_Main]:
LOAD [@row.id],
[ID-ABS],
[Record Owner]
;

FOR startAt = 0 TO recTotal STEP pageSize

Concatenate

SQL SELECT
"@row.id",
"ID-ABS",
"Record Owner"
FROM JSON (wrap on) "root"
WITH CONNECTION(

URL "https://blah/blah/blah/select.json",
QUERY "offset" "$(startAt)",
QUERY "limit" "$(pageSize)"

);

NEXT startAt;

Thanks

Jim

topic Build Table with API in a Loop in App Development

Build Table with API in a Loop