skyvia salesforce reports

Salesforce Report exports only 2000 records

Skyvia integrates with Salesforce via its API, inheriting both its features and limitations.

One key limitation is the Run Report restriction, which limits data extraction to the first 2,000 rows of a report.


For more details on this limitation, we recommend reaching out to Salesforce support.
Additionally, you can explore the following resources for more information:


Increase number of records can be exported from Salesforce Reports API

How to return full report (>2000 rows) using rest api?

Salesforce Report API – How to Fetch More Than 2000 Records


    • Related Articles

    • Skyvia Backup Errors Caused by Salesforce API Requirements

      Skyvia interacts with Salesforce via its API. During a backup operation, you may encounter errors due to certain limitations or behaviors specific to the Salesforce API. For example, when Skyvia performs a backup or replication, it queries all the ...

    • Salesforce API errors: TotalRequests Limit Exceeded/ApiBatchItems Limit Exceeded

      The TotalRequests Limit Exceeded and ApiBatchItems Limit Exceeded errors are Salesforce-specific errors indicating that you have reached specific API limits on the Salesforce platform. Please find explanations of each error and relevant documentation ...

    • Freshdesk: The Limit of Freshdesk API Calls Per Hour Has Been Reached

      This error occurs on the Freshdesk side, indicating that the API call limit for the hour has been exceeded. For more details on Freshdesk's API limits, refer to their API documentation. Freshdesk enforces a limit on the number of API calls that can ...

    • Understanding Records in Skyvia Data Integration

      1.1 Understanding Records in Skyvia Data Integration A record in Data Integration represents a single row in a database table. Every integration process (Import, Replication, Export, Synchronization, etc.) handles individual records. Records also ...

    • Salesforce Audit Fields: Quick Insertion Guide

      To use audit fields for the INSERT operation in Skyvia, please enable the 'Create Audit Fields' permission in your Salesforce instance. More details can be found here. Below are the steps to enable the permission: Go to Setup → User Interface. Enable ...