Skip to content

List project rows

Projects module

GET/projectsprojects.list

A production project. Jurisdiction is resolved at gate 1. Returns a cursor page of project rows the caller may see. The default order is `created_at` ascending. Supports sparse fieldsets and the filter grammar.

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

Path and query parameters

projects.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 Project

projects.list: Project
FieldTypeRequiredDescription
idstring (uuid)YesIdentifier of the project.
org_idstring (uuid)YesIdentifier of the owning organization, derived from the parent row and never accepted from the caller.
created_atstring (date-time)YesWhen the row was created.
created_bystring (uuid) | nullYesIdentifier of the person who created the row; null when a seed, platform or system process created it.
updated_atstring (date-time)YesWhen the row was last updated.
updated_bystring (uuid) | nullYesIdentifier of the person who last updated the row; null when a seed, platform or system process updated it.
project_keystringYesProject key, chosen by the caller and unique in the organization; it addresses the project in Atlas URLs.Constraints: pattern ^[A-Za-z0-9][A-Za-z0-9._-]{0,63}$
namestringYesProject name, Title Case.Constraints: length 1 to 300
descriptionstring | nullYesProject description.Constraints: length 1 to 20000
workspace_idstring (uuid) | nullYesIdentifier of the workspace.
jurisdiction_idJurisdictionIdYesJurisdiction identifier from `xpms.dim_jurisdiction`. An unpopulated jurisdiction returns no answer.Constraints: pattern ^[A-Z]{2}(-[A-Z0-9]+)*$
region_codeRegionCodeYesCost region code from `xpms.dim_region`.Constraints: pattern ^[A-Z]{2}(-[A-Z0-9]+)+$
tier_codeTierCode | nullYes
current_phase_codePhaseCodeYesPhase code from `xpms.dim_phase`, ordered by gate ordinal.Constraints: pattern ^[A-Z]{3}$
project_statestringYesProject lifecycle state. A Title Case value from the lifecycle's database enum.Constraints: pattern ^[A-Z0-9][A-Za-z0-9&'/.()-]*( [A-Za-z0-9&'/.()-]+)*$
currencystringYesBase currency of the project.Constraints: pattern ^[A-Z]{3}$
starts_onstring (date) | nullYesFirst show day.
ends_onstring (date) | nullYesLast show day.
time_zonestringYesIANA time zone of the project; local times are entered in it.Constraints: pattern ^[A-Za-z_]+(\/[A-Za-z0-9_+-]+)*$
venue_idstring (uuid) | nullYesIdentifier of the primary venue of the project.
client_counterparty_idstring (uuid) | nullYesIdentifier of the client counterparty the project is produced for.
production_statestringYesProduction lifecycle state, which runs beside the project state; changes only through its transition RPC. A Title Case value from the lifecycle's database enum.Constraints: pattern ^[A-Z0-9][A-Za-z0-9&'/.()-]*( [A-Za-z0-9&'/.()-]+)*$
archived_atstring (date-time) | nullYesWhen the project was archived; archived projects leave the default lists.
anchor_onstring (date) | nullYesAnchor date (usually the show day) that template day offsets count from.
budget_envelope_minorinteger (int64) | nullYesBudget envelope approved for the project. Integer minor units of the resource currency; null means unpriced, never zero.
{
  "data": [
    {
      "id": "0192f1e2-7c3a-7b4d-9e8f-1a2b3c4d5e6f",
      "org_id": "0192f1e2-7c3a-7b4d-9e8f-1a2b3c4d5e6f",
      "created_at": "2026-10-08T14:30:00Z",
      "created_by": "0192f1e2-7c3a-7b4d-9e8f-1a2b3c4d5e6f",
      "updated_at": "2026-10-08T14:30:00Z",
      "updated_by": "0192f1e2-7c3a-7b4d-9e8f-1a2b3c4d5e6f",
      "project_key": "NWL-24",
      "name": "Harborfront Summer Series",
      "description": "Six weekend shows on the harbor lawn.",
      "workspace_id": "0192f1e2-7c3a-7b4d-9e8f-1a2b3c4d5e6f",
      "jurisdiction_id": "US-FL",
      "region_code": "NA-SE-MIA",
      "tier_code": "04",
      "current_phase_code": "SCP",
      "project_state": "Active",
      "currency": "USD",
      "starts_on": "2026-10-08",
      "ends_on": "2026-10-08",
      "time_zone": "America/New_York",
      "venue_id": "0192f1e2-7c3a-7b4d-9e8f-1a2b3c4d5e6f",
      "client_counterparty_id": "0192f1e2-7c3a-7b4d-9e8f-1a2b3c4d5e6f",
      "production_state": "Proposed",
      "archived_at": "2026-10-08T14:30:00Z",
      "anchor_on": "2026-10-08",
      "budget_envelope_minor": 25000000
    }
  ],
  "next_cursor": null
}

Code samples

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