Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
;
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.