DataLoad from SalesForce?

[qlikuser222]

Hi All,

I am trying to load data from SF. i am getting error message while performing incremental load. PFA error message. Can anyone please help?

I have loaded  below table to get the max LastModifiedDate.

TEMP:

LOAD

   Timestamp(MAX(LastModifiedDate),'MM/DD/YYYY hh:mm:ss TT') as LastModifiedDate

Resident XXX;

Let vLastModifiedDate = Timestamp(peek('LastModifiedDate',0,'TEMP'),'YYYY-MM-DD hh:mm:ss');

DROP tables Accounts, TEMP;

NoConcatenate

Incremental:

load * ;

SQL  SELECT  *

FROM XXX

where LastModifiedDate >= $(vLastModifiedDate);

[Qrishna]

Hi  - make sure the formats of both LastModifiedDate and $(vLastModifiedDate) are same and numeric or both should be of timestamp format.Qlik stores timestamps as numbers.

[qlikuser222 · Accepted solution]

Hi ,

It was solved by fixing the load editor. In the Load Editor when Connecting using the QvSalesforceConnector.Exe, I used Bulk API Interface Type with Convert SQL Dates, Convert UTC to local time, and PK Chunking.

Thanks