Which HTTP methods are called Idempotent?

An HTTP method is idempotent if an identical request can be made once or several times in a row with the same effect while leaving the server in the same state. 

Idempotents methods: GET, HEAD, PUT, and DELETE.

Non-Idempotent methods: POST. PATCH is not necessarily idempotent, although it can be.

OIC - Rest HTTP Verb Put vs Patch

Following HTTP verbs are available:

GET: Retrieves information. If you select this option, you can not configure a request payload for this endpoint.

PUT: Updates information.

POST: Creates information.

DELETE: Deletes information. If you select this option, you can not configure a request payload for this endpoint.

PATCH: Partially updates existing resources. The patch verb does not work with a non-SSL rest service.

PUT vs PATCH:

The HTTP PATCH method offers a way to apply partial updates to resources. As a result, clients need to send only the differences in their request.

Where as, HTTP PUT method replaces or updates a resource entirely.

For example, /Users >>

{"User":"abc","Email":"abc@domain.com"}

PUT: It includes all parameters 

PUT /Users/1

{

"User":"cde",

"Email": "cde@gmail.com"

}

PATCH: It includes the one to be updated.

PATCH /Users/1

{

"Email":"cde@gmail.com"

}

XSD - Opaque schema

Opaque schema:

<?xml version = '1.0' encoding = 'UTF-8'?>  

<schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/"

            xmlns="http://www.w3.org/2001/XMLSchema" >

      <element name="opaqueElement" type="base64Binary" />

    </schema>

OIC - Read Json data received as json string

Steps:

• Write Received Json string to stage directory as binary content using stage action oraext:encodeBase64() function and an opaque schema.
• Read data written in the stage directory using stage read action and sample json file as reference.
• Map the read json to response of the integration.

Rest configure input and output:

Input xsd:

<?xml version="1.0" encoding="windows-1252"?>

<Input xmlns="www.oracle.com"/testing">

<JsonDataInString></JsonDataInString>

</Input>

Output json:

{

"Id":"",

"Name":""

}

Opaque xsd to write in stage binary:

<?xml version = '1.0' encoding = 'UTF-8'?>  

<schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/"

            xmlns="http://www.w3.org/2001/XMLSchema" >

<element name="opaqueElement" type="base64Binary" />

</schema>

Steps with POC screenshots:

Curl command links

 Curl command - Test a rest API

Unix links

1. Unix or AIX - SFTP or SSH - no matching host key type found. Their offer: ssh-dss
2. LINUX - UNIX - AIX commands -3 Ways to Create a Text File Quickly Through the Linux Terminal
3. Unix or AIX box - remove zero size files from a directory
4. Unix/AIX box - Certificate expiration date check
5. Unix/AIX box : count word occurrences in text file
6. Shell script to move files older than 10 days
7. cron-job-and-shell-script-remove old files from unix directory
8. Move files from AWS S3 bucket location to another location using EC2 command
9. Count number of files in aws s3 bucket location using EC2 command

Database links

Database related topics:

1.  database-schedule-using-dbms-job
2. Database - create package and procedure
3. How to export data dictionary with Oracle SQL Developer
4. Database - Create a sequence
5. SQL - How to Optimize SQL Queries
6. 12c SOA Weblogic console - Database - shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory error
7. DB Offset - Fetch clause
8. DB - Check the status for all type of objects using user_objects
9. DB - Count(*) vs count(1) vs count(column_name
10. DB - LISTAGG() function | Aggregate fuction
11. odi datafile check used and allowed max size
12. SQL WITH Clause uses
13. odi sql query to monitor temp size and resize
14. What is the use of decode function in SQL?
15. Db - insufficient privileges issue while using dbms_scheduler create job