function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ryan McLaughlinRyan McLaughlin 

paginate reports in analytics api

I don't know if this is the right forum for this, but I would really like to see the option to paginate reports in the analytics api. I need to pull a report with much more than 2000 rows, and I cannot see to get around the 2000 row limit.
Magnus Kreth TrailblazerMagnus Kreth Trailblazer
You can get around the default 2000 row limit at least with SAQL queries. Just use limit and offset statements.
Ryan McLaughlinRyan McLaughlin
Thanks for the reply, SAQL queries do look promising. However, I am confused about the load statement.

https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_eql.meta/bi_dev_guide_eql/bi_eql_statement_load.htm

What is the containerId/versionId that it refers to? Is this the report Id? or is there somewhere else that this is defined?

Also it looks like the Wave REST API requires special permission before I can use it. How do I request permission, and what are the chances that they drop this API after I spend time writing code to use it?