Load Property Values

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

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;
   }
}