API Catalog

Retrieve GL Document rows By Code

27 Feb 2025
1 Minute to read

Print
Dark
Light

Retrieve GL Document rows By Code

Updated on 27 Feb 2025
1 Minute to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback!

Get

/glrestapi/rest/v1/gldocrows

Query Standards

Key	Recommended	Description
finder	Yes	Filters data based on attributes
limit	Yes	No. of items to return
offset	Yes	item index
totalResults	Yes	Returns total number of items
orderBy	Yes	Returns list of items order by given attribute

Finder

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

Select Doc Row
By UUID

Select Document Row

This is the recommended finder for querying Document Rows by Document Code

Parameter	Description	Sample
documentCode	Document Code	BALANCE

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/gldocrows/EA02BA00F5B18811E053B08610ACE770

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectDocRows;documentCode=BALANCE

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

ExampleTrue

orderBy

string

ExampleDapSeqNum:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [
    {
      "DapSeqNum": 100,
      "DapLineName": "Range",
      "DapLineCode": "R",
      "DapPrintCode": "Y",
      "DapRevCode": "N",
      "DapStoreCode": null,
      "DapTotal1Code": null,
      "DapTotal2Code": null,
      "DapTotalNum": null,
      "DapStartAccCode": null,
      "DapStartAccSeq": null,
      "DapEndAccCode": null,
      "DapEndAccSeq": null,
      "DapDocName": "Balance Sheet - Consolidated",
      "DapDocCode": "BALANCE",
      "DapDesc": "ASSETS",
      "DapCon2Code": null,
      "DapCon2Name": null,
      "DapVUuid": "EA02BA020ADA8811E053B08610ACE770",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/glrestapi/rest/v1/gldocrows/EA02BA020ADA8811E053B08610ACE770",
          "name": "gldocrows",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/glrestapi/rest/v1/gldocrows/EA02BA020ADA8811E053B08610ACE770",
          "name": "gldocrows",
          "kind": "item"
        }
      ]
    },
    {
      "DapSeqNum": 920,
      "DapLineName": "Range",
      "DapLineCode": "R",
      "DapPrintCode": "Y",
      "DapRevCode": "N",
      "DapStoreCode": null,
      "DapTotal1Code": null,
      "DapTotal2Code": null,
      "DapTotalNum": null,
      "DapStartAccCode": "40001",
      "DapStartAccSeq": null,
      "DapEndAccCode": "99999",
      "DapEndAccSeq": null,
      "DapDocName": "Balance Sheet - Consolidated",
      "DapDocCode": "BALANCE",
      "DapDesc": "Profit / (Loss)",
      "DapCon2Code": null,
      "DapCon2Name": null,
      "DapVUuid": "EA02BA025A838811E053B08610ACE770",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/glrestapi/rest/v1/gldocrows/EA02BA025A838811E053B08610ACE770",
          "name": "gldocrows",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/glrestapi/rest/v1/gldocrows/EA02BA025A838811E053B08610ACE770",
          "name": "gldocrows",
          "kind": "item"
        }
      ]
    }
  ],
  "totalResults": 101,
  "count": 2,
  "hasMore": true,
  "limit": 2,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestupg/glrestapi/rest/v1/gldocrows",
      "name": "gldocrows",
      "kind": "collection"
    }
  ]
}

object

What's Next

Create a GL Journal

Retrieve GL Document rows By Code

Query Standards

Finder

Select Document Row

By UUID

What's Next

Contact Us