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?
There is no
Activity table in our ERD. Activities are split between two other tables:
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.