My Oracle Support Banner

How To Retrieve COMPLETED And FAILED Instances In One Shot Using The ICS Management APIs (Doc ID 2641734.1)

Last updated on FEBRUARY 27, 2020

Applies to:

Oracle Integration-OIC - Version 18.2.5 and later
Information in this document applies to any platform.

Goal

How to retrieve COMPLETED and FAILED Instances in one shot using the ICS Management APIs 

Trying to use ICS Management API to retrieve instances created in 1 hour window, where we can retrieve all COMPLETED instances by using below

https://xxxx.xx.xxxx.com/icsapis/v2/monitoring/instances?q={timewindow : '1h', status : 'COMPLETED'}

Can retrieve all FAILED instances by using below

https://xxxx.xx.xxxx.com/icsapis/v2/monitoring/instances?q={timewindow : '1h', status : 'FAILED'}

How to use a single query to retrieve all COMPLETED and FAILED instances in 1 hour window ?

It fails when tried below options :

https://xxxx.xx.xxxx.com/icsapis/v2/monitoring/instances?q={timewindow : '1h', status : ['FAILED','COMPLETED']}

https://xxxx.xx.xxxx.com/icsapis/v2/monitoring/instances?q={timewindow : '1h', status : 'FAILED','COMPLETED'}

https://xxxx.xx.xxxx.com/icsapis/v2/monitoring/instances?q={timewindow : '1h', status : "'FAILED','COMPLETED'"}
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.