Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Applies filtering to narrow down the results.

To filter by a string column, use the following format: 

ParameterRequiredTypeDescription
${returnType}YesstringSpecifies the format in which data should be returned. The format can be one of the following: json, csv, xlsx, or pdf.
fieldsVisibility Nojson/string
Specifies field visibility settings, for example:
Code Block
linenumberstrue
{ "lsgid": "1", "lsgn": "1", "lsgd": "1", "lsgsids": "1"}

where number "1" indicates that a specific field is visible.
Note that the order of the settings you make is important – when exported, the fields will be visible in exactly the same order you specify here.

rnNostringSpecifies the name of the report that will be displayed once the report has been exported to PDF or XLSX. For CSV and JSON formats this parameter will be ignored.
If you don't pass this parameter, it will be generated automatically for PDF and XLSX types. If provided, it cannot be left empty.
filterNojson/string
Code Block
languagejs
firstline1
linenumberstrue
[
    {
        "type": "string",
        "field": "${lsgn | lsgd}",
        "value": "${value}"
    }
]

To filter by a numeric column, use the following format: 

Code Block
linenumberstrue
[
    {
        "type": "numeric",
        "comparison": "${gt | lt | eq}",
        "field": "${lsgid}",
        "value": "${value}"
    }
]
limitNointegerSpecifies the number of records that must be returned. The value must be greater than zero.offsetNointegerSpecifies the offset of the first row to return.orderByNostring

Specifies the field by which you want to order your data records. The field name can be one of the following:

lsgid, lsgn, lsgd
orderDirectionNostringDetermines whether the sorting results will be displayed in ascending (ASC) or descending (DESC) order.

Response

The following code block shows an example result of a successful request.

Code Block
languagejs
firstline1
linenumberstrue
{
	"success": ${success}, 
	"msg": ${message}, 
	"data": [{
  		"lsgid": ${licenseServerGroupId}, 
  		"lsgn": ${licenseServerGroupName},
  		"lsgd": $licenseServerGroupHostname},
  		"lsgsids": ${licenseServerGroupServerIds}
	}],
	"code": ${errorCode},
	"totalCount": ${totalCount}
}

where the response fields can be explained as follows:

...

IDs of license servers that are a part of this group.

This field cannot be used for filtering and ordering.

...

Error message returned on failure.

...

Error code for unsuccessful request.

Standard format option. See Making an API request for details.
standard report optionsNovarious

See Making an API request for details.

Response

On success, this report will contain one row for each license server group. Each row consists of the following columns.


ColumnFull nameTypeVisible by default in export
lsgidLicense Server Group IDinteger(minus) No
lsgnGroup NamestringYes
lsgdDescriptionstringYes

Note that the order in the table is the default order of the columns in the exported file

...

.

Examples 

The following examples make use of the GET method. 

...