Skip to main content
Solved

Custom Reports - Filtering data retrieved by API

  • November 28, 2024
  • 5 replies
  • 66 views

Forum|alt.badge.img+2

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.

View original
Did this answer your question?

5 replies

christopherlecky
Byte
Forum|alt.badge.img+17

Forum|alt.badge.img+2
  • Author
  • 4 replies
  • November 30, 2024
christopherlecky wrote:

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+2
  • Author
  • 4 replies
  • December 1, 2024
Jacek Piechucki wrote:

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+2
  • Author
  • 4 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings