a!sblQuery() Function

Retrieves records from Siebel.


a!sblQuery( scsExternalSystemKey, usePerUserCredentials, hostname, port, enterpriseApp, appManager, language, parameters, sort)

Common Parameters:

scsExternalSystemKey: (Text) The key from the Third Party Credentials admin console page that corresponds to the set of credentials that should be used to authenticate.

usePerUserCredentials: (Boolean) If true the credentials set in the Third-Party Credentials settings page by the current user running the expression will be used. If false the site-wide credential values will be used.

hostname: (Text) The hostname of the Siebel server. For example, siebel.example.com.

port: (Number (Integer)) The port the Siebel server is listening on. For example, 2321.

enterpriseApp: (Text) The enterprise application of the target system. For example, "SBA_82".

appManager: (Text) The active application manager of the target system. For example, "SSEObjMgr_enu".

language: (Text) The target system language. For example, "enu".

Specific Parameters:

parameters: (Any Type) The records to query, given as a dictionary with the field structure of the Siebel Business Component and Business Object.

sort: (Any Type) The sort order to apply to the query, given as a dictionary with field names based on the fields of the Business Object and values of "ASCENDING" or "DESCENDING".


The function returns the standard connector result dictionary described in the main Connectors page.

If successful, the result field contains an array of dictionaries with the Siebel records that match the given query parameters, sorted according to the given sort parameter.


Display Orders from Siebel

Copy and paste the expression into the Interface Designer, save it, then call the interface in a Tempo Report to test.

  local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 10),
  local!queryResult: a!sblQuery(
    scsExternalSystemKey: cons!SBL_SCS_KEY,
    usePerUserCredentials: true,
    hostname: cons!SBL_HOSTNAME,
    port: cons!SBL_PORT,
    enterpriseApp: cons!SBL_APP,
    appManager: cons!SBL_APP_MANAGER,
    language: cons!SBL_LANGUAGE,
    parameters: {
      'Order Entry (Sales)': {
        'Order Entry - Orders': {
          "Order Number",
          "Order Type"
    sort: {}
    local!datasubset: todatasubset(
        if(local!queryResult.success, local!queryResult.result.Result, {}),
        totalCount: local!datasubset.totalCount,
        columns: {
            label: "Id",
            data: index(local!datasubset.data, "Id", ""),
            links: apply(a!dynamicLink(value: _, saveInto: ri!selectedItem), local!datasubset.data)
            label: "Order Number",
            data: index(local!datasubset.data, "Order Number", "")
            label: "Status",
            data: index(local!datasubset.data, "Status", "")
            label: "Order Type",
            data: index(local!datasubset.data, "Order Type", "")
        value: local!pagingInfo,
        saveInto: local!pagingInfo
        readonly: true,
        value: local!queryResult.error.title