Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

DataLoad from SalesForce?

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

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Re: DataLoad from SalesForce?

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

View solution in original post

2 Replies
Highlighted
Specialist III
Specialist III

Re: DataLoad from SalesForce?

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.

Highlighted
Creator
Creator

Re: DataLoad from SalesForce?

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

View solution in original post