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: Expired access/refresh token

      If you see an "expired access/refresh token" error, your Salesforce OAuth connection is invalid due to token expiration or revocation. Please open your Salesforce connection, sign in again, and save it. Test the connection to confirm it works. This ...