SFDC Query

rajeshvaswani77 — Mon, 07 May 2012 07:18:14 GMT

Hi All,

I am working on a project that needs to extract data from the SFDC tables
using a QlikView script. Connection string is created that uses the salesforce
connector provided by QlikTech, passing the salesforce.com user credentails. The
script works perfectly fine while creating an extract from SalesForce tables
like Task, Event, User. The resultant query created in these cases is

LOAD *;

SQL select * from User;

This works perfectly fine.

However the queries

LOAD *;

SQL select * from ActivityHistory;

LOAD *;

SQL select * from OpenActivity;

give an Table not found error. The SFDC API page(<a href="https://ukgateway.logica.com/owa/,DanaInfo=mail.global.logica.com,SSL+redir.aspx?C=dd896f9410ff41758ef6142cf5d7a270&URL=http%3a%2f%2fwww.salesforce.com%2fus%2fdeveloper%2fdocs%2fapi%2fContent%2fsforce_api_objects_activityhistory.htm" target="_blank">http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_activityhistory.htm</a>)

states that the Query must be in the form of

SELECT (SELECT ActivityDate, Description FROM ActivityHistories)
FROM
Account
WHERE Name Like 'XYZ%'

The error got in this case is

Object type ActivityHistories is not supported.

Anyone from the community who has worked on salesforce.com using the
QlikViewconnector and has thoughts on this, kindly respond. This is an urgent
query.

thanks,

Rajesh Vaswani

Re: SFDC Query

Fri, 28 Jun 2013 18:50:41 GMT

FYI, your SFDC API link points to a location that is not generally available.

The API documentation suggests that the ActivityHistories object is not openly queryable, you must specify a single Account object to retreive data for. http://tinyurl.com/qcp8l7d

____________________________________________________________________________________

Issue a SOQL relationship query with a main clause that references the object, and an inner clause that references the activity history, for example:

SELECT (SELECT ActivityDate, Description FROM ActivityHistories) FROM Account WHERE Name Like 'XYZ%'

SELECT (SELECT ActivityDate, Description FROM OpenActivities) FROM Account WHERE Name Like 'XYZ%'

topic SFDC Query in QlikView

SFDC Query

Re: SFDC Query