Load Property Values

The Load Property Values API is a load collection API that returns a list of values for a single property.
Load Property Values

Parameters

Name In Required? Description
ido Path Yes This is the name of the IDO collection.
prop Path Yes This is the name of an IDO property.
filter Query No This parameter restricts the result set. This can be any valid SQL WHERE clause.
orderby Query No This parameter is a comma-delimited list of properties that specifies the order in which the result set should be sorted. To have a property sorted in descending order, use the DESC keyword after the property name.
rowcap Query No This parameter specifies how many records are to be retrieved in each request. These are the valid values:
  • -1- This specifies that the system default record cap is to be used. This is typically 200, but it can be any number as set by the system administrator.
  • 0 - This value specifies that all records are to be retrieved, regardless of any record cap settings.
  • Any other positive integer specifies the number of records that are to be retrieved.
distinct Query No This parameter specifies that a set of data that represents only distinct combinations of requested properties is to be returned.

Headers

Name Description
Authorization If the API is called directly, then a Mongoose security token is obtained through a call to the GetSecurityToken API.

If the API is called through ION API, then a valid OAuth2.0 bearer token is provided by ION API.
X-Infor-MongooseConfig This is the name of a configuration that is available on the application server. This is required only when using the Mongoose API through the ION API.

Request data

None

Response data

[
   "jdelacruz",
   "jdoe"
]

Example

This example code returns a list of values for the specified property.

string xml = string.Empty;
 
using ( HttpClient client = new HttpClient() )
{
   string ido = "UserNames";
   string prop = "Username";
   string filter = "EditLevel%20LIKE%202";
   string requestUrl = $"http://server/IDORequestService/MGRESTService.svc/jsonlist/{ido}/{prop}/adv?filter={filter}";
 
   // provide token in the Authorization header
   client.DefaultRequestHeaders.TryAddWithoutValidation(
      "Authorization",
      "b/XdI6IQzCviZOGJ0E+002DoKUFOPmVDkwpQDbQj…==" );
 
   HttpResponseMessage response = client.GetAsync( requestUrl ).Result;
 
   using ( HttpContent content = response.Content )
   {
      Task<string> result = content.ReadAsStringAsync();
      xml = result.Result;
   }
}