Looking for a Perl Module to export a Report

[#1]

Hi Everyone!

Does anyone know of a Perl Module that I can use to grab the output of a report that is generated by NetMRI?  Perhaps via the report_id?

Thanks,

Lon.

[#2 · Accepted solution]

Check here:

api/2.10/report_job_runs/docs

[#3]

Thanks Sif, but that just returns the array of ReportjobRun (/api/2.10/report_job_runs/model) and it contains all the info about the report, but I don't see where I can grab the actual report?

Cancel Time
Created At
Foreground?
Priority
ProcessID
Report Start
Report Type
ReportID
Size
Start Time
Status
Updated At
UserID
id
report_job_specification_id

[#4]

I don't see any API call to get it, I will ask the Engneering team.

Sif

---

[#5]

Lon,

Need to file an RFE with the account team, looks like it's not aviable via an API call.

Sif

[#6]

HI Sif, 

Was an API call ever created to pull the output of a report that is generated by NetMRI?

[#7]

Seems like an oversight what is the point of having access to the Report object if the API call is not there to pull data from the object. 

[#8]

A little bit of creative API-ing

1. I assume you know the name of the report
1. For this example I am going to use “Vlan Interface Summary”
2. I assume you know how to get a REST auth cookie
3. Check /api/3.4/report_job_runs/index this will give you a json object with the scheduled reports as they were run
4. Take the “id” value of a report that you want to obtain
5. Use the following API call:
1. curl --request GET 'https://demo-netmri.infoblox.com/WebViewer/frameset?__format=xls&__document=/var/local/netmri/report...'  --header 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8' --header 'Content-Type: application/x-www-form-urlencoded'  --header 'Cookie: use your cookie here'
2. The variables that matter are
   1. Format
      1. Either html,xls,doc,pdf
   2. Report id

1. see: /var/local/netmri/reports/repDoc7684.rptdocument
2. Use the ID to craft the filename
1. Report name

1. pFile=VlanInterfaceSummary
2. Use the name of the report and drop the spaces