topic Re: DataLoad from SalesForce? in QlikView

DataLoad from SalesForce?

qlikuser222 — Thu, 12 Apr 2018 16:09:38 GMT

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);

Re: DataLoad from SalesForce?

Qrishna — Thu, 12 Apr 2018 16:52:45 GMT

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.

Re: DataLoad from SalesForce?

qlikuser222 — Thu, 12 Apr 2018 20:20:41 GMT

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