Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jsnova
Partner - Contributor II
Partner - Contributor II

problem qlik sense using rest server to incremental update qvd file

Hi,

I want to incremental update my qlik sense file. at the moment i am using a qvd file to store the data

the datasource can add, delete change data and i want my source to get the recent changes.

But as soon as I add where to my code I get a substring error.

[code]

LIB CONNECT TO 'MendixRestConnectie';

Set vQVDPath = lib://MendixRestFolder/;

LET vLastExecTime =  num(QvdCreateTime('$(vQVDPath)Test.QVD'));

Let vThisExecTime = num(date(Now(),'DD-MM-YYYY hh:mm:ss'));

//

//laat variable in exec zien

Trace $(vLastExecTime);

Trace $(vThisExecTime);

Sleep(100);

// timestamp(if(isnull(QvdCreateTime('$(vQVDPath)Test.QVD')), 0, ConvertToLocalTime(QvdCreateTime('$(vQVDPath)Test.QVD'), 'GMT', 1)), 'YYYY-MM-DD hh:mm:ss');

//haalt data op

[root]:

LOAD

  "IdId",

  "Salaris" as "Salaris",

  "Naam" as "Naam",

  "changedDate",

  "Changed" ,

  "Changed" as "ModificationTime",

  "ChangedAsLong";

SQL SELECT

  "IdId",

  "Salaris" as "Salaris",

  "Naam" as "Naam",

  "changedDate",

  "Changed",

  "Changed" as "ModificationTime",

  "ChangedAsLong"

FROM JSON (wrap on) "root"

WHERE "ChangedAsLong" >= $(vLastExecTime);

//  AND date(ModificationTime) < $(vThisExecTime);

//store root into $(vQVDPath)Test.QVD (QVD);

Concatenate

LOAD

  IdId,

  Salaris as Salaris,

  Naam as Naam,

  changedDate,

  Changed,

  Changed as ModificationTime,

  ChangedAsLong

FROM $(vQVDPath)Test.QVD (QVD)

WHERE NOT EXISTS(IdId);

If ScriptErrorCount = 0 then

  STORE root INTO $(vQVDPath)Test.QVD;

  Let vLastExecTime = num(vThisExecTime);

End If

[/code]

1 Reply
jsnova
Partner - Contributor II
Partner - Contributor II
Author

The following error occurred:

Unknown substring, string, or value at (10,19): '>= '