Skip to content

List canon category gl rows

Canon module

GET/canon/category-glcanonCategoryGl.list

The GL account each category posts to. Returns a cursor page of canon category gl rows the caller may see. Coded list: the default order is numeric code order by `cat_urid`. Supports sparse fieldsets and the filter grammar.

  • Requires the capability canon.taxonomy.read.
  • OAuth scopes: canon.
  • Cursor-paginated: limit, cursor, fields, sort and filter apply.
  • Error statuses: 400, 401, 429. Errors are RFC 9457 problem details.

Path and query parameters

canonCategoryGl.list: Path and query parameters
FieldTypeRequiredDescription
limitLimitNoPage size. Default 50, maximum 200.Constraints: range 1 to 200
cursorCursorNoOpaque cursor from `next_cursor` of the previous page.Constraints: length 1 to any
fieldsFieldsNoSparse fieldset: a comma-separated list of top-level fields to return. `id` is always returned.Constraints: pattern ^[a-z_][a-z0-9_]*(,[a-z_][a-z0-9_]*)*$
sortSortNoSort keys, comma-separated; a leading `-` sorts descending. Without `sort`, the documented default order applies (coded lists sort in numeric code order).Constraints: pattern ^-?[a-z_][a-z0-9_]*(,-?[a-z_][a-z0-9_]*)*$
filterFilterNoFilter grammar `filter[field][op]=value`. Operators: eq, ne, lt, lte, gt, gte, in (comma-separated values), is_null (true or false) and contains. Conditions combine with AND.

Response 200: a page of CanonCategoryGl

canonCategoryGl.list: CanonCategoryGl
FieldTypeRequiredDescription
cat_uridUridYesCategory URID `DDDD.DD.DD` from `xpms.dim_category` (Section 3.3). There is no fourth segment.Constraints: pattern ^[0-9]000\.[0-9]{2}\.[0-9]{2}$
default_cost_centerstringYesDefault cost center (dimension 1) of the category.Constraints: length 1 to 300
account_codeGlAccountCode | nullYes
{
  "data": [
    {
      "cat_urid": "0000.01.01",
      "default_cost_center": "Production",
      "account_code": "5400"
    },
    {
      "cat_urid": "0000.02.01",
      "default_cost_center": "Production",
      "account_code": "5400"
    }
  ],
  "next_cursor": null
}

Code samples

curl -X GET "$XOS_BASE_URL/canon/category-gl" \
  -H "Authorization: Bearer $XOS_API_KEY"
for await (const row of xos.canonCategoryGl.listAll()) {
  console.log(row);
}
for row in xos.canon_category_gl.list_all():
    print(row)
xos canon-category-gl list --all