Accessing Dynamic URL with multiple conditions

casey_autogator — Tue, 21 Jul 2020 23:58:44 GMT

Want to access some table data off html page(s) but there are multiple constraints. I know how to loop through a single basic variable situation, but not sure how to do this one?

Constraints are:

The url needs to be dynamic (this isn't too difficult)
Part of the FROM statement also needs to be dynamic
If there are no page results, the URL changes to a default URL that kills the loop

For each x ....

FROM [.......)]
(url is [https://dynamic_url/], html, codepage is 28591, embedded labels, table is @$(dynamic table #));
next x;

topic Accessing Dynamic URL with multiple conditions in Connectivity & Data Prep

Accessing Dynamic URL with multiple conditions