API Catalog

Retrieve GL Companies By Code

25 Sep 2024
4 Minutes to read

Print
Dark
Light

Retrieve GL Companies By Code

Updated on 25 Sep 2024
4 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

Get

/glrestapi/rest/v1/glcompany

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

Select Company
Select By Date
By UUID

Select By Date

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
auditDate	Create or Update Date Time Filter	2016-12-28

Select Company

This is the optional finder for querying Companies by Company Code.

Parameter	Description	Sample
compCode	Company Code	001

By UUID

This is an optional finder for querying a specific Company by row ID.

Parameter	Description	Sample
/VUUID	The VUuid attribute is the Unique row ID	/glrestapi/rest/v1/glcompany/D4AE1BA9EE703174E05316821FAC7390

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectByDate; auditDate=2014-01-12

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleCompCode:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [
    {
      "CompAccByCompFlag": null,
      "CompAccByDeptFlag": null,
      "CompAdd1": "1 Liberty Plaza",
      "CompAdd2": null,
      "CompAdd3": "New York",
      "CompArDepartmentName": null,
      "CompArchDate": "1999-12-31",
      "CompArctrlLogoFile": "/attachments/produpg/RESOURCES/VF389BTEQP11127/GLCOMPANY.CompArctrlLogoFile/9928086/CMiC Large Logo.png",
      "CompCableNum": null,
      "CompCalcEndDate": "2018-09-30",
      "CompCalcStartDate": "2018-08-31",
      "CompCkDigitCode": null,
      "CompCode": "001",
      "CompCompoundGstCode": null,
      "CompConsCode": "ALL",
      "CompConschartCode": "HIKUU",
      "CompConschartName": "CMiC Construction Cloud",
      "CompConschartTypeCode": null,
      "CompContactName": null,
      "CompCountry": "USA",
      "CompCtrlCode": null,
      "CompCtrlFileExists": "Y",
      "CompCurrCode": "USD",
      "CompCurrName": "US Dollar",
      "CompCurrPer": 9,
      "CompDefaultPyCountryCode": null,
      "CompDeptCode": "Y",
      "CompDistGlCompCode": null,
      "CompDistGlDeptCode": null,
      "CompDistGlFlag": null,
      "CompDistGlLogDaysNum": null,
      "CompEmailAdd": null,
      "CompEmpNum": null,
      "CompEstablishDate": null,
      "CompF5trContPerson": null,
      "CompF5trContTelNo": null,
      "CompF5trDeclrId": null,
      "CompF5trDeclrName": null,
      "CompF5trDesignation": null,
      "CompF5trGstRegNo": null,
      "CompF5trRefNo": null,
      "CompFaxAreaCode": "412",
      "CompFaxCountryCode": null,
      "CompFaxNum": "736-1851",
      "CompFedTax1Code": "1234567890",
      "CompFedTax2Code": "10384 9675",
      "CompFiscalYr": 2018,
      "CompIcAccCode": null,
      "CompIcDeptCode": null,
      "CompIncomeCloseAccCode": "35000",
      "CompIncomeCloseDeptCode": "00",
      "CompIntClrDeptCode": null,
      "CompIntintCode": null,
      "CompLegalName": "CMiC Construction Inc",
      "CompLogoFile": null,
      "CompLogoFileOnWeb": "/attachments/produpg/RESOURCES/VF389BTEQP11127/GLCOMPANY.CompLogoFileOnWeb/9928086/CMiC Large Logo.png",
      "CompMaintainBalcurrFlag": null,
      "CompMocrrCode": null,
      "CompName": "CMiC Construction Inc",
      "CompOfGlFlag": null,
      "CompOfGlIdFlexCode": null,
      "CompOfGlIdFlexNum": null,
      "CompOfGlSegments": null,
      "CompOfGlSetOfBooksId": null,
      "CompOfGlValues": null,
      "CompOwnershipPc": null,
      "CompPerNum": null,
      "CompPhoneAreaCode": "412",
      "CompPhoneCountryCode": null,
      "CompPhoneNum": "736-0123",
      "CompPostalCode": "15222",
      "CompRecognizeFxFlag": null,
      "CompRegionCode": "NY",
      "CompRegionName": "New York",
      "CompRemeasureAdjAccCode": null,
      "CompRepCurr1Code": null,
      "CompRepCurr1Name": null,
      "CompRepCurr2Code": null,
      "CompRepCurr2Name": null,
      "CompRepCurr3Code": null,
      "CompRepCurr3Name": null,
      "CompRowid": "AAAXlEAAIAALee1AAQ",
      "CompT619RegistrationCode": null,
      "CompTaxCode": null,
      "CompTaxDist": null,
      "CompTelexNum": null,
      "CompTerrCode": null,
      "CompTypeCode": null,
      "CompUseTacFlag": "N",
      "CompVatRegNum": null,
      "CompWebAdd": null,
      "CompVUuid": "D4AE1BA9EE703174E05316821FAC7390",
      "CompIuCreateDate": "2015-04-15T06:03:37Z",
      "CompIuCreateUser": "ADWAIT",
      "CompIuUpdateDate": "2023-08-14T10:46:46Z",
      "CompIuUpdateUser": "GCPAY",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/glrestapi/rest/v1/glcompany/D4AE1BA9EE703174E05316821FAC7390",
          "name": "glcompany",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/glrestapi/rest/v1/glcompany/D4AE1BA9EE703174E05316821FAC7390",
          "name": "glcompany",
          "kind": "item"
        }
      ]
    },
    {
      "CompAccByCompFlag": null,
      "CompAccByDeptFlag": null,
      "CompAdd1": null,
      "CompAdd2": null,
      "CompAdd3": "toronto",
      "CompArDepartmentName": null,
      "CompArchDate": "2022-12-31",
      "CompArctrlLogoFile": null,
      "CompCableNum": null,
      "CompCalcEndDate": null,
      "CompCalcStartDate": null,
      "CompCkDigitCode": null,
      "CompCode": "122222",
      "CompCompoundGstCode": null,
      "CompConsCode": "ALL",
      "CompConschartCode": "CMIC",
      "CompConschartName": "CMiC Chart of Accounts",
      "CompConschartTypeCode": null,
      "CompContactName": null,
      "CompCountry": null,
      "CompCtrlCode": null,
      "CompCtrlFileExists": "N",
      "CompCurrCode": "USD",
      "CompCurrName": "US Dollar",
      "CompCurrPer": 1,
      "CompDefaultPyCountryCode": null,
      "CompDeptCode": "Y",
      "CompDistGlCompCode": null,
      "CompDistGlDeptCode": null,
      "CompDistGlFlag": null,
      "CompDistGlLogDaysNum": null,
      "CompEmailAdd": null,
      "CompEmpNum": null,
      "CompEstablishDate": null,
      "CompF5trContPerson": null,
      "CompF5trContTelNo": null,
      "CompF5trDeclrId": null,
      "CompF5trDeclrName": null,
      "CompF5trDesignation": null,
      "CompF5trGstRegNo": null,
      "CompF5trRefNo": null,
      "CompFaxAreaCode": null,
      "CompFaxCountryCode": null,
      "CompFaxNum": null,
      "CompFedTax1Code": null,
      "CompFedTax2Code": null,
      "CompFiscalYr": 2023,
      "CompIcAccCode": null,
      "CompIcDeptCode": null,
      "CompIncomeCloseAccCode": "11000",
      "CompIncomeCloseDeptCode": "00",
      "CompIntClrDeptCode": null,
      "CompIntintCode": null,
      "CompLegalName": null,
      "CompLogoFile": null,
      "CompLogoFileOnWeb": null,
      "CompMaintainBalcurrFlag": null,
      "CompMocrrCode": null,
      "CompName": "test company",
      "CompOfGlFlag": null,
      "CompOfGlIdFlexCode": null,
      "CompOfGlIdFlexNum": null,
      "CompOfGlSegments": null,
      "CompOfGlSetOfBooksId": null,
      "CompOfGlValues": null,
      "CompOwnershipPc": null,
      "CompPerNum": null,
      "CompPhoneAreaCode": null,
      "CompPhoneCountryCode": null,
      "CompPhoneNum": null,
      "CompPostalCode": null,
      "CompRecognizeFxFlag": null,
      "CompRegionCode": null,
      "CompRegionName": null,
      "CompRemeasureAdjAccCode": null,
      "CompRepCurr1Code": null,
      "CompRepCurr1Name": null,
      "CompRepCurr2Code": null,
      "CompRepCurr2Name": null,
      "CompRepCurr3Code": null,
      "CompRepCurr3Name": null,
      "CompRowid": "AAAXlEAAIAALekiAAK",
      "CompT619RegistrationCode": null,
      "CompTaxCode": null,
      "CompTaxDist": null,
      "CompTelexNum": null,
      "CompTerrCode": null,
      "CompTypeCode": null,
      "CompUseTacFlag": "N",
      "CompVatRegNum": null,
      "CompWebAdd": null,
      "CompVUuid": "07882EE63DBC2487E06316821FAC18E2",
      "CompIuCreateDate": "2023-10-12T04:10:49Z",
      "CompIuCreateUser": "CMICUSER",
      "CompIuUpdateDate": null,
      "CompIuUpdateUser": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/glrestapi/rest/v1/glcompany/07882EE63DBC2487E06316821FAC18E2",
          "name": "glcompany",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/glrestapi/rest/v1/glcompany/07882EE63DBC2487E06316821FAC18E2",
          "name": "glcompany",
          "kind": "item"
        }
      ]
    },
    {
      "CompAccByCompFlag": null,
      "CompAccByDeptFlag": null,
      "CompAdd1": null,
      "CompAdd2": null,
      "CompAdd3": null,
      "CompArDepartmentName": null,
      "CompArchDate": "2023-07-31",
      "CompArctrlLogoFile": "/attachments/produpg/RESOURCES/VF389BTEQP11127/GLCOMPANY.CompArctrlLogoFile/9928086/CMiC Large Logo.png",
      "CompCableNum": null,
      "CompCalcEndDate": null,
      "CompCalcStartDate": null,
      "CompCkDigitCode": null,
      "CompCode": "SBC101",
      "CompCompoundGstCode": null,
      "CompConsCode": "ALL",
      "CompConschartCode": "HIKUU",
      "CompConschartName": "CMiC Construction Cloud",
      "CompConschartTypeCode": null,
      "CompContactName": null,
      "CompCountry": null,
      "CompCtrlCode": null,
      "CompCtrlFileExists": "Y",
      "CompCurrCode": "USD",
      "CompCurrName": "US Dollar",
      "CompCurrPer": 5,
      "CompDefaultPyCountryCode": null,
      "CompDeptCode": "Y",
      "CompDistGlCompCode": null,
      "CompDistGlDeptCode": null,
      "CompDistGlFlag": null,
      "CompDistGlLogDaysNum": null,
      "CompEmailAdd": null,
      "CompEmpNum": null,
      "CompEstablishDate": null,
      "CompF5trContPerson": null,
      "CompF5trContTelNo": null,
      "CompF5trDeclrId": null,
      "CompF5trDeclrName": null,
      "CompF5trDesignation": null,
      "CompF5trGstRegNo": null,
      "CompF5trRefNo": null,
      "CompFaxAreaCode": null,
      "CompFaxCountryCode": null,
      "CompFaxNum": null,
      "CompFedTax1Code": null,
      "CompFedTax2Code": null,
      "CompFiscalYr": 2023,
      "CompIcAccCode": null,
      "CompIcDeptCode": null,
      "CompIncomeCloseAccCode": "10003",
      "CompIncomeCloseDeptCode": "00",
      "CompIntClrDeptCode": null,
      "CompIntintCode": null,
      "CompLegalName": null,
      "CompLogoFile": null,
      "CompLogoFileOnWeb": null,
      "CompMaintainBalcurrFlag": null,
      "CompMocrrCode": null,
      "CompName": "Smartbarrel Company 101",
      "CompOfGlFlag": null,
      "CompOfGlIdFlexCode": null,
      "CompOfGlIdFlexNum": null,
      "CompOfGlSegments": null,
      "CompOfGlSetOfBooksId": null,
      "CompOfGlValues": null,
      "CompOwnershipPc": null,
      "CompPerNum": null,
      "CompPhoneAreaCode": null,
      "CompPhoneCountryCode": null,
      "CompPhoneNum": null,
      "CompPostalCode": null,
      "CompRecognizeFxFlag": null,
      "CompRegionCode": null,
      "CompRegionName": null,
      "CompRemeasureAdjAccCode": null,
      "CompRepCurr1Code": null,
      "CompRepCurr1Name": null,
      "CompRepCurr2Code": null,
      "CompRepCurr2Name": null,
      "CompRepCurr3Code": null,
      "CompRepCurr3Name": null,
      "CompRowid": "AAAXlEAAIAALel/AAC",
      "CompT619RegistrationCode": null,
      "CompTaxCode": null,
      "CompTaxDist": null,
      "CompTelexNum": null,
      "CompTerrCode": null,
      "CompTypeCode": null,
      "CompUseTacFlag": "N",
      "CompVatRegNum": null,
      "CompWebAdd": null,
      "CompVUuid": "FB7127370B965D30E05316821FACA536",
      "CompIuCreateDate": "2023-05-11T07:39:56Z",
      "CompIuCreateUser": "CMICUSER",
      "CompIuUpdateDate": "2023-05-12T02:54:48Z",
      "CompIuUpdateUser": "CMICUSER",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/glrestapi/rest/v1/glcompany/FB7127370B965D30E05316821FACA536",
          "name": "glcompany",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/glrestapi/rest/v1/glcompany/FB7127370B965D30E05316821FACA536",
          "name": "glcompany",
          "kind": "item"
        }
      ]
    }
  ],
  "totalResults": 3,
  "count": 3,
  "hasMore": false,
  "limit": 250,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/glrestapi/rest/v1/glcompany",
      "name": "glcompany",
      "kind": "collection"
    }
  ]
}

object

What's Next

Retrieve GL Departments By Code

Retrieve GL Companies By Code

Query Standards

Finder

Select By Date

Select Company

By UUID

What's Next

Contact Us