Issue

The Activity table is not available from the Salesforce connector, even though the Activity object is a standard Salesforce object. There is also a greyed-out ActivityHistory table with a message that says, Cannot select - not queryable. How can we get this data through our connector?

Environment

Connector: Salesforce

Resolution

There is no Activity table in our ERD. Activities are split between two other tables: TASK and EVENT. You will be able to access all relevant data from these tables.

As for the ActivityHistory table being greyed out with the message, this is an informational notice to let you know that we can see this data structure but we're not able to query it. When we cannot query data, it is usually a result of an API limitation.