Versions Compared

Key

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

Obtaining information about usage history for feature
Anchor
obtain
obtain

 

...

If you want to obtain retrieve information about usage history for a single feature, you have to use we recommend that you use the following URL request template.

 

Code Block
languagejs
firstline1
linenumberstrue
GET /api/v1/report/usage-history/feature/${featureId}/${returnType}?sd=${startDate}&ed=${endDate}&granularity=${granularity}$(additional parameters, as needed)

...

 - $ indicates a variable value that you can replace with an appropriate value, as needed

 - the possible parameters are as follows:

ParameterRequiredTypeDescription
${featureId}Yesinteger

You can obtain feature information hereSpecifies feature-specific parameters.

${returnType}YesstringSpecifies the format in which license usage data should will be returned. The format can be one of the following: json, csv, xls, xlsx or pdf.
sdYesstringSpecifies the start date for which the report will be generated in YYYY-MM-DD format; for example, 20162017-01-20.
edYesstringSpecifies the end date for which the report will be generated in YYYY-MM-DD format; for example, 20162017-01-27.
granularityYesinteger

Specifies granularity of the returned data ; Can and can be one of the following:

  • quarter Quarter - 2
  • month Month - 3
  • week Week - 4
  • day Day - 5
  • hour Hour - 6
rn

No

string

Specifies the name of the report that will be displayed once the report has been exported to PDF or XLS. For CSV and JSON types it is formats this parameter will be ignored.
If you don't pass this parameter, it will be generated automatically for PDF and XLS types. If it is provided, it mustn't cannot be left empty.

filterNojson/string

Applies filtering license usage data on all fields.

To filter by string column, use the following format: 

Code Block
languagejs
[
	{ 
		"type": "string",
		"field": "lud",
		"value": "${value}"
	}
]

To filter by numeric column, use the following format:

Code Block
languagejs
[
	{ 
		"type": "numeric", 
		"comparison": "${gt | lt | eq}", 
		"field": "${lumin | lua | lumax | lbmin | lbmax | ldtc | hu | ft}",
		"value": "${value}" 
	}
]


fieldsVisibilityNojson/string

Specifies field visibility settings, for examplelike this:

Code Block
languagejs
{ 
	"lud": "1", 
	"lumin": "1", 
	"lua": "1", 
	"lumax": "1", 
	"lbmin": "1", 
	"lbmax": "1", 
	"ldtc": "1", 
	"hu": "1", 
	"ft": "1"
}

where number "1" indicates that a specific field is visible , and ''0" indicates that it is not.

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.

limitNointegerDetermines the maximum number of data records that can 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:

lud | lumin | lua | lumax | lbmin | lbmax | ldtc | hu | ft
orderDirectionNostringDetermines the sorting results order. Can be one of the following: ASC, DESC.

...

where the response fields can be explained as follows:

FieldTypeDescription
successbooleanThis field indicates Indicates that the your API request was successfully processed.
msgstringError message returned on failure.
fidintegerFeature IdID.
ludstringFor Granularity hour - Datetime, for rest Date, which indicates point in time that data are about

Indicates period of time for which usage information is generated, i.e. date and time for hourly usage and dates for the remaining granularity options.

luminintegerMinimal licenses used count for given date.
luafloatAverage licenses used count for given date.
lumaxintegerMaximum licenses used count for given date.
lbminintegerMinimal licenses borrowed count for given date.
lbmaxintegerMaximum licenses borrowed count for given date.

ldtc

integerDenials count.
hufloatHours used.
ftintegerFeature total.
codeintegerError code if . On success, it equals false, ; otherwise it is null otherwise.
totalCountintegerTotal number of rows returned.

 

...

Obtaining information about usage history comparison for feature

If you want to obtain information about usage history comparison for feature comparison, you have to use we recommend that you use the following URL request template.

Code Block
languagejs
firstline1
linenumberstrue
GET /api/v1/report/usage-history/comparison/json?fi=${featureIds}&sd=${startDate}&ed=${endDate}&granularity=${granularity}

The possible Possible parameters are as follows:

ParameterRequiredTypeDescription
featureIdsYesarrayArrays of feature ids in format: id1, id2, id3... for example fi=1,2,3,5
sdYesstringSee Usage History For Feature Obtaining information about usage history for feature, above.
edYesstringSee Usage History For Feature Obtaining information about usage history for feature, above.
granularityYesintegerSee Usage History For Feature Obtaining information about usage history for feature , above.

Currently this the report is only returned only in jsonJSON syntax. There are plans to introduce csvCSV, xls XLS and pdf PDF formats in the future.

If your request is successful, you should see a response similar to the following:

Code Block
languagejs
{
	"success": ${success},
  	"msg": ${message},
  	"data": [
    	{
      		"fid": ${featureId_1},
      		"lud": ${date},
      		"lumin": ${minUsed},
      		"lua": ${averageUsed},
      		"lumax": ${maxUsed},
      		"lbmin": ${minBorrowed},
      		"lbmax": ${maxBorrowed},
      		"ldtc": ${denials},
      		"hu": ${hoursUsed},
      		"ft": ${total}
    	},
		{
      		"fid": ${featureId_2},
      		"lud": ${date},
      		"lumin": ${minUsed},
      		"lua": ${averageUsed},
      		"lumax": ${maxUsed},
      		"lbmin": ${minBorrowed},
      		"lbmax": ${maxBorrowed},
      		"ldtc": ${denials},
      		"hu": ${hoursUsed},
      		"ft": ${total}
    	}
  	],
  	"code": ${code},
  	"totalCount": ${count}
}

The meaning of all fields are where the fields carry the same values as in Usage History For Feature.

...

the ones explained in Obtaining information about usage history for feature, above.

Obtaining information about usage history for license server

If you want to obtain information about usage history for all visible features for a given server, you have to use we recommend that you use the following URL request template.

Code Block
languagejs
firstline1
linenumberstrue
GET /api/v1/report/usage-history/license-server/${lsid}/${returnType}?sd=${startDate}&ed={endDate}&granularity=${granularity}$(additional parameters, as needed)

The possible Possible parameters are as follows:

ParameterRequiredTypeDescription
${lsid}YesintegerLicense Server IdID.
${returnType}YesstringSee Usage History For Feature Obtaining information about usage history for feature, above.
sdYesstringSee Usage History For Feature Obtaining information about usage history for feature, above.
edYesstringSee Usage History For Feature Obtaining information about usage history for feature, above.
granularityYesintegerSee Usage History For Feature Obtaining information about usage history for feature, above.
rnNostringSee Usage History For Feature See Obtaining information about usage history for feature, above.
filterNojson/string

Applies filtering license usage data on all fields.

To filter by string column, use the following format: 

Code Block
languagejs
[
	{ 
		"type": "string", 
		"field": "${lud | fns | fv | ftype}",
		"value": "${value}"
	}
]

To filter by numeric column, use the following format:

Code Block
languagejs
[
	{ 
		"type": "numeric", 
		"field": "${lumin | lua | lumax | lbmin | lbmax | ldtc | hu | ft}",
		"value": "${value}"
	}
]


fieldsVisibilityNojson/string

Specifies field visibility settings, for example:

Code Block
languagejs
{ 
	"lud": "1", 
	"lumin": "1", 
	"lua": "0", 
	"lumax": "1", 
	"lbmin": "1", 
	"lbmax": "1", 
	"ldtc": "1", 
	"hu": "0", 
	"ft": "0",
	"fns": "1",
	"fv": "1",
	"ftype": "1"
}
 

where number "1" indicates that a specific field is visible, ''0" indicates it is not.

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.

limitNointegerSee Usage History For Feature Obtaining information about usage history for feature, above.
offsetNointegerSee Usage History For Feature Obtaining information about usage history for feature, above.
orderByNostring

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

lud | fns | fv | ftype | fid | lumin | lua | lumax | lbmin | lbmax | ldtc | hu | ft
orderDirectionNostringSee Usage History For Feature Obtaining information about usage history for feature, above.

If your request is successful, you should see a response similar to the following:

...

where the response fields can be explained as follows:

FieldTypeDescription
successbooleanThis field indicates Indicates that the API request was successfully processed.
msgstringError message returned on failure.
fidintegerFeature IdID.
ludstringFor Granularity hour - Datetime, for rest Date, which indicates point in time that data are aboutIndicates period of time for which usage information is generated, i.e. date and time for hourly usage and dates for the remaining granularity options.
luminintegerMinimal licenses used count for given date.
luafloatAverage licenses used count for given date.
lumaxintegerMaximum licenses used count for given date.
lbminintegerMinimal licenses borrowed count for given date.
lbmaxintegerMaximum licenses borrowed count for given date.

ldtc

integerDenials count.
hufloatHours used.
ftintegerFeature total.
codeintegerError code if . On success, it equals false, ; otherwise it is null otherwise.
totalCountintegerTotal number of rows returned.
fnsstringFeature name.
ftypestringFeature type.
fvstringFeature version.

If any of the requests has invalid or missing paramsparameters, HTTP 400 BAD REQUEST is returned.