How to load data dynamically from website

Anonymous — Fri, 02 Apr 2021 07:35:38 GMT

Hi Community,

I would like to import data dynamically from company.info, so I have changed my settings.ini to StandardReload = 0.

Now I can import dynamically right, but I cat message: 'Not found'

My script is shown below:

VENDOR:

LOAD

right('00000'&KVKNO&'0000',12) as KVKNO,

FROM [lib://Data/VENDOR.csv]

(txt, codepage is 28591, embedded labels, delimiter is '~', msq)

where KVKNO <> '';

KVKCOUNTER:

LOAD DISTINCT KVKNO as KVKNUM,

RowNo() as RowNo

RESIDENT VENDOR;

let kvkCounterRows = NoOfRows('KVKCOUNTER');

for i=1 to 10

//for i=1 to $(kvkCounterRows)

let KVKNO = peek('KVKNUM',$(i),KVKCOUNTER);

KVK:

LOAD

@1,

FROM [https://company.info/id/$(KVKNO)]

(html, codepage is 1252, no labels, table is @1)

where @1 = 'KvK';

I hope anybody can help me.

Thank you in advance.

Grtz, Pascal

Re: How to load data dynamically from website

marcus_sommer — Tue, 16 Jan 2018 12:26:54 GMT

When occured the error - already by the first iteration or later? If later it would mean that your script is generally working but a certain combination of KVKNO and table @1 isn't available. If it's by the first iteration you should check if the variable KVKNO contained a valid content, for example with:

trace '$(KVKNO)';

If this looked ok. you should check if your load-statement is right - just create a load-statement with the wizard of one and/or several pages and compare this result with your code - maybe there are differences.

- Marcus

topic How to load data dynamically from website in Connectivity & Data Prep

How to load data dynamically from website

Re: How to load data dynamically from website