Skip to content

    • Archive

    Archive

    Salesforce Connector 2000 rows limit for reports?

    Member
    in Archive

    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
     

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Domo Employee

      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.

       

       

    • Domo Employee

      @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.

       

    • Contributor

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

    • Member

      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

    • Contributor

      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'

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories