Get
/glrestapi/rest/v1/rtigenericgldepts
Query Standards
Finder
Following row finders are available for data filtering and optimizing request performance.
- Select DeptCompany
- By UUID
Select DeptCompany
Recommended finder parameters. Refer to Query Parameters for example.
| Parameter | Description | Sample |
|---|---|---|
| deptCompanyCod | Company Code that the Department belongs to | 001 |
By UUID
This is an optional finder for querying a specific Department by row ID.
| Parameter | Description | Sample |
|---|---|---|
| /VUUID | The VUuid attribute is the Unique row ID | /glrestapi/rest/v1/rtigenericgldepts/:AABRgyAAIAALJRGAAJ |
Security
HTTP
Type basic
Basic authentication
Header parameters
Content-Type
string
Exampleapplication/json
Query parameters
finder
string
ExampleselectDeptCompany;deptCompanyCode=RVC
limit
integer
Example500
offset
integer
Example0
totalResults
boolean
Exampletrue
orderBy
string
ExampleDeptName:desc
Responses
200
OK
Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
example-0
Successful Response
{
"items": [
{
"DeptActiveFlag": "Y",
"DeptAdd1": null,
"DeptAdd2": null,
"DeptAdd3": null,
"DeptAddrCode": null,
"DeptAddrCompCode": null,
"DeptApTax1Code": null,
"DeptApTax2Code": null,
"DeptApTax3Code": null,
"DeptAreaCode": null,
"DeptBalanceFlag": "N",
"DeptBillingRateCode": null,
"DeptBuCode": "00",
"DeptBuName": "Non Business",
"DeptCkDigitCode": null,
"DeptCloseYr": 2009,
"DeptCode": "00",
"DeptCompCode": "RVC",
"DeptConschartCode": "RVCHART",
"DeptCountry": null,
"DeptCountryCode": null,
"DeptCtrlCode": null,
"DeptCtrlName": null,
"DeptFaxAreaCode": null,
"DeptFaxCountryCode": null,
"DeptFaxNum": null,
"DeptFedTax1Code": null,
"DeptFedTax2Code": null,
"DeptHier": "RVC 00 ",
"DeptIbRevAccCode": "1000.175",
"DeptIncomeCloseAccCode": "3000.100",
"DeptIncomeCloseDeptCode": "00",
"DeptInterClearAccCode": "1000.100",
"DeptJbAltCompAddCode": null,
"DeptJbAltRemitAddCode": null,
"DeptName": "Company Level",
"DeptPer": 3,
"DeptPhoneNum": null,
"DeptPostalCode": null,
"DeptRecalSalChrgrateFlag": "Y",
"DeptRegionCode": null,
"DeptRegionName": null,
"DeptRowid": "AAAsOtAAGAACCsTAAP",
"DeptTax1Code": null,
"DeptTax1IncinvFlag": null,
"DeptTax2Code": null,
"DeptTax2IncinvFlag": null,
"DeptTax3Code": null,
"DeptTax3IncinvFlag": null,
"DeptTax4Code": null,
"DeptTax4IncinvFlag": null,
"DeptTax5Code": null,
"DeptTax5IncinvFlag": null,
"DeptTaxCode": null,
"DeptWcbCode": null,
"DeptYr": 2024,
"DeptIuCreateDate": "2010-12-06T16:08:56Z",
"DeptIuUpdateDate": "2024-02-15T19:24:17Z",
"links": [
{
"rel": "self",
"href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsTAAP",
"name": "rtigenericgldepts",
"kind": "item"
},
{
"rel": "canonical",
"href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsTAAP",
"name": "rtigenericgldepts",
"kind": "item"
}
]
}
],
"totalResults": 1,
"count": 1,
"hasMore": false,
"limit": 1,
"offset": 0,
"links": [
{
"rel": "self",
"href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts",
"name": "rtigenericgldepts",
"kind": "collection"
}
]
}example-1
Successful Response
{
"items": [
{
"DeptActiveFlag": "Y",
"DeptAdd1": null,
"DeptAdd2": null,
"DeptAdd3": null,
"DeptAddrCode": null,
"DeptAddrCompCode": null,
"DeptApTax1Code": null,
"DeptApTax2Code": null,
"DeptApTax3Code": null,
"DeptAreaCode": "434",
"DeptBalanceFlag": "N",
"DeptBillingRateCode": null,
"DeptBuCode": "55",
"DeptBuName": "Public Sector",
"DeptCkDigitCode": null,
"DeptCloseYr": 2019,
"DeptCode": "40",
"DeptCompCode": "ZZ",
"DeptConschartCode": "ZZCHART",
"DeptCountry": null,
"DeptCountryCode": null,
"DeptCtrlCode": "00",
"DeptCtrlName": "Company Level33333",
"DeptFaxAreaCode": null,
"DeptFaxCountryCode": null,
"DeptFaxNum": null,
"DeptFedTax1Code": null,
"DeptFedTax2Code": null,
"DeptHier": "ZZ 40 ",
"DeptIbRevAccCode": null,
"DeptIncomeCloseAccCode": "3000.100",
"DeptIncomeCloseDeptCode": "00",
"DeptInterClearAccCode": null,
"DeptJbAltCompAddCode": null,
"DeptJbAltRemitAddCode": null,
"DeptName": "Equipment Maintenace",
"DeptPer": 2,
"DeptPhoneNum": "830-3788",
"DeptPostalCode": null,
"DeptRecalSalChrgrateFlag": "Y",
"DeptRegionCode": "CA",
"DeptRegionName": "California",
"DeptRowid": "AAAsOtAAGAACCsVAAA",
"DeptTax1Code": null,
"DeptTax1IncinvFlag": null,
"DeptTax2Code": null,
"DeptTax2IncinvFlag": null,
"DeptTax3Code": null,
"DeptTax3IncinvFlag": null,
"DeptTax4Code": null,
"DeptTax4IncinvFlag": null,
"DeptTax5Code": null,
"DeptTax5IncinvFlag": null,
"DeptTaxCode": null,
"DeptWcbCode": null,
"DeptYr": 2024,
"DeptIuCreateDate": null,
"DeptIuUpdateDate": "2024-02-07T13:59:11Z",
"links": [
{
"rel": "self",
"href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsVAAA",
"name": "rtigenericgldepts",
"kind": "item"
},
{
"rel": "canonical",
"href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsVAAA",
"name": "rtigenericgldepts",
"kind": "item"
}
]
},
{
"DeptActiveFlag": "Y",
"DeptAdd1": "test",
"DeptAdd2": null,
"DeptAdd3": null,
"DeptAddrCode": "ADD1",
"DeptAddrCompCode": null,
"DeptApTax1Code": null,
"DeptApTax2Code": null,
"DeptApTax3Code": null,
"DeptAreaCode": null,
"DeptBalanceFlag": "Y",
"DeptBillingRateCode": null,
"DeptBuCode": "55",
"DeptBuName": "Public Sector",
"DeptCkDigitCode": null,
"DeptCloseYr": 2019,
"DeptCode": "123456",
"DeptCompCode": "ZZ",
"DeptConschartCode": "ZZCHART",
"DeptCountry": "usa",
"DeptCountryCode": null,
"DeptCtrlCode": "00",
"DeptCtrlName": "Company Level33333",
"DeptFaxAreaCode": null,
"DeptFaxCountryCode": null,
"DeptFaxNum": null,
"DeptFedTax1Code": null,
"DeptFedTax2Code": null,
"DeptHier": "ZZ 123456",
"DeptIbRevAccCode": null,
"DeptIncomeCloseAccCode": "3000.100",
"DeptIncomeCloseDeptCode": "00",
"DeptInterClearAccCode": "6003.104",
"DeptJbAltCompAddCode": null,
"DeptJbAltRemitAddCode": null,
"DeptName": "6 digit",
"DeptPer": 12,
"DeptPhoneNum": null,
"DeptPostalCode": "233121",
"DeptRecalSalChrgrateFlag": "N",
"DeptRegionCode": "FL",
"DeptRegionName": "Florida",
"DeptRowid": "AAAsOtAAGAACCsTAAc",
"DeptTax1Code": null,
"DeptTax1IncinvFlag": null,
"DeptTax2Code": null,
"DeptTax2IncinvFlag": null,
"DeptTax3Code": null,
"DeptTax3IncinvFlag": null,
"DeptTax4Code": null,
"DeptTax4IncinvFlag": null,
"DeptTax5Code": null,
"DeptTax5IncinvFlag": null,
"DeptTaxCode": null,
"DeptWcbCode": null,
"DeptYr": 2020,
"DeptIuCreateDate": "2011-07-28T15:42:30Z",
"DeptIuUpdateDate": "2025-05-16T16:23:26Z",
"links": [
{
"rel": "self",
"href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsTAAc",
"name": "rtigenericgldepts",
"kind": "item"
},
{
"rel": "canonical",
"href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsTAAc",
"name": "rtigenericgldepts",
"kind": "item"
}
]
}
],
"totalResults": 38,
"count": 2,
"hasMore": true,
"limit": 2,
"offset": 0,
"links": [
{
"rel": "self",
"href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts",
"name": "rtigenericgldepts",
"kind": "collection"
}
]
}object