Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Is there a way to query or replicate the Activity object?

I don't see Activity in the tables of the linked servers catalog. I also can't query it with:

select top 10 * from salesforce...[Activity]


select top 10 * from salesforce...[Activityhistory]


exec [dbo].[SF_ReplicateIAD] @table_server = 'salesforce', @table_name = 'activityhistory'

which fails with this error.

13:55:12: Error System.Web.Services.Protocols.SoapException: INVALID_TYPE_FOR_OPERATION: entity type ActivityHistory does not support query
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at DBAmpNet2.sforce.SforceService.queryAll(String queryString)
at DBAmpNet2.SFDataLayer3.QuerySF()
13:55:12: DBAmpNet2 Operation FAILED.

Can we query it directly or pull the whole table local?
1 person has
this question