Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
19 AI Foundation Web Services
This chapter provides an overview of the AI Foundation Web Services. For additional details about any interfaces, see Oracle Retail Insights Cloud Service Suite/Oracle Retail Analytics and Planning Cloud Services Data Interface .
AI Foundation Web Services
AI Foundation 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. AI Foundation web services are REST-based; it is assumed that you are familiar with basic REST principles (such as the usage of HTTP verbs). AI Foundation 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 the AC export web service 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 the 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 export service has 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 the 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.
Authentication and Authorization
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 19-1).
Table 19-1 Mapped Administrator Roles
| Service | Role | Mapped Role |
|---|---|---|
| DT | DemandTransferenceRole | ANALYTIC_EXPERT_JOB |
| CDT | CustomerDecisionTreeRole | ANALYTIC_EXPERT_JOB |
| AC | StoreClusterAdvancedRole | CLUSTERING_ADMINISTRATOR_JOB |
| CS | CustomerSegmentAdvancedRole | CUSTOMER_SEGMENT_ADMINISTRATOR_JOB |
Summary of Web Services
This section provides a summary of web services.
Access to RSE_CONFIG Table
Fetch Config Data
GET on /rase/resources/rse/parameters returns all RSE_CONFIG entries a specific user has access to (that is, all applCode RSE entries plus corresponding application entries). For example, if a user is in an Administrator role, then the applCode SO will be returned as well. Here is a list of the fields:
-
applCode
-
paramName
-
paramValue
-
configurableFlg.
-
efere
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, efere, 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 the query parameter and header. Note that if the user does not have access to a particular entry, it will be skipped. The structure of the content must match what is returned by GET.
Access to RSE_CONFIG_CODE Table
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
-
efere
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 a value having appropriate parameter data in the 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.
Advanced Clustering Export
This section describes Advanced Clustering export.
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 19-2 Advanced Clustering Export Parameters
| Name | gType | 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 |
Customer Segment Export
This section describes Customer Segment export.
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 19-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 |
AIF 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, a 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 19-1, to maintain ORCE credentials in the application.
ee
a
Table 19-5 (Cont.) Configuration
| Configuration | Description |
|---|---|
| CUST_SEG_RELATE_HOSTNAME | URL host name to publish customer segment to customer engagement. This should be same as the 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. |
Retail Science Integration with XStore
Retail Science integrates with XStore; as part of this integration, XCenter broadcasts real time sales data with multiple transactions in one XML file to Retail Science. Retail Science, on receiving data, saves real time sales transactions, any price modifiers like promotions, price overrides, and returns in the database, which can be used as real time sales data for reporting.
This section provides the information necessary to send messages contained in version 1.0 of the POSLOG Services API. Information can be obtained using the Web Service Description Language (WSDL) in conjunction with a Simple Object Access Protocol (SOAP), XML Schema, and various methods contained in the classes of the API to provide the web service described below.
Endpoint
The URL for the WSDL is:
https://
The URL for the WSDL is: Retail Science SOAP endpoint is:https://
Authentication
Retail Science supports Basic Authentication integration with XCenter over https, using a username and password. XCenter integration with Retail Science relies on SSL to do the encryption of the username/password configuration. After a user is defined in Retail Science, XCenter must be configured with the userid/password, and Xcenter will use Base64-encoding and include it as part of the Http authorization header when invoking the SOAP service.
In this guide
- Guide: AI Foundation Implementation Guide
- Previous: 18 Attribute Processing
- Next: 2 Implementation Overview
Related chapters
- 17 Configuration — AI Foundation Implementation Guide · shares
ANALYTIC_EXPERT_JOB,APPL_CODE,CLUSTERING_ADMINISTRATOR_JOB,CUSTOMER_SEGMENT_ADMINISTRATOR_JOB - 20 Batch Processing — AI Foundation Implementation Guide · shares
APPL_CODE,RSE_CONFIG_CODE