Salesforce Connector Question - Date

Anonymous — Mon, 28 Mar 2016 23:39:55 GMT

I'm tyrin got use the salesforce connector in Qlik Senes to pull data out of a few salesfoce tables using the Bulk API.

Everything is working fine, but I'm trying to add a "where" to the select statement to limit the data set by a date. I seem to be messing up the syntax, so the load is erroring.

Does anyone know the right way to specify the statement with a date so it will work?

Example:

LOAD Id as [Case_c],

IsDeleted as [IsDeleted_Case],

CaseNumber,

...

CreatedDate as [CreatedDate_Case],

ClosedDate as [ClosedDate_Case];

SELECT Id,

IsDeleted,

CaseNumber,

...

CreatedDate,

ClosedDate

FROM Case

WHERE CreatedDate > 2016-01-01 00:00:00

;

Re: Salesforce Connector Question - Date

ehr — Tue, 14 Jun 2016 18:44:12 GMT

This format has worked for me:

Let SF_Date =TimeStamp($(Last_Modified_Date),'YYYY-MM-DD')&'T00:00:01Z';

In your case WHERE CreatedDate > 2016-01-01T00:00:00Z should work.

topic Salesforce Connector Question - Date in Integration, Extension & APIs

Salesforce Connector Question - Date

Re: Salesforce Connector Question - Date