Get All Users Across Companies
get
/rest/v19/users
Gets list of users across companies as JSON or as a Zip file depending on Accept type passed in the request header.
Request
Query Parameters
-
excludeLinks: string
Exclude given link types from response. Supported only with produces type application/json.Allowed Values:
[ "self", "child", "parent", "canonical", "next", "prev", "related" ] -
expand: string
Allows expansion of relationships. Supported only with produces type application/json.Allowed Values:
[ "groups", "accessPermissions" ] -
fields: string
User fields to be returned in response. Supported only with produces type application/json.
-
limit: integer
Specifies no.of records to be fetched. Supported only with produces type application/json.
-
offset: integer
Spefifies the starting point from which records to be fetched. Supported only with produces type application/json.
-
orderby: string
Specifies a comma-separated list of fields to order the response by. Supported only with produces type application/json.
-
q: string
Criteria to filter the users. By default no filtering is applied.
-
totalResults: boolean
Specifies if the total record to be included in response or not. Supported only with produces type application/json.
Response
Supported Media Types
- application/json
- application/zip
Default Response
List of users.
Root Schema : user-collection
Type:
Show Source
object-
items:
array List of users
Title:
List of usersList of users
Nested Schema : user
Type:
Show Source
object-
accessPermissions:
object Access Permissions
Title:
Access PermissionsAccess Permissions of a user -
approvalDelegate:
string
Title:
Approval DelegateApproval Delegate -
billAddress1:
string
Title:
Billing Address 1Billing Address 1 -
billAddress2:
string
Title:
Billing Address 2Billing Address 2 -
billCity:
string
Title:
Billing CityBilling City -
billCompany:
string
Title:
Billing CompanyBilling Company -
billCompany2:
string
Title:
Billing Company 2Billing Company 2 -
billCountry:
string
Title:
Billing CountryBilling Country -
billEmail:
string
Title:
Billing EmailBilling Email -
billFax:
string
Title:
Billing FaxBilling Fax -
billFirstName:
string
Title:
Billing First NameBilling First Name -
billLastName:
string
Title:
Billing Last NameBilling Last Name -
billPhone:
string
Title:
Billing PhoneBilling Phone -
billStateProvince:
string
Title:
Billing StateBilling State -
billZip:
string
Title:
Billing ZipBilling Zip -
company:
object Company details
Title:
Company detailsUser Company details. Applicable only for Users Across Companies -
currency:
object Currency
Title:
CurrencyCurrency preference of user. Value holds currency code -
dateAdded:
string
Title:
Date AddedUser creation date -
dateFormat:
object Date Format
Title:
Date FormatUser preferred date time format -
dateModified:
string
Title:
Date ModifiedUser modified date -
email:
string
Title:
EmailEmail of the user -
enabledForSso:
object Enabled For SSO
Title:
Enabled For SSOEnabled For SSO -
externalSsoId:
string
Title:
External SSO IdExternal SSO Id -
fax:
string
Title:
Fax NumberFax of the user -
firstName:
string
Title:
First NameFirst Name of the user -
groups:
object Groups
Title:
GroupsGroups to which the user belongs -
isAccessAdminPermEnabled:
boolean
Title:
Access Admin Permission EnabledAccess Admin Permission Enabled -
isApplicationAdminPermEnabled:
boolean
Title:
Application AdministratorIndicates whether user is an Application Administrator. -
isMobileEnabled:
boolean
Title:
Is Mobile EnabledIs Mobile Enabled -
isNotifyEmail:
boolean
Title:
Is Notification Preference EmailIs notification preference email -
isNotifyFax:
boolean
Title:
Is Notification Preference FaxIs notification preference fax -
isProxyPermEnabled:
boolean
Title:
Proxy Permission EnabledProxy permission enabled -
isUserAdminPermEnabled:
boolean
Title:
Is User Admin Permission EnabledIs User Admin Permission Enabled -
isWebServicesOnly:
boolean
Title:
Web Services OnlyWeb Services Only -
jobTitle:
string
Title:
Job TitleJob Title of the user -
language:
object Language
Title:
LanguageLanguage preference of user. Value holds language code -
lastLogin:
string
Title:
Last Login DateUser last loggedin date -
lastName:
string
Title:
Last NameLast Name of the user -
links:
array Links to the related objects
Title:
Links to the related objectsLinks to the related objects -
login:
string
Title:
Login IdLogin Id of the user -
numberFormat:
object Number Format
Title:
Number FormatPreferred number format of user -
oauthClientId:
string
Title:
OAuth client IdClient Id of the OAuth client that has a 1-to-1 association with the user -
partnerLogin:
string
Title:
Partner LoginPartner Login -
partyId:
integer(int64)
Title:
Party Id of the userParty Id of the user -
partyNumber:
string
Title:
Party Number of the userParty Number of the user -
phone:
string
Title:
Phone NumberPhone number of the user -
separateShipAddr:
boolean
Title:
Seperate Ship AddressSeperate Ship Address -
sfdcOrgId:
string
Title:
SFDC Organization IDSFDC Organization ID -
shipAddress1:
string
Title:
Shipping Address 1Shipping Address 1 -
shipAddress2:
string
Title:
Shipping Address 2Shipping Address 2 -
shipCity:
string
Title:
Shipping CityShipping City -
shipCompany:
string
Title:
Shipping CompanyShipping Company -
shipCompany2:
string
Title:
Shipping Company 2Shipping Company 2 -
shipCountry:
string
Title:
Shipping CountryShipping Country -
shipEmail:
string
Title:
Shipping EmailShipping Email -
shipFax:
string
Title:
Shipping FaxShipping Fax -
shipFirstName:
string
Title:
Shipping First NameShipping First Name -
shipLastName:
string
Title:
Shipping Last NameShipping Last Name -
shipPhone:
string
Title:
Shipping PhoneShipping Phone -
shipStateProvince:
string
Title:
Shipping StateShipping State -
shipZip:
string
Title:
Shipping ZipShipping Zip -
status:
object Status
Title:
StatusStatus of the user -
timeZone:
object TimeZone of user
Title:
TimeZone of userUser preferred timezone -
type:
object Type
Title:
TypeType of the user -
units:
object Units
Title:
UnitsUser preferred units
Nested Schema : Access Permissions
Type:
objectTitle:
Access PermissionsAccess Permissions of a user
Show Source
Nested Schema : Company details
Type:
objectTitle:
Company detailsUser Company details. Applicable only for Users Across Companies
Show Source
-
loginName:
string
Title:
Company Login NameCompany Login Name -
name:
string
Title:
Company NameCompany Name
Nested Schema : Currency
Type:
objectTitle:
CurrencyCurrency preference of user. Value holds currency code
Show Source
-
displayValue:
string
Title:
Display ValueDisplay Value -
value:
string
Title:
ValueValue
Nested Schema : Date Format
Type:
objectTitle:
Date FormatUser preferred date time format
Show Source
-
displayValue:
string
Title:
Display ValueDisplay Value -
value:
number
Title:
ValueValue
Nested Schema : Enabled For SSO
Type:
objectTitle:
Enabled For SSOEnabled For SSO
Show Source
-
displayValue:
string
Title:
Display ValueDisplay Value -
value:
string
Title:
ValueValue
Nested Schema : Language
Type:
objectTitle:
LanguageLanguage preference of user. Value holds language code
Show Source
-
displayValue:
string
Title:
Display ValueDisplay Value -
value:
string
Title:
ValueValue
Nested Schema : Links to the related objects
Type:
arrayTitle:
Links to the related objectsLinks to the related objects
Show Source
-
Array of:
object reference links
Title:
reference linksReference links for the Parent, Self, Children and Related as applicable
Nested Schema : Number Format
Type:
objectTitle:
Number FormatPreferred number format of user
Show Source
-
displayValue:
string
Title:
Display ValueDisplay Value -
value:
number
Title:
ValueValue
Nested Schema : Status
Type:
objectTitle:
StatusStatus of the user
Show Source
-
displayValue:
string
Title:
Display ValueDisplay Value -
value:
number
Title:
ValueValue
Nested Schema : TimeZone of user
Type:
objectTitle:
TimeZone of userUser preferred timezone
Show Source
-
displayValue:
string
Title:
Display ValueDisplay Value -
value:
number
Title:
ValueValue
Nested Schema : Type
Type:
objectTitle:
TypeType of the user
Show Source
-
displayValue:
string
Title:
Display ValueDisplay Value -
value:
string
Title:
ValueValue
Nested Schema : Units
Type:
objectTitle:
UnitsUser preferred units
Show Source
-
displayValue:
string
Title:
Display ValueDisplay Value -
value:
number
Title:
ValueValue
Nested Schema : items
Type:
Show Source
array-
Array of:
object Access Permission
Title:
Access PermissionUser access bits information
Nested Schema : Access Permission
Type:
objectTitle:
Access PermissionUser access bits information
Show Source
-
hasAccess:
boolean
Title:
Has AccessFlag to determine if user has access to the restricted entity -
name:
string
Title:
Restricted Entity NameName of the entity to which access restrictions apply -
type:
string
Title:
TypeType of the restricted entity. Possible values productFamily, supportedProductFamily and dataTableFolder -
variableName:
string
Title:
Restricted Entity Variable NameVariable name of the entity to which access restrictions apply
Nested Schema : items
Type:
Show Source
array-
Array of:
object Group
Title:
GroupUser group information
Nested Schema : Group
Type:
objectTitle:
GroupUser group information
Show Source
-
label:
string
Title:
Group NameGroup name -
type:
string
Title:
Group TypeType of the group -
variableName:
string
Title:
Group Variable NameVariable name of the group
Nested Schema : reference links
Type:
objectTitle:
reference linksReference links for the Parent, Self, Children and Related as applicable
Show Source
-
href:
string
Title:
URL to the related objectURL to the related object -
rel:
string
Title:
Link Relationship to the current objectLink Relationship to the current object
Examples
The following example returns a list of users across companies as JSON or as a Zip file depending on Accept type passed in the request header by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.
curl -X GET -H "Authorization: Bearer <token>" -H "Content-type: application/json" -H "Accept: application/json" https://sitename.oracle.com/rest/v19/users
Response Body Sample
{
"items": [{
"login": "guest",
"isNotifyFax": false,
"firstName": "Lisa",
"lastName": "Jones",
"email": "ljones@yourcompany.com",
"phone": "+1 (366) 942-5555 (Land)",
"isNotifyEmail": false,
"partyId": 100010025532024,
"partyNumber": "100010025532024",
"dateModified": "2024-03-08T23:11:11.000Z",
"dateAdded": "2008-05-05T17:27:57.000Z",
"links": [{
"rel": "self",
"href": "http://sitename.oracle.com/rest/v19/users/100010025532024"
}, {
"rel": "child",
"href": "http://sitename.oracle.com/rest/v19/users/100010025532024/groups"
}
],
"type": {
"value": "RESTRICTED_ACCESS",
"displayValue": "RestrictedAccess"
},
"language": {
"value": "en_US",
"displayValue": "English"
},
"currency": {
"value": "USD",
"displayValue": "US Dollar"
},
"numberFormat": {
"value": 0,
"displayValue": "####.##"
},
"timeZone": {
"value": "America/Los_Angeles",
"displayValue": "(GMT-8:00 GMT-7:00) Los Angeles"
},
"units": {
"value": 0,
"displayValue": "System Default"
},
"dateFormat": {
"value": 0,
"displayValue": "MM/dd/yyyy h:mm a"
},
"status": {
"value": 1,
"displayValue": "Active"
},
"company": {
"name": "po1",
"loginName": "po1"
}
}
],
"offset": 0,
"limit": 1000,
"count": 1000,
"hasMore": true,
"links": [{
"rel": "canonical",
"href": "http://sitename.oracle.com/rest/v19/users"
}, {
"rel": "self",
"href": "http://sitename.oracle.com/rest/v19/users?offset=0&limit=1000"
}, {
"rel": "next",
"href": "http://sitename.oracle.com/rest/v19/users?offset=1000&limit=1000"
}
]
}