How to export a bandwidth consumption report via API

1. Go to the API console at https://developer.kaltura.com/console/ (Sign In) or  http://www.kaltura.com/api_v3/testme.
   In this guide, we will practice the report.getTable API call, See https://developer.kaltura.com/console/service/report/action/getTable.
2. Generate a KS (relevant when Testme Console is used)
   See How to Start a Kaltura Session using the TestMe Console.
3. Session Service: report
4. action: getTable 
5. reportType (KalturaReportType): PARTNER_USAGE
   
6. reportInputFilter (KalturaReportInputFilter): KalturaReportInputFilter > Select Edit
   1. add fromDate (int) , toDate (int) timestamps in unix.
      You may use this online converter https://www.epochconverter.com/.
   2. Enter the relevant entry ID in entryIdIn (string)
   3. Enter the relevant user ID of the media owner in ownerIdsIn (string)
7. pager (KalturaFilterPager): KalturaFilterPager > Select Edit
   1. pageSize (int): 500
      
   2. pageIndex (int): 1 [then change it to 2,3, and so on as needed]
8. Click SendOutput example
   
   
9. Open Notepad and copy the <header> output to a notepad's 1st line.
10. Copy the <data> output to a notepad's 2nd line.
    
11. Click Ctrl F to Replace all ";" with line breaks "\n" Click here to learn more.
    Find what: ;
    Replace with: \n
    

12. Save as tablename.csv and open the file in Excel.

Demo video

Was this article helpful?

Thank you for your feedback!

Name

Email

Submit your feedback

Thank you! Your comment has been submitted.