Skip to main content
Answer

Custom Reports - Filtering data retrieved by API

  • November 28, 2024
  • 5 replies
  • 132 views

Forum|alt.badge.img+3

Hi all,

 

I’m looking for a little bit of assistance.

 

I’m trying to build a custom report for our monitoring needs, the issue is I’m not sure how to filter out data received by an API Call.

 

For example: I add a dataset > HTTP > Rest API: /Job

The above returns me all the jobs, how do I filter jobs that ran on a particular date? Is there any tool I can use in the dashboard creator itself?

 

Thanks a lot for any suggestions.

Best answer by Paupau

I didn’t realize, but the Post Query Filter is also available when using the API to retrieve data, and it seems to be working, thanks everyone for the suggestions though.

5 replies

christopherlecky
Byte
Forum|alt.badge.img+17

Forum|alt.badge.img+3
  • Author
  • Bit
  • November 30, 2024

Not exactly what I was looking for.

Can filtering be done after receiving the data from API in the Custom Report builder tool?

Thanks.


Wouldn’t it better to use the reporting engine API and execute it against Backup Job Summary?

REF: https://documentation.commvault.com/2024e/essential/rest_apis_for_reports.html


Forum|alt.badge.img+3
  • Author
  • Bit
  • December 1, 2024

Wouldn’t it better to use the reporting engine API and execute it against Backup Job Summary?

REF: https://documentation.commvault.com/2024e/essential/rest_apis_for_reports.html

The REST API - GET Data Set API is not working for me.

/CustomReportsEngine/rest/reportsplusengine/datasets/<datasetID>/data - always returned 404 not found, not sure if I was doing something wrong.


Forum|alt.badge.img+3
  • Author
  • Bit
  • Answer
  • December 1, 2024

I didn’t realize, but the Post Query Filter is also available when using the API to retrieve data, and it seems to be working, thanks everyone for the suggestions though.