Bulk Update of CABI Reports Schedules via REST API

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I have many CABI Report Schedules and I need to update them in bulk. In my case I need to update the timezone as it is currently wrong. 

How can I update them all in one go? 

Environment

Release : UIM 20.4, CABI

Cause

Guidance 

Resolution

JasperServer Reports (CABI) is third-party tool so Broadcom does not directly support this. However, the procedure from TIBCO is described in the articles below: 

 

Bulk Update of Jasper Schedules | Jaspersoft Community

The jobs Service | Jaspersoft Community

 

Below is an example applied to UIM CABI: 

Objective: Update the timezone on multiple report schedules jobs. 

 

 

1. Use POSTMAN (or any other REST CLIENT)

2. POST call using this URL: (in the example below I'm updating job 1,2 and 4. There you will have to put all your jobs id's. )

[to find the list of job ids run the  following query: SELECT * FROM jireportjob ]

 

URL: http://<cabi_URL>/cabijs/rest_v2/jobs?id=1&id=2&id=4

BODY TYPE: XML

BODY:

<jobModel>

          <simpleTriggerModel>

              <timezone>Etc/GMT-3</timezone>

          </simpleTriggerModel>

             </jobModel>

 

This will update the timezone to "Europe/Bucharest" timezone on the schedule for jobs 1, 2, and 4.

Additional Information

Related KB: UIM CABI Report Time Zone configuration (broadcom.com)