Retrieve Users By Company Code, User ID, Employee No and Created Date

Updated on 01 Oct 2025
1 Minute to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback!

Get

/sys-rest-api/rest/1/sduser

Retrieve Users By Company Code, User ID, Employee No and Created Date

This endpoint retrieves users information with the option to filter and optimize the request performance using the following parameters:

Finder Name:
SdUserFinder

Request Parameters:
UserID (query parameter) - User ID
CompCode (query parameter) -Company Code

Emp No (query parameter) - Employee Code
Create Date (query parameter) -Created Date

Response Body:
The response will contain the details of the user in the JSON format. Here is an example of the response body:

{
    "VAddCode": null,
    "VCompCode": "",
    "VConfigCode": null,
    "VConfigDesc": null,
    "VContactCode": "",
    "VCountry": null,
    "VDbUserFlag": "",
    "VDefaultConsoleDesc": null,
    "VDefaultConsoleName": null,
    "VEmail": "",
    "VEmpNo": "",
    "VFaxNum1": null,
    "VFirstName": "",
    "VIuCreateDate": "",
    "VLastName": "",
    "VPortalLdapUser": "",
    "VPortalUser": "",
    "VPostalCode": null,
    "VRegionCode": null,
    "VUser": "",
    "VUsrPassword": " ",
    "VUsrPasswordRetype": "",
    "VUuid": "",
    "VWorkPhoneNum": null,
    "VLdapServerName": null,
    "links": [
        {
            "rel": "",
            "href": "",
            "name": "",
            "kind": ""
        },
        {
            "rel": "",
            "href": "",
            "name": "",
            "kind": ""
        }
    ]
}

Security

HTTP

Type basic

Basic authentication

Query parameters

limit

integer

Example25

offset

integer

Example0

totalResults

boolean

Exampletrue

finder

string

ExampleSdUserFinder; UserID=Adam,CompCode =ZZ,EmpNo =,CreateDate =2025-07-09

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [
    {
      "VAddCode": null,
      "VCompCode": "ZZ",
      "VConfigCode": null,
      "VConfigDesc": null,
      "VContactCode": "ASandler12",
      "VCountry": null,
      "VDbUserFlag": "N",
      "VDefaultConsoleDesc": null,
      "VDefaultConsoleName": null,
      "VEmail": "Test@cmic.ca",
      "VEmpNo": null,
      "VFaxNum1": null,
      "VFirstName": "Adam",
      "VIuCreateDate": "2025-07-09T21:36:45Z",
      "VLastName": "Sandler",
      "VPortalLdapUser": "Adam",
      "VPortalUser": "Adam",
      "VPostalCode": null,
      "VRegionCode": null,
      "VUser": "Adam",
      "VUsrPassword": " *******************",
      "VUsrPasswordRetype": " *******************",
      "VUuid": "39862B1553D724B9E0630B811DAC5177",
      "VWorkPhoneNum": null,
      "VLdapServerName": "Default",
      "links": [
        {
          "rel": "self",
          "href": "http://localhost:7101/sys-rest-api/rest/1/sduser/39862B1553D724B9E0630B811DAC5177",
          "name": "sduser",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://localhost:7101/sys-rest-api/rest/1/sduser/39862B1553D724B9E0630B811DAC5177",
          "name": "sduser",
          "kind": "item"
        }
      ]
    }
  ],
  "totalResults": 1,
  "count": 1,
  "hasMore": false,
  "limit": 25,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://localhost:7101/sys-rest-api/rest/1/sduser",
      "name": "sduser",
      "kind": "collection"
    }
  ]
}

object

What's Next

Retrieve a Specific User By VUUID

Retrieve Users By Company Code, User ID, Employee No and Created Date

Retrieve Users By Company Code, User ID, Employee No and Created Date

What's Next

Contact Us