Salesforce Connector 2000 rows limit for reports?

Zoom
Zoom
in Connectors

Hi

 

I am very unhappy about the fact that there is a 2000 rows limit for salesforce tabular reports connector. Why is there such limit? I have never worked with a salesforce tabular report that has less than 2000 rows. Could DOMO fix this problem?

 
Best,
 
Derek
 

Comments

  • zcameron
    zcameron admin

    I've come up against this problem as well. It turns out that it is Salesforce, not Domo, that is imposing the limit. (See this thread in the Salesforce Developer community). The Salesforce API will only return 2,000 records for a saved search/tabular report. It will, however, pull any number of records from the tables themselves. I've had success pulling data from tables and then recreating the report data using Dataflows like Magic ETL.

     

     

  • Bulloko
    Bulloko 🟠

    @zcameron is exactly right. I found here Salesforce's official documentation regarding this.

     

    https://help.salesforce.com/HTViewHelpDoc?id=limits_analyticsapi.htm&language=en_US

    • The API returns up to the first 2,000 report rows. You can narrow results using filters.

     

  • kshah008
    kshah008

    @Zoom, did any of the above replies help answer your question? 

  • aarone
    aarone

    Any good workarounds?

     

    ex. collect Salesforce leads with Create Date of Yesterday (assuming less than 2000 leads are created a day) and simply append it to the end of the data set already in Domo?

  • Unknown
    Unknown

    Hi all, Can anybody help @aarone out? Thanks

  • Godzilla
    Godzilla 🟢

    you can run the job more frequently (maybe every 2 or 4 hours) so the total new leads do not go over 2000 and just append them to your dataset. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Categories