LoadAll

Loads all cache groups (and caches in it).

Syntax: GET /api/Connection/LoadAll

PowerScript code example:

Integer li_rc
String ls_body 
httpclient  lhc_client
lhc_client = create httpclient

lhc_client.setrequestheader("Content-Type", "application/json;charset=UTF-8",true)

li_rc  = lhc_client.sendrequest( "GET", "http://172.25.100.32:5000/api/Connection/LoadAll")
if li_rc = 1 and lhc_client.getresponsestatuscode( ) = 200 then
 lhc_client.getresponsebody(ls_body)
end if

When successful, it returns the response status code 200 and the following response body. View here for details about the parameters in the response body.

When failed, it returns 400 (bad request), 401 (unauthorized), or 500 (server error).

[
  {
    "cacheGroup": "string",
    "items": [
      {
        "cacheName": "string",
        "configuration": {
          "connectionType": 0,
          "host": "string",
          "port": 0,
          "odbcName": "string",
          "odbcDriver": "string",
          "userID": "string",
          "password": "string",
          "database": "string",
          "enablePooling": true,
          "minPoolSize": 0,
          "maxPoolSize": 0,
          "connectionLifetime": 0,
          "connectionTimeout": 0,
          "commandTimeout": 0,
          "otherOptions": "string",
          "securityOptions": "string",
          "dynamicConnection": true
        }
      }
    ]
  }
  {
    "cacheGroup": "string",
    ...
  }
]