Oracle CRM On Demand REST API Formats

The Oracle CRM On Demand REST API uses the language, date, time, currency, and number formats described in this topic.

Language Format

For requests, you can use the standard HTTP Header Accept-Language to specify what language to return. You can list the preferred language codes in the Accept-Language header, and Oracle CRM On Demand parses the header and selects the first language code listed in the header. For more information about the languages supported by Oracle CRM On Demand and the corresponding language codes, see Supported Languages.

For example:

Accept-Language : en-us, fr-f, es

In the previous example, the user prefers US-English. If US-English is not supported, then the user will accept French in France. If French is not supported, then the user will accept any type of Spanish.

If either the header is not present or if the language could not be determined from the header, then the response will have the user set the language. A response uses standard HTTP Header Content-Language to specify the language returned. For additional information about HTTP headers, see Supported HTTP and Oracle CRM On Demand Header Fields.

Supported Languages

The following table lists the supported languages for the Oracle CRM On Demand REST API with the corresponding language code.

Table Supported Languages

Supported Language REST API Language Code

Danish

da_DK

German

de_DE

English (UK)

en_GB

English (USA)

en_US

Spanish

es_ES

Finnish

fi_FI

French

fr_FR

Italian

it_IT

Japanese

ja_JP

Korean

ko_KR

Dutch

nl_NL

Norwegian

no_NO

Polish

pl_PL

Portuguese (Brazil)

pt_BR

Portuguese (Portugal)

pt_PT

Russian

ru_RU

Swedish

sv_SE

Thai

th_TH

Turkish

tr_TR

Chinese (Simplified)

zh_CN

Chinese (Traditional)

zh_TW

Date and Time Formats

For all dates and times displayed, the time zone is the logged in user’s time zone, which is determined from the user’s locale.

All date fields are displayed in the format YYYY-MM-DD format, for example:

2014-11-03

Datetime fields for the Oracle CRM On Demand REST API are displayed in the following format:

YYYY-MM-DDTHH:mm:ssZ

An example of a date and time in this format is:

2014-11-03T18:00:12Z

This example represents 6:00 PM on the third of November 2014, in the user’s time zone.

Currency Formats

Currency fields for the Oracle CRM On Demand REST API requests use the following format:

currencyfieldname: currencyfieldvalue 

Currency fields for the Oracle CRM On Demand REST API responses are displayed in the following format:

currencyfieldname:
{
type: "currency",
value: "400300,50",
modifier: "EUR"
} 

where:

  • type indicates the data type, currency.

  • value indicates the numeric value of the currency. The currency symbol is not part of the value. The value includes the decimal separator, which is determined according to the user’s locale. The value does not contain a thousands separator. In this example, the user's locale is France, therefore the decimal separator used is the comma.

  • modifier indicates the international three-letter currency code.

Number Formats

All number formats (NUMBER, INTEGER and PERCENTAGE) for the Oracle CRM On Demand REST API are displayed in the following format:

<FieldName> : <Value>

The value element includes the decimal separator, which is determined according to the user’s locale. The value does not contains a thousands separator.