Skip Navigation
Knowledge Advanced analytics for Search REST API questions
Answer ID 10387   |   Last Review Date 01/16/2020

Why do my search questions from the Knowledge Advanced Search REST API not show up in the analytics database tables?


Oracle B2C Service Knowledge Advanced


The application I am building uses the Search REST API and performs authentication and session initialization to retrieve an integrationUserToken and session respectively. The questions that are asked via the Search REST API endpoints /search/question or /contactDeflection/question are not available in the okcs_stg_question, okcs_stg_annotation or okcs_stg_answers tables. The value of knowledgeInteractionId populates the session_ref colum in the okcs_stg_question and okcs_stg_annotation tables and the okcs_session_ref column in the okcs_stg_answers table.


Knowledge Advanced searches can be performed from anywhere using the Search REST API and are available in the analytics tables when the following is included in the request to the /question endpoint.

The full request must contain:

  • Headers
    • accept: application/json or application/xml
    • content-type: application/json or application/xml
    • kmauthtoken:{"siteName":"<sitename>","interfaceId":"1","localeId":"en-US","knowledgeInteractionId":"<value for session_ref>","integrationUserToken":"<token>"}
  • Body
    • {"session":"<session from initial endpoint>","locale":"en-US","resultLocales":"en-US"}
    • (or appropriate XML)
  • Example endpoint: https://<name-of-site><your question>

For further information on the Search REST API
Knowledge Advanced Search REST API Endpoints
Knowledge Advanced REST API Authenticate and Authorize
Generate knowledge interaction ID
Generate search session ID and initial transaction ID

Generally, begin with the request elements listed as required in the documentation and beyond that only add elements specific to your application needs.

The interfaceId should be the ID of the interface on which you wish to search, not necessarily 1.

Use of the initialScreen endpoint for one-time session initiation is recommended as a best practice. Those sessions should not be reused between different users, such as those who are not logged in. Rather than using initialScreen, you could generate a search session by not supplying one in a call to the search/question endpoint and retain it for subsequent requests. However, the transactionId will always be 0 unless it is supplied in the body by the client in that same initial call. Hence, initialScreen is recommended as a best practice -- another benefit being that it has no required body parameters. The empty JSON string {} works for initialScreen.

When using navigation or pagination, you should always pass priorTransactionId as a query parameter and supply a different transactionId in each request body (e.g. incremented from the priorTransactionId).

The hostname for https://<name-of-site> may be different than the name of the interface(s). The search API base URL can be found from within the Customer Portal framework by retrieving the configuration setting OKCS_SRCH_API_URL. Similarly, the content REST API access point https://<name-of-site> is the value of OKCS_IM_API_URL. You may choose to use latest/ or a versioned call to v1/ for backward compatibility in the event that a new version of the API is introduced.