Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.
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?
LOAD Id as [Case_c],
IsDeleted as [IsDeleted_Case],
CreatedDate as [CreatedDate_Case],
ClosedDate as [ClosedDate_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.