PowerServer 2022 R2 Help
APIs for managing cache and cache group

Loads a cache.

Syntax: GET /api/Connection/LoadOne/{cacheGroup}/{cacheName}

{cacheGroup} indicates the cache group name, for example, Default.

{cacheName} indicates the cache to be loaded, for example, Sales.

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/LoadOne/Default/Sales")
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).

{
  "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
  }
}