1 Reply Latest reply: Jan 16, 2018 7:26 AM by Marcus Sommer RSS

    How to load data dynamically from website

    Pascal Schwegler

      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,

          @2

      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

          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