While retrieving data from the ‘Visitor Activities’ view in Salesforce Pardot, after more than two minutes we get an error “504 Gateway Timeout” and no records are returned. It happened because of the number of records that those views have. So, in this case, we are querying the whole visitor activity database, the size of data being retrieved is too big, and this is expected to time out. The solution to this problem would be using the Pardot Bulk API. This approach was developed precisely for high-volume use cases. To enable it, set ResponseMode connection property to Bulk, and the driver will switch to Bulk API.

