Salesforce retrieve archived records

[sifatnabil]

Hi all,

Everyone using the old Salesforce connector (Salesforce DLL) will have to upgrade to QvSalesforceConnector by July 22, 2017 when they disable TLS 1.0. In the old connector, I used to be able to retrieve archived records by using SQL SELECT_ALL on the task object. Now with the new connector, I don't know how to retrieve these archived records. Does anyone know how?

[Anonymous]

Hi Sifat

I have spoken to the product team at Qlik about this and can confirm that the latest version of the connector, by default, will automatically retrieve the archived and deleted records.

The SELECT_ALL keyword therefore isn't needed anymore, and is not recognised, so by simply removing this would work for you and retrieve all records.

You can use the where clause in the LOAD statement to limit the full retrieval, eg

WHERE IsDeleted = 0; would then only pull back the current records etc.