Calem Blogs

Blogs of CalemEAM

How to Include Category Attributes in API Fetch

​Category attributes are dynamic attributes relevant to an asset, or a location used as a configuration element (CE). For instance, an computer server asset may include memory size and CPU model while a truck tire asset may include minimum and maximum pressure values. See this blog for more information about category attributes.

Category attributes are not included by default when fetching data by Calem Enterprise APIs. For instance, a data fetch API call results in 500 records selected. These records will not include category attributes. A new query parameter is added to include category attributes. Adding this parameter may cause the API call to take longer time since Calem Enterprise needs to fill out category attributes for each record selected. 

  • "ctg" is the new query parameter. Its value of "1" (number one) will include category attributes in data fetch.
  • The code snippet (in PHP) below shows how this parameter is used in data search
    • "w" is the query string
    • "o" is the order by clause
    • "l" is the limit clause
    • "ctg" is the parameter to include category attributes
    • "$auth" is the authorization token calculated - see Calem Enterprise API Guide for more info.
//Fetch locations with location name starting with CTR
//Order by location ascending
//Get only 5 records starting from the 5th record
//Include category attriburtes in the data fetch
$w=urlencode("cm_location.location like 'CTR%'");
$o=urlencode("location ASC");

$response = \Httpful\Request::get('http://localhost/CalemEnt/trunk/api/search/cm_location?'
 ->addHeader('Authorization', $auth)->send();

The response data is encoded in JSON. Category attributes (ending with "_wxyz" such as "_4859") are included as shown in the example below. 

Limit Editing to Approved Changes
How to Manage Asset Status from Work Orders