- 18 Dec 2024
- 6 Minutes to read
- Print
- DarkLight
/Endpoint/rest/api/v1/Users
- Updated on 18 Dec 2024
- 6 Minutes to read
- Print
- DarkLight
Utilize this method to execute a query designed to fetch comprehensive information, delivering all results in a singular response. If necessary, the method returns a portion of the results along with an identifier to retrieve the remaining data.
Leverage the search service to extract the requisite information from the system effectively.
The method returns a list structured with an extended User
representation. In this format, all foreign key fields are depicted as abstract object structures, employing AbstractText
or AbstractLong
data types. This offers an enriched and detailed perspective of the data and its associated entities.
The foreign key fields involved are: ``
Example
It searches for employees whose data has been modified since January 1, 2022, and belong to departments with external system identifiers DE001 and DE002. The system responds by returning the name, external identifier, and email address of the relevant employees. The retrieved information is organized in ascending order by the person's name, and a limit is set to return a maximum of 1000 rows.
fields=Name,ExternalId,Email&Filters=(DepartmentId.ExternalId In DE001;DE002) AND (ModifiedOn > 2022-01-01)&Orders=Name ASC&PageSize=1000
oAuth autentication flow
Specify the fields you want to retrieve in the fields parameter and use the GET method of the resource.
The list of database column attributes. If list is empty or "*" then all of fields will be returned.
This method converts a string list to a string with a comma separator.
Example:
Id, Name, Username, Email, MobilePhone, External_Id, Creation_Date, Last_Login, Is_Active
In the List methods, filtering of resources can be performed using filter parameters.
You can also use parent tables as a search filter. For example, the Employee
table has a DepartmentId
field, so you can search for a department name using the DepartmentId.Name
field name. All fields in the parent table are available.
The name of the entity field. Example: Name
or relation field OwnerId.Name
Please refer to the corresponding method's documentation for the complete list of supported filter parameters by record.
The operator must be a standard comparison operator =, <>, >, >=, <, <=, In, Like, NotIn
You can add multiple values separated by comma when using the In
, NotIn
operators. Example of text field; USA; FIN; ARE
Example of numeric field; 1, 2, 3
Example of filters:
Filters=(DepartmentId.Name = My Department) AND (DepartmentId.CreatedOn = 2021-01-01)
Filters=(DepartmentId.Name = My Department 1) OR (DepartmentId.ExternalId In DE001;DE002)
Filters=ExternalId In S100;S101;S120;100
Filters=Id = 100
The Orders
parameter is provided for sorting the result in the desired order. Both the attribute based on which sorting needs to be done, and the order of sorting (ascending or descending) can be specified. This method converts a string list to a string with a comma separator.
Example:
Name DESC, CreatedOn ASC
This field specifies the current page of results being returned. It's often used in conjunction with PageSize
to manage pagination by indicating which subset of the total data is currently being retrieved.
The field indicates the number of items returned in a single page or response. It helps clients determine how many items to display per page and how to request additional pages if needed.
The value ranges from 1
to 1000
and defaults to 50
.
The list of Users
The list of User
records
The object provides metadata about the list of items returned in the API response. It typically includes information that helps clients understand and work with the data.
This field represents the total number of items available in the entire dataset, not just the items returned in the current response. It's useful for implementing pagination, as clients can use it to calculate the number of pages or total available items.
This field specifies the current page of results being returned. It's often used in conjunction with PageSize
to manage pagination by indicating which subset of the total data is currently being retrieved.
The field indicates the number of items returned in a single page or response. It helps clients determine how many items to display per page and how to request additional pages if needed.
The type of the record
The list of User records
The record of User information.
Unique identifier of the user.
Full name of the user.
Login name of the user.
Email contact of the user.
Mobile phone number of the user.
The user identifier in an external system to the Platform.
The date the user was created.
Last time the user logged in the application.
Indicates if the user is still active.
Bad Request - The user has provided input that the browser is unable to convert.
{
"Errors": [
"The user has provided input that the browser is unable to convert.",
"There are multiple rows in the database for the same value",
"The value does not match the specified entity structure",
"..."
],
"Type": "/Errors/Bad Input",
"Title": "Bad Request",
"StatusCode": 400,
"Instance": "/OpenApi/rest/Xzy",
"RequestKey": "894ea43c-b8a6-4195-9a9c-82c07d9cc33a"
}
The list of errors. Throw specific exceptions based on the received error.
Human-readable explanation of the errors
URI identifier that categorizes the error
Brief, human-readable message about the error
The HTTP response code
URI that identifies the specific occurrence of the error
Provides a request key that identifies the current request.
Unauthorized - The response status code indicates that the client request has not been completed because it lacks valid authentication credentials for the requested resource.
{
"Errors": [
"The session Id or OAuth token used has expired or is invalid."
],
"Type": "/Errors/Unauthorized",
"Title": "Unauthorized",
"StatusCode": 401,
"Instance": "/OpenApi/rest/Xzy",
"RequestKey": "894ea43c-b8a6-4195-9a9c-82c07d9cc33a"
}
The list of errors. Throw specific exceptions based on the received error.
Human-readable explanation of the errors
URI identifier that categorizes the error
Brief, human-readable message about the error
The HTTP response code
URI that identifies the specific occurrence of the error
Provides a request key that identifies the current request.
Forbidden - The user does not have access to execute operation
{
"Errors": [
"The user does not have access to execute operation"
],
"Type": "/Errors/Permission",
"Title": "Bad Request",
"StatusCode": 403,
"Instance": "/OpenApi/rest/Xzy",
"RequestKey": "894ea43c-b8a6-4195-9a9c-82c07d9cc33a"
}
The list of errors. Throw specific exceptions based on the received error.
Human-readable explanation of the errors
URI identifier that categorizes the error
Brief, human-readable message about the error
The HTTP response code
URI that identifies the specific occurrence of the error
Provides a request key that identifies the current request.
Internal Server Error - An internal server error is an error on the web server you're trying to access.
{
"Errors": [
"An internal server error is an error on the web server you're trying to access."
],
"Type": "/Errors/Internal Server Error",
"Title": "Internal Server Error",
"StatusCode": 500,
"Instance": "/OpenApi/rest/Xzy",
"RequestKey": "894ea43c-b8a6-4195-9a9c-82c07d9cc33a"
}
The list of errors. Throw specific exceptions based on the received error.
Human-readable explanation of the errors
URI identifier that categorizes the error
Brief, human-readable message about the error
The HTTP response code
URI that identifies the specific occurrence of the error
Provides a request key that identifies the current request.