1. REST API Get Started V4REST API for Oracle Fusion Cloud Financials
  2. Learn More
  3. Work with your REST Client

Work with your REST Client

Because REST APIs use HTTP methods to send and receive content, you can test REST APIs using any programming language or tool that supports sending and receiving HTTP messages. So, let's first choose a tool for making HTTP requests.

Note:

Oracle REST APIs are not OData (Open Data Protocol) compliant.

Considerations for Choosing a REST Client

You can choose among many clients that interact with Oracle Applications Cloud, such as:

With a client you can:

  • Test the username, password, and request URL for your REST API account.
  • Perform view and describe actions to learn more about REST resources, attributes, and parameters.
  • Use the collected information to construct and send various types of HTTP requests, such as those to create, update, or delete records.

How You Send HTTP Requests Using cURL

In our examples, we use cURL, a popular command-line utility for transferring data using URL syntax, to send requests to REST services. cURL is available in most UNIX, Windows, and Macintosh environments. For details, see Installing the cURL Command-Line Tool on Windows.

The following table describes commonly used cURL options that you can use for REST services.

Option Description

-user

username:password

Specifies the user name and password for server authentication.

-d

Sends the specified data (a JSON request body) to the server. If you begin the data with the @ sign, then @ must be followed by a file name to read the data from.

-H

Specifies an extra HTTP header in the request. To specify multiple headers, precede each header with the -H option.

Examples:
  • Content-Type: Format of request body (for example, with POST)
  • Accept: Format of response body
  • X-Auth-Token: Authentication token

-output

<file>

Writes the output to a file instead of to stdout.

-X

Specifies the request method to use when communicating with the HTTP server. The default method is GET.

The following table shows Oracle Applications Cloud examples of the GET, PATCH, and POST operations using cURL.

Operation cURL Command Example

Use GET to retrieve all invoices 

curl  -u username:password \
-X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/<version>/invoices \
-H 'Content-Type: application/vnd.oracle.adf.resourceitem+json'

Use PATCH to update an invoice 

curl -u username:password \
-X PATCH -d @<example_request_payload.json> https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/<version>/invoices/{InvoiceId}\
-H "Content-Type: application/vnd.oracle.adf.resourceitem+json"

Use POST to create an invoice 

curl  -u username:password \
 -X POST -d @<example_request_payload.json> https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/<version>/invoices \
 -H "Content-Type: application/vnd.oracle.adf.resourceitem+json"

How You Send HTTP Requests Using Clients

You can use standalone clients, third-party browser extensions, or add-ons, such as the Advanced REST Client, to send HTTP requests. The following table includes examples of the GET, POST, and PATCH operations using a client.

Operation Response/Payload Example

GET: Get an invoice.

Request URL: https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/<version>/invoices/{InvoiceId}

 
{
    "InvoiceId": 300100177254998,
    "InvoiceNumber": "REST_Foreign_Currency_Lines_Dist_Installments",
    "InvoiceCurrency": "EUR",
    "InvoiceAmount": 2212.75,
    "InvoiceDate": "2018-09-01",
    "BusinessUnit": "Vision Operations",
    "Supplier": "Advanced Network Devices",
    ...  
}

POST: Create an invoice.

Request URL: https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/<version>/invoices

 
{
    "InvoiceNumber": "REST Unmatched Invoice Header",
    "InvoiceCurrency": "USD",
    "InvoiceAmount": 2212.75,
    "InvoiceDate": "2018-09-01",
    "BusinessUnit": "Vision Operations",
    "Supplier": "Advanced Network Devices",
    "SupplierSite": "FRESNO",
    "Requester": "Johnson,Mary",
    "InvoiceGroup": "01Sep2018-Group",
    "Description": "Office Supplies"
}

PATCH: Update an invoice.

Request URL: https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/<version>/invoices/{InvoiceId}

 
{
"PayGroup": "Netting Invoices"
}

With an understanding of how your client works, you can next review how to import financials data for a sample workflow.