| Oracle® Retail Science Cloud Services Implementation Guide Release 19.1.003.2 F40917-01 |
|
 Previous |
 Next |
| Oracle® Retail Science Cloud Services Implementation Guide Release 19.1.003.2 F40917-01 |
|
Previous |
Next |
This chapter provides an overview of the RASE Web Services. For additional details about any interfaces, see Oracle Retail Insights Cloud Service Suite/Oracle Retail Advanced Science Cloud Services Data Interface and Oracle Retail Science Cloud Services Interface Details.
RASE web services provide access to DB-bound configurations when a direct connection to the database is not desirable or possible; intra-day and ad-hoc access to certain application outputs is also provided. RASE web services are REST-based; it is assumed that you are familiar with basic REST principles (such as the usage of HTTP verbs). RASE web services provide access to a subset of application and output data, but do not fully mirror the user interface or export and import features of the backend. They are not a replacement for bulk data export, which must be done on a schedule as part of batch processing. However, access to the configuration can be used during implementation and upgrade periods, and AC and ASO export web services can serve as a means of obtaining incremental update data from a specified point in time (driven by a query parameter) as a means of intra-day processing.
All services support the query parameter contentType and the HTTP header Content-Type, with supported values application/json and application/xml. The query parameter takes precedence; if no content type is supplied, then application/json serves as the default.
The AC and ASO export services have a dateMask query parameter that must adhere to the Java java.text.SimpleDateFormat rules (for example, dateMask=yyyyMMdd&exportDate=20151012). All date parameters must be sent in this format, and output dates and timestamps are returned according to this format.
The Json/XML structure follows the corresponding DB table and view while being converted to Java standard. That is, underscores are removed, camel case is used, and first letter is lowercase. For example, the RSE_CONFIG APPL_CODE column is returned as applCode. All data is returned as type string.
Basic authentication is used, so you may use any client software that supports it. Authorization is done for ADF-LDAP (OID) mapped roles, and only administrator roles are used (that is, the calling user must be in a duty that is mapped to the roles in Table 15-1).
Table 15-1 Mapped Administrator Roles
| Service | Role | Mapped Role |
|---|---|---|
|
DT |
DemandTransferenceRole |
ANALYTIC_EXPERT_JOB |
|
CDT |
CustomerDecisionTreeRole |
ANALYTIC_EXPERT_JOB |
|
AC |
StoreClusterAdvancedRole |
CLUSTERING_ADMINISTRATOR_JOB |
|
ASO |
Administrator |
SPACE_ADMINISTRATOR_JOB |
|
CS |
CustomerSegmentAdvancedRole |
CUSTOMER_SEGMENT_ADMINISTRATOR_JOB |
This section provides a summary of web services.
Fetch Config Data
GET on /rase/resources/rse/parameters returns all RSE_CONFIG entries this user has access to (that is, all applCode RSE entries plus corresponding application entries). For example, if a user is in the ASO Administrator role, then the applCode SO will be returned as well. Here is a list of the fields:
applCode
paramName
paramValue
configurableFlg.
descr
Fetch One Entry
GET on applCode,paramName. For example, /rase/resources/rse/parameters/RSE,PRIMARY_LANGUAGE_CODE returns a particular entry, if the user has access to it.
Create an Entry
POST to /rase/resources/rse/parameters with a form having a single field called "content" and a value having the appropriate new parameter data in content type as specified by query parameter and header, if the user has access to it. The structure of the content must match what is returned by GET.
Update an Entry
PUT to applCode,paramName. For example, /rase/resources/rse/parameters/RSE, LOC_HIER_TYPE with the form having fields called paramName, paramValue, descr, and configurableFlg, along with appropriate values, if the user has access to it.
Batch Update Entries
PUT to /rase/resources/rse/parameters with a form having a single field called "content" and a value having appropriate parameter data in the content type as specified by query parameter and header. Note that if the user does not have access to a particular entry, it will be skipped. See The structure of the content must match what is returned by GET.
Fetch Data for an Entry
GET on applCode,paramName, paramCode. For example, /rase/resources/rse/parameters/DT,SIM_DISPLAY_CODE_PCT,2 returns data, if user has access to it.
applCode
paramName
paramCode
paramValue
configurableFlg
descr
Create an Entry
POST to applCode,paramName,paramCode. For example, /rase/resources/rse/parameters/DT,SIM_DISPLAY_CODE_PCT,2} with a form having a single field named "content" and a value having appropriate new parameter data in the content type as specified by query parameter and header, if the user has access to it. The structure of the content must match what is returned by GET.
Update an Entry
PUT to applCode,paramName, paramCode, For example, /rase/resources/rse/parameters/DT,SIM_DISPLAY_CODE_PCT,2 with form having a single field named "content" and value having appropriate parameter data in content type as specified by query parameter / header, if user has access to it.The structure of the content must match what is returned by GET.
Delete an Entry
DELETE to applCode,paramName, paramCode. For example, /rase/resources/rse/parameters/DT,SIM_DISPLAY_CODE_PCT,2, if the user has access to it.
Get Clusters
This service is based on rsestrclst.csv.
GET on /rase/resources/cis/export/cluster.
Parameters (in addition to dateMask and contentType) are all joined by logical AND:
Table 15-2 Advanced Clustering Export Parameters
| Name | Type | Required | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|---|
|
exportedDt |
Date |
Required |
Greater than or equal to this value |
|
effStartDt |
Date |
Required |
Greater than or equal to this value |
|
effEndDt |
Date |
Required |
Less than or equal to this value |
|
prodHierTypeExtKey |
String |
Required |
Equal to this value [] |
|
prodExtKey |
String |
Required |
Equal to this value |
|
locExtKey |
String |
Required |
Equal to this value |
|
locHierTypeExtKey |
String |
Required |
Equal to this value |
Get Segments
This service is based on rsestrclst.csv.
GET on /rase/resources/cis/export/segment.
Parameters (in addition to dateMask and contentType) are all joined by logical AND:
Table 15-3 Customer Segment Export Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
exportedDt |
Date |
Greater than or equal to this value |
|
effStartDt |
Date |
Greater than or equal to this value |
|
effEndDt |
Date |
Less than or equal to this value |
|
prodExtKey |
String |
Equal to this value |
ORASE Integration with ORCE (Customer Engagement)
This integration enables the application to send approved customer segments into Oracle Retail Customer Engagement (ORCE). Whenever customer segments are approved for merchandise, location in the application, web service call is made to ORCE in order to save segments, along with its members and relevant attributes.
Credential Store
You can use the Manage Credential Stores screen, shown in Figure 15-1, to maintain ORCE credentials in the application.
Enter the following information into Manage Credential Stores:
Table 15-4 Manage Credential Stores Information
| Field | Description |
|---|---|
|
Username |
Credential username created by ORCE to enable integration |
|
Password |
Credential password (at least one character) created by ORCE to enable integration |
|
Confirm Password |
Confirm password |
|
Description |
Credential store used for Customer Segment integration with Oracle Customer Engagement |
Configuration
The following configuration must be updated for integration. By default, ORCE integration is disabled.
Table 15-5 Configuration
| Configuration | Description |
|---|---|
|
CUST_SEG_WS_RELATE_FLG |
Flag to identify whether to publish customer segment to customer engagement. (Y/N) |
|
CUST_SEG_WS_RELATE_ORGID |
ORGID is the 3-letter ID provided by Oracle Customer Engagement to create and implement an authentication key. (REL) |
|
CUST_SEG_ATTR_WS_RELATE_FLG |
Flag to identify whether to publish customer segment attribute to customer engagement. (Y/N) |
|
CUST_SEG_RELATE_HOSTNAME |
URL host name to publish customer segment to customer engagement. This should be same as CN name in the certificate. |
|
CUST_SEG_RELATE_PORT |
Port number to publish customer segment to customer engagement. |
|
CUST_SEG_REL_SEGSERV_VERSION |
Segment service version to use for publishing customer segment to customer engagement. (format vX_0 - v3_0) |
|
CUST_SEG_REL_PROXY_HOSTNAME |
Proxy host name to publish customer segment to customer engagement. |
|
CUST_SEG_REL_HTTP_PROXY_PORT |
HTTP proxy port number to publish customer segment to customer engagement. |
|
CUST_SEG_REL_HTTPS_PROXY_PORT |
HTTPS proxy port number to publish customer segment to customer engagement. |
|
CUST_SEG_REL_BATCH_SIZE |
Number of customers to add in batches after customer segment to customer engagement is published. |
AIP/Replenishment Results
This service is based on so_assort_aiprepl_int.csv.
GET on /rase/resources/so/export/soAssortAipreplInt
Parameters (in addition to dateMask and contentType) are all joined by logical OR:
Table 15-6 AIP/Replenishment Results Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
assortmentSetId |
String |
Equal to this value |
|
exportedDt |
Date |
Greater than or equal to this value |
Output Aggregated Across Approved Runs
This service is based on so_assort_cm_int.csv.
GET on /rase/resources/so/export/soAssortCmInt.
Parameters (in addition to dateMask and contentType) are all joined by logical OR:
Table 15-7 Output Aggregated Across Approved Runs Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
assortmentSetId |
String |
Equal to this value |
|
exportedDt |
Date |
Greater than or equal to this value |
Assortment Result Details
This service is based on so_assort_int.csv.
GET on /rase/resources/so/export/soAssortInt.
Parameters (in addition to dateMask and contentType) are all joined by logical OR:
Table 15-8 Assortment Results Details Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
assortmentSetId |
String |
Equal to this value |
|
exportedDt |
Date |
Greater than or equal to this value |
Cross Reference Between Planograms and Finalized Assortments
This service is based on planogram_assortment.csv.
GET on /rase/resources/so/export/planogramAssortment.
Parameters (in addition to dateMask and contentType) all joined by logical OR:
Table 15-9 Cross Reference Between Planograms and Finalized Assortments Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
pogKey |
String |
Equal to this value |
|
exportDate |
Date |
Greater than or equal to this value |
POG Header
This service is based on planogram.csv.
GET on /rase/resources/so/export/planogram.
Parameters (in addition to dateMask and contentType) all joined by logical OR:
Table 15-10 POG Header Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
pogKey |
String |
Equal to this value |
|
exportDate |
Date |
Greater than or equal to this value |
POG Equipment Components
This service is based on equipment.csv.
GET on /rase/resources/so/export/equipment.
Parameters (in addition to dateMask and contentType) are all joined by logical OR:
Table 15-11 POG Equipment Components Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
pogKey |
String |
Equal to this value |
|
exportDate |
Date |
Greater than or equal to this value |
POG/Stores Cross Refererence
This service is based on planogram_store.csv.
GET on /rase/resources/so/export/planogramStore.
Parameters (in addition to dateMask and contentType) are all joined by logical OR:
Table 15-12 POG/Stores Cross Reference Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
pogKey |
String |
Equal to this value |
|
storeKey |
String |
Equal to this value |
|
exportDate |
Date |
Greater than or equal to this value |
Finalized Assortment Product Hierarchies
This service is based on product_hierarchy.csv.
GET on /rase/resources/so/export/productHierarchy.
Parameters (in addition to dateMask and contentType) are all joined by logical OR:
Table 15-13 Finalized Assortment Product Hierarchies Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
exportDate |
Date |
Greater than or equal to this value |
Finalized Assortment Products
This service is based on product_position.csv.
GET on /rase/resources/so/export/productPosition.
Parameters (in addition to dateMask and contentType) are all joined by logical OR:
Table 15-14 Finalized Assortment Products Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
pogKey |
String |
Equal to this value |
|
skuKey |
String |
Equal to this value |
|
exportDate |
Date |
Greater than or equal to this value |
Product Display Style Information
This service is based on sku_details.csv.
GET on /rase/resources/so/export/skuDetails.
Parameters (in addition to dateMask and contentType) are all joined by logical OR:
Table 15-15 Product Display Style Information Parameters
| Name | Type | Query Logic for Corresponding Column if Parameter is Provided |
|---|---|---|
|
skuKey |
String |
Equal to this value |
|
skuName |
String |
Equal to this value |
|
effectiveDate |
Date |
Greater than or equal to this value |
|
expiryDate |
Date |
Greater than or equal to this value |
|
exportDate |
Date |
Greater than or equal to this value |
