[SalesForce] System.LimitException: You can’t run more than 500 reports synchronously every 60 minutes

I am getting an error

System.LimitException: You can't run more than 500 reports synchronously every 60 minutes. Try again later.

is there any way to get filtered report Json without analytics API ?
or any way to Overcome this Limit ?

Best Answer

According to Salesforce1 Reporting REST API Limits (Extract):

Salesforce1 Reporting REST API has the following limitations:
Reports API Limits

Your organization can request up to 500 synchronous report runs per hour.

Your organization can request up to 1,200 asynchronous requests per hour.

So, either:

you switch to asynchronous requests to get a greater hourly limit, or
you ask your Salesforce Account Rep and/or support nicely to see if there is some Org based limit they can adjust for you. This may or may not be possible.
you switch to using SOQL queries to retrieve the same data via the REST API. This will also return the data in JSON based on the HTTP ACCEPT header that you use.

I suspect options 1 or 3 would be the easiest.

Related Solutions

[SalesForce] Create reports programatically with apex

You can't create a report programmatically from a unit test. You might be able to do it with the Apex Wrapper Salesforce Metadata API from outside of a unit test context, though.

I'm not sure of the design of your program, but maybe you can abstract away the report to a data source interface and mock that in your unit tests. E.g.,

public class MyReportService {
    DataSource source;
    public MyReportService(DataSource ds) {
        this.source = ds;
    }

   // Bunch of other methods that do things with with data source.
}

Then in your unit test:

DataSource myMockDataSource = generateMyMockDataSourceSomehow();
MyReportService service = new MyReportService(myMockDataSource);

Test.startTest();
Integer retVal = service.answerMagicalQuestion();
Test.stopTest();

System.assertEquals(42, retVal, 'magical answer wrong');

Best Answer

Related Solutions

[SalesForce] Create reports programatically with apex

Related Topic