Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to retrieve data from Custom Tables of Salesforce using Qlikview Connector.

Hi,

I am Ashish Sharma. I am trying to download the data in Qlikview using the Salesforce Connector.

No issues with the Standard fields.

But, how to retrieve data from Custom Tables of Salesforce using Qlikview Connector.

It is urgent. Can someone guide me regarding this.

The Name of the Table is "

Thanks in Advance

1 Reply
Not applicable

Re: How to retrieve data from Custom Tables of Salesforce using Qlikview Connector.

CustomObject_SQL:

SQL SELECT

    *

FROM CustomObject__c;

CustomObject:

LOAD DISTINCT

    Id,

    CustomField1__c as Contact.Id,

    CreatedById,

    CreatedDate,

     LastActivityDate,

    LastModifiedById,

    LastModifiedDate,

    Name

RESIDENT CustomObject_SQL;

DROP TABLE CustomObject_SQL;