a!sblQuery() Function

Function

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

Retrieves records from Siebel.

Parameters

Keyword Type Description

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 application server host of the SAP server (ASHOST). The value can be an IP address, a fully-qualified domain name, or SAP's router string format. For example, "/H/sap_router/W/password/H/app_host/S/service_port".

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".

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".

parameters

Any Type

The records to query, given as a dictionary with the field structure of the Siebel Business Component and Business Object.

Returns

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.

Usage considerations

If called multiple times in the same expression with the same parameters, only one query is made to Siebel when the expression is evaluated and the result is reused for each identical call. This caching only applies within a single expression evaluation. Return values are not cached in separate expressions, or in separate evaluations of the same expression.

Examples

Copy and paste an example into an Appian Expression Editor to experiment with it.

Display orders from Siebel

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
a!localVariables(
  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': {
          "Id",
          "Order Number",
          "Status",
          "Order Type"
        }
      }
    },
    sort: {}
  ),
  local!datasubset: todatasubset(
    if(local!queryResult.success, local!queryResult.result.Result, {}),
    local!pagingInfo
  ),
  if(local!queryResult.success,
    a!gridField(
      data: local!datasubset,
      columns: {
        a!gridColumn(
          label: "Id",
          value: a!dynamicLink(
            value: index(fv!row, "Id", ""),
            saveInto: ri!selectedItem)
        ),
        a!gridColumn(
          label: "Order Number",
          value:  index(fv!row, "Order Number", ""),
        ),
        a!gridColumn(
          label: "Status",
          value:  index(fv!row, "Status", ""),
        ),
        a!gridColumn(
          label: "Order Type",
          value:  index(fv!row, "Order Type", ""),
        )
      },
      saveInto: local!pagingInfo,
      rowHeader: 2
    ), 
    a!textField(
      label:"Error",
      readonly: true,
      value: local!queryResult.error.title
    )
  )
)
)
Open in Github Built: Fri, Dec 03, 2021 (02:38:50 PM)

On This Page

FEEDBACK