OIC: REST APIs Examples for managing Integrations

Expanding upon the last article I'm providing additional details and examples for using Oracle Integration Cloud REST APIs for managing your integrations. 

Note that for the examples below I will be using one of the pre-packaged integration named Hello World (version 1.2.000)

To limit the size of this posting I'm just providing examples only and limiting to common use-cases (small subset of the options). For additional details and completeness pls refer the official doc - REST API documentation. 


To get list of Integrations

curl -u username@email.password  -v -H "Content-Type:application/json" -H "Accept:application/json" -X GET https://instance-name.integration.ocp.oraclecloud.com/ic/api/integration/v1/integrations


Export one integration 

 curl -u username@email.password -X GET  -H "Content-Type:application/json" -o ./HELLO_WORLD_01.02.0000.iar_BAK https://instance-name.integration.ocp.oraclecloud.com/ic/api/integration/v1/integrations/HELLO_WORLD%7C01.02.0000/archive 

OIC: List of Integrations by Creator

Oracle Integration Cloud provides rich set of REST APIs to manage your connections/integration and life-cycle events. See details here for complete set.

There the APIs to get list of integration in JSON format but at this point there is no out of box API support for filtering out the results by creator or author of the artifact. One can use common programming language to parse the filter out the results but that require additional effort.

In this blog, I will provide simple command line means of achieving that. We will use curl and one command line library to parse JSON data - https://stedolan.github.io/jq/ 

The following was developed and tested on Mac OS (Mojave 10.14.6 ) and OIC version 19.3.1.0.0 (190624.1100.29533)

Install jq
brew install jq

Get list of integrations

Replace the highlighted (in blue) for your environment...

curl -u username@email.com:password -H "Content-Type:application/json" -H "Accept:application/json" -X GET https://instance-name.integration.ocp.oraclecloud.com/ic/api/integration/v1/integrations | jq '. |  {code: [.items[].code]}'

3 days in Amsterdam & around

After my short visit to London, I flew to Amsterdam and spent 3 days exploring the place. It was an awesome experience - quite a contrast from London on many levels. Sharing some highlights.

Amsterdam is unique in many ways - historical buildings, more canals than Venice, more density of Museums than anywhere else in the world, more bikes than population, friendly and relaxed environment, and perhaps most liberal city you will visit with legalized recreational drugs, same-sex marriage, and euthanasia! 

For my stay, I picked a hotel near Schipol Airport. Amsterdam city is about 15 - 20 mins train ride from the airport. You can buy 3-day Amsterdam Travel Ticket (25 euros) that allows you unlimited train, tram, and bus rides. 

3 days in London

London is a travelers paradise - it has everything - famous buildings and landmarks, world-class museums, outstanding restaurants, fabulous retail, and plenty of green space and all of history to go along with that. 

Earlier this month I was traveling back from India to Los Angeles and took a break journey to spend 3 days in this beautiful metropolis (also spent some time in Holland - but that's for another post). Having born and brought up in India with centuries of colonial rule, Britain has a profound influence on India's history and culture. So, it was an even greater interest that I was looking forward to my visit to London.

I had some luggage so picked a hotel near Heathrow airport in Hounslow City - in the hindsight not a good idea to stay far from central London since wasted so much time every day traveling to the city.

London is very well connected by train/bus and oyster travel-card that allows to travel on any train/tube or bus is perhaps the best way to move around - great value and saves you a lot of time - I bought a 3-day pass for around 20 pounds. I also bought London Pass (approx 80 pounds) separately that cover entry ticket for most attractions (note you can purchase Oyster Travelcard with London Pass also)

My best golf round so far - 2 over

Yesterday was lucky day for me - shot my best round for 18-hole regulation course - 72 (2 over total with 4 over in front and -2 in the back) at Azusa Greens. Had one eagle and 2 birdies. Putting was not too bad either - 29 total puts with 6 one puts 6 - 15 ft range. Score would have been little better if not for bummer on par 3 13th - missed 2 footer and bogeyed from 15 ft with 3 puts!!.
This eclipses my previous best of 73 at Alhambra Golf Course which is bit easier course to play - rating/slope/rating of 64.8/114. Measuring around 6200 yrds Azusa Greens is not really long with rating/slope of 69/118 but some fairways are narrow with trees on the side.

Pilot for a day

Today me and my friend went out on our first experience flying a plane. It was cold day (around 45 deg f) and partly clouds. After small briefing about key aircraft instruments and practicing for about half an hour on simulator, we were ready for our maiden flight. With trainer on the side and my friend on the back seat, I took control of small 4- Seater around 40 year old Piper PA -28 (http://en.wikipedia.org/wiki/Piper_PA-28). Starting from Van Nuys airport for a short 40 mins flight, we passed around LA downtown, Hollywood sign, Griffith park, and Pasadena to finally land at El Monte airport.

Personally, the take off was most scary of all. With takeoff speed around 60 knots - approx 70 mph which is not all that fast, and no horizon in sight for few mins (seemed much longer) and the plane gaining fast elevation, matched only by rising heart rate, the sheer exhilaration of takeoff was very soon replaced by the doubt and fear of placing trust on small and not so powerful and old piece of machinery. It made me wonder if this little escapade was well worth the risk and this adventure was nothing but a big mistake. Fortunately, once we leveled off around 2000 ft, the flight was much smoother and enjoyable. Sitting in small box floating in the air, it was strange feeling of freedom and helplessness, excitement and anxiety that hard to describe in words. Still occasional shake and slide of the plane would bring back the worst of fears. 

Oracle BPEL Engine (SOA Suite) Diagnostics - Parsing low level request stats

Parsing Low-Level Request Stats

This blog entry is in continuation to Francis blog entry http://thesoaman.blogspot.com/2012/06/using-bpel-performance-statistics-to.html which talks in detail about the use of low-level statistics provided by BPEL Engine of Oracle SOA Suite for diagnosing performance-related issues for projects involving BPEL processes. As promised to Francis, here are some details that might be useful while parsing the low-level request stats. Sorry took some time to put this out – better late than never!

As the request enters BPEL engine it is first handled by delivery service. This layer persists all incoming asynchronous requests are in the database. The request is then passed on to BPEL Engine (or generic name Cube Engine) for further processing.

Low-level request stats can provide insight into average taken by various engine layers (latency) as it flows through the delivery service and engine. The actual execution of request happens in invoke-method and the individual activity execution can be found by looking for stat with key actual-perform.