How Can I Query Unlimited Asset Data?

For dimensions other than asset and for all queries greater than one month, you can only access up to 10,000 rows. However, you can retrieve unlimited asset data through the IQ API if the date range for your query is less than one month.

How To in v3 Analytics

Query against the asset dimension, set a date range of less than or equal to 1 month (<32 days), and set the page and limit parameters. The following example will return the first 1000 rows of your data. Poll your data by iterating through all the pages until the last page. You can determine the last page using the total row count in the result and the current page number.
[GET] /v3/analytics/reports/?
report_type=performance
&dimensions=asset
&metrics=plays_requested
&start_date=2015-10-10
&end_date=2015-10-20
&page=0
&limit=1000
&api_key=yourApiKey                            
https://api.ooyala.com/v3/analytics/reports/?report_type=performance &dimensions=asset&metrics=plays_requested&start_date=2014-10-10&end_date=2014-10-20 &page=0&limit=1000&api_key=yourApiKey&expires=yourExpiration& signature=yourSignature

Response:

Note: The response below has been modified (showing all 1,000 rows would be messy). A real response will show all 1,000 rows of data.
{  
    "result_count":1000,
    "results":[  
        {  
            "start_date":"2015-10-10T00:00Z",
            "end_date":"2015-10-20T00:00Z",
            "data":[  
                {  
                    "group":{  
                        "asset":"ABCDEFGHIJ123",
                        "name":"Video 1",
                        "status":"live",
                        "type":"video"
                    },
                    "metrics":{  
                        "plays_requested":669997
                    }
                },
                {  
                    "group":{  
                        "asset":"012345678ABCD",
                        "name":"Video 2",
                        "status":"live",
                        "type":"video"
                    },
                    "metrics":{  
                        "plays_requested":444111
                    }
                },
                ...                
                {  
                    "group":{  
                        "asset":"HIJKLMNOP456789",
                        "name":"Video 1000",
                        "status":"live",
                        "type":"remote_asset"
                    },
                    "metrics":{  
                        "plays_requested":876
                    }
                }
            ]
        }
    ],
    "status":"OK",
    "status_code":"200",
    "total_count":10000
}

Was this article helpful?