Cartegraph

App · 25 actions

Enter and update requests, tasks and work orders, find and update assets such as signs and storm inlets, attach photos, and start workflows when requests and tasks come in or tasks are completed.

Actions

ActionWhat it does
Add attachmentAttach a file, such as a photo, to a request, task, work order or asset.
Complete taskMark a task Completed, optionally with when the work finished and a note.
Create assetAdd an asset, such as a new sign, from field values.
Create requestMake a request in Cartegraph from field values.
Create taskMake a task, such as patching a pothole, optionally on an asset.
Create work orderMake a work order in Cartegraph from field values.
Delete recordDelete a request, task, work order or asset.
Get assetGet an asset with all its fields.
Get current userGet the Cartegraph user the connection signs in as, and their security role.
Get requestGet a request with all its fields.
Get taskGet a task with all its fields.
Get work orderGet a work order with all its fields.
List asset tasksList the tasks on an asset, newest first.
List asset typesList the kinds of asset the site keeps, such as Signs and Storm Inlets.
List attachmentsList the files attached to a request, task, work order or asset.
List field valuesList the values a field can take, such as every task status or activity.
List fieldsList the fields of requests, tasks, work orders or a kind of asset, with their names.
Search assetsFind assets of a kind by ID or a Cartegraph filter, newest first.
Search requestsFind requests by status, ID or a Cartegraph filter, newest first.
Search tasksFind tasks by status, ID or a Cartegraph filter, newest first.
Search work ordersFind work orders by status, ID or a Cartegraph filter, newest first.
Update assetChange an asset's field values.
Update requestChange a request's field values.
Update taskChange a task's field values.
Update work orderChange a work order's field values.

Add attachment

Attach a file, such as a photo, to a request, task, work order or asset. Give a file, or text to attach as a text file.

Inputs

Record typerecord_typetextRequired
Requests, tasks, work orders, or a kind of asset.
OidoidtextRequired
The record's Oid, Cartegraph's number for it, from a trigger or a search.
Filefiletext
The file to attach: upload one or pick one from an earlier step.
Textcontenttext
Text to attach as a text file, when no file is given.
File namefile_nametext
The file's name with its extension, such as photo.jpg.

Outputs

attachment_oidnumber
The new attachment's Oid
file_nametext
The name Cartegraph saved the file as
oidnumber
The record's Oid, Cartegraph's number for it
record_typetext
The record's recordset
sizenumber
The file's size in bytes
Example output
{
  "attachment_oid": 1495227177,
  "file_name": "pothole.jpg",
  "oid": 1495227176,
  "record_type": "cgRequestsClass",
  "size": 48213
}

Complete task

Mark a task Completed, optionally with when the work finished and a note.

Inputs

OidoidtextRequired
The task's Oid, Cartegraph's number for it, from a trigger or a search.
Finishedfinisheddate and time
When the work finished.
Notesnotestext
Notes to save on the task.

Outputs

taskobject
A Cartegraph task, with every field of the recordset by its field name
Example output
{
  "task": {
    "ActivityField": "Patch",
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 242283165,
    "StatusField": "Completed",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

Create asset

Add an asset, such as a new sign, from field values.

Inputs

Kind of assetasset_typetextRequired
The kind of asset, such as Signs.
FieldsfieldsobjectRequired
The asset's field values, by field. Fields left out are not changed.

Outputs

assetobject
A Cartegraph asset, with every field of its recordset by its field name
asset_typetext
The asset's recordset
oidnumber
The record's Oid, Cartegraph's number for it
Example output
{
  "asset": {
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "Sign-50",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 435560664,
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  },
  "asset_type": "cgSignsClass",
  "oid": 435560664
}

Create request

Make a request in Cartegraph from field values.

Inputs

FieldsfieldsobjectRequired
The request's field values, by field. Fields left out are not changed.

Outputs

oidnumber
The record's Oid, Cartegraph's number for it
requestobject
A Cartegraph request, with every field of the recordset by its field name
Example output
{
  "oid": 1495227176,
  "request": {
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 1495227176,
    "StatusField": "Open",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

Create task

Make a task, such as patching a pothole, optionally on an asset.

Inputs

Activityactivitytext
The work to do, such as Patch.
Fieldsfieldsobject
The task's field values, by field. Fields left out are not changed.
Kind of assetasset_typetext
To make the task on an asset: its kind, such as Signs.
Asset Oidasset_oidtext
To make the task on an asset: the asset's Oid.

Outputs

oidnumber
The record's Oid, Cartegraph's number for it
taskobject
A Cartegraph task, with every field of the recordset by its field name
Example output
{
  "oid": 242283165,
  "task": {
    "ActivityField": "Patch",
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 242283165,
    "StatusField": "Planned",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

Create work order

Make a work order in Cartegraph from field values.

Inputs

FieldsfieldsobjectRequired
The work order's field values, by field. Fields left out are not changed.

Outputs

oidnumber
The record's Oid, Cartegraph's number for it
work_orderobject
A Cartegraph work order, with every field of the recordset by its field name
Example output
{
  "oid": 114964549,
  "work_order": {
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 114964549,
    "StatusField": "Open",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

Delete record

Delete a request, task, work order or asset. This can't be undone.

Inputs

Record typerecord_typetextRequired
Requests, tasks, work orders, or a kind of asset.
OidoidtextRequired
The record's Oid, Cartegraph's number for it, from a trigger or a search.

Outputs

deletedtrue/false
Whether it was deleted
oidnumber
The record's Oid, Cartegraph's number for it
record_typetext
The record's recordset
Example output
{
  "deleted": true,
  "oid": 242283165,
  "record_type": "cgTasksClass"
}

Get asset

Get an asset with all its fields.

Inputs

Kind of assetasset_typetextRequired
The kind of asset, such as Signs.
OidoidtextRequired
The asset's Oid, Cartegraph's number for it, from a trigger or a search.

Outputs

assetobject
A Cartegraph asset, with every field of its recordset by its field name
asset_typetext
The asset's recordset
Example output
{
  "asset": {
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "Sign-50",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 435560664,
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  },
  "asset_type": "cgSignsClass"
}

Get current user

Get the Cartegraph user the connection signs in as, and their security role.

Inputs

None.

Outputs

emailtext
Email address
first_nametext
First name
last_nametext
Last name
roletext
Security role
user_nametext
The user name
Example output
{
  "email": "druiz@example.gov",
  "first_name": "Dana",
  "last_name": "Ruiz",
  "role": "Field Crew",
  "user_name": "publicworks"
}

Get request

Get a request with all its fields.

Inputs

OidoidtextRequired
The request's Oid, Cartegraph's number for it, from a trigger or a search.

Outputs

requestobject
A Cartegraph request, with every field of the recordset by its field name
Example output
{
  "request": {
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 1495227176,
    "StatusField": "Open",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

Get task

Get a task with all its fields.

Inputs

OidoidtextRequired
The task's Oid, Cartegraph's number for it, from a trigger or a search.

Outputs

taskobject
A Cartegraph task, with every field of the recordset by its field name
Example output
{
  "task": {
    "ActivityField": "Patch",
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 242283165,
    "StatusField": "Planned",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

Get work order

Get a work order with all its fields.

Inputs

OidoidtextRequired
The work order's Oid, Cartegraph's number for it, from a trigger or a search.

Outputs

work_orderobject
A Cartegraph work order, with every field of the recordset by its field name
Example output
{
  "work_order": {
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 114964549,
    "StatusField": "Open",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

List asset tasks

List the tasks on an asset, newest first.

Inputs

Kind of assetasset_typetextRequired
The kind of asset, such as Signs.
OidoidtextRequired
The asset's Oid, Cartegraph's number for it, from a trigger or a search.
Most resultslimitnumber
How many to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.

Outputs

asset_typetext
The asset's recordset
countnumber
How many are listed
oidnumber
The record's Oid, Cartegraph's number for it
taskslist
The asset's tasks, newest first
Example output
{
  "asset_type": "cgSignsClass",
  "count": 1,
  "oid": 435560664,
  "tasks": [
    {
      "ActivityField": "Patch",
      "EnteredByField": "Public Works Clerk",
      "EntryDateField": "2026-10-30T09:12:44-05:00",
      "IDField": "2219",
      "InactiveField": false,
      "LastModifiedByField": "Public Works Clerk",
      "NotesField": "Reported by a resident",
      "Oid": 242283165,
      "StatusField": "Planned",
      "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
    }
  ]
}

List asset types

List the kinds of asset the site keeps, such as Signs and Storm Inlets.

Inputs

None.

Outputs

asset_typeslist
The kinds of asset
countnumber
How many are listed
Example output
{
  "asset_types": [
    {
      "class_name": "cgSignsClass",
      "name": "Signs"
    }
  ],
  "count": 1
}

List attachments

List the files attached to a request, task, work order or asset.

Inputs

Record typerecord_typetextRequired
Requests, tasks, work orders, or a kind of asset.
OidoidtextRequired
The record's Oid, Cartegraph's number for it, from a trigger or a search.

Outputs

attachmentslist
The attachments
countnumber
How many are listed
oidnumber
The record's Oid, Cartegraph's number for it
record_typetext
The record's recordset
Example output
{
  "attachments": [
    {
      "description": "",
      "entered": "2026-10-30T09:20:00-05:00",
      "entered_by": "Public Works Clerk",
      "file_name": "pothole.jpg",
      "oid": 1495227177
    }
  ],
  "count": 1,
  "oid": 1495227176,
  "record_type": "cgRequestsClass"
}

List field values

List the values a field can take, such as every task status or activity.

Inputs

Record typerecord_typetextRequired
Requests, tasks, work orders, or a kind of asset.
FieldfieldtextRequired
The field, such as Status. Only fields with a list of values are offered.

Outputs

countnumber
How many are listed
fieldtext
The field
record_typetext
The recordset
valueslist
The values, in order
Example output
{
  "count": 3,
  "field": "StatusField",
  "record_type": "cgTasksClass",
  "values": [
    "Planned",
    "In Progress",
    "Completed"
  ]
}

List fields

List the fields of requests, tasks, work orders or a kind of asset, with their names.

Inputs

Record typerecord_typetextRequired
Requests, tasks, work orders, or a kind of asset.

Outputs

countnumber
How many are listed
fieldslist
Its fields
nametext
Its name, such as Tasks
record_typetext
The recordset
Example output
{
  "count": 1,
  "fields": [
    {
      "label": "Activity",
      "lookup": "cgActivitiesClass",
      "name": "ActivityField",
      "read_only": false,
      "required": true,
      "unit": ""
    }
  ],
  "name": "Tasks",
  "record_type": "cgTasksClass"
}

Search assets

Find assets of a kind by ID or a Cartegraph filter, newest first.

Inputs

Kind of assetasset_typetextRequired
The kind of asset, such as Signs.
IDrecord_idtext
Only the record with this ID, as people see it, such as 2219.
Filterfilter_expressiontext
Cartegraph's own filter, for anything else, such as ([Priority] is equal to "High").
Most resultslimitnumber
How many to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.
Skipoffsetnumber
How many to skip, to page through more results.At least 0.

Outputs

asset_typetext
The assets' recordset
assetslist
The matching assets, newest first
countnumber
How many are listed
totalnumber
How many match in all
Example output
{
  "asset_type": "cgSignsClass",
  "assets": [
    {
      "EnteredByField": "Public Works Clerk",
      "EntryDateField": "2026-10-30T09:12:44-05:00",
      "IDField": "Sign-50",
      "InactiveField": false,
      "LastModifiedByField": "Public Works Clerk",
      "NotesField": "Reported by a resident",
      "Oid": 435560664,
      "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
    }
  ],
  "count": 1,
  "total": 1
}

Search requests

Find requests by status, ID or a Cartegraph filter, newest first.

Inputs

Statusstatustext
Only records with this status.
IDrecord_idtext
Only the record with this ID, as people see it, such as 2219.
Filterfilter_expressiontext
Cartegraph's own filter, for anything else, such as ([Priority] is equal to "High").
Most resultslimitnumber
How many to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.
Skipoffsetnumber
How many to skip, to page through more results.At least 0.

Outputs

countnumber
How many are listed
requestslist
The matching requests, newest first
totalnumber
How many match in all
Example output
{
  "count": 1,
  "requests": [
    {
      "EnteredByField": "Public Works Clerk",
      "EntryDateField": "2026-10-30T09:12:44-05:00",
      "IDField": "2219",
      "InactiveField": false,
      "LastModifiedByField": "Public Works Clerk",
      "NotesField": "Reported by a resident",
      "Oid": 1495227176,
      "StatusField": "Open",
      "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
    }
  ],
  "total": 1
}

Search tasks

Find tasks by status, ID or a Cartegraph filter, newest first.

Inputs

Statusstatustext
Only records with this status.
IDrecord_idtext
Only the record with this ID, as people see it, such as 2219.
Filterfilter_expressiontext
Cartegraph's own filter, for anything else, such as ([Priority] is equal to "High").
Most resultslimitnumber
How many to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.
Skipoffsetnumber
How many to skip, to page through more results.At least 0.

Outputs

countnumber
How many are listed
taskslist
The matching tasks, newest first
totalnumber
How many match in all
Example output
{
  "count": 1,
  "tasks": [
    {
      "ActivityField": "Patch",
      "EnteredByField": "Public Works Clerk",
      "EntryDateField": "2026-10-30T09:12:44-05:00",
      "IDField": "2219",
      "InactiveField": false,
      "LastModifiedByField": "Public Works Clerk",
      "NotesField": "Reported by a resident",
      "Oid": 242283165,
      "StatusField": "Planned",
      "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
    }
  ],
  "total": 1
}

Search work orders

Find work orders by status, ID or a Cartegraph filter, newest first.

Inputs

Statusstatustext
Only records with this status.
IDrecord_idtext
Only the record with this ID, as people see it, such as 2219.
Filterfilter_expressiontext
Cartegraph's own filter, for anything else, such as ([Priority] is equal to "High").
Most resultslimitnumber
How many to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.
Skipoffsetnumber
How many to skip, to page through more results.At least 0.

Outputs

countnumber
How many are listed
totalnumber
How many match in all
work_orderslist
The matching work orders, newest first
Example output
{
  "count": 1,
  "total": 1,
  "work_orders": [
    {
      "EnteredByField": "Public Works Clerk",
      "EntryDateField": "2026-10-30T09:12:44-05:00",
      "IDField": "2219",
      "InactiveField": false,
      "LastModifiedByField": "Public Works Clerk",
      "NotesField": "Reported by a resident",
      "Oid": 114964549,
      "StatusField": "Open",
      "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
    }
  ]
}

Update asset

Change an asset's field values. Fields left out are not changed.

Inputs

Kind of assetasset_typetextRequired
The kind of asset, such as Signs.
OidoidtextRequired
The asset's Oid, Cartegraph's number for it, from a trigger or a search.
FieldsfieldsobjectRequired
The asset's field values, by field. Fields left out are not changed.

Outputs

assetobject
A Cartegraph asset, with every field of its recordset by its field name
asset_typetext
The asset's recordset
Example output
{
  "asset": {
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "Sign-50",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 435560664,
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  },
  "asset_type": "cgSignsClass"
}

Update request

Change a request's field values. Fields left out are not changed.

Inputs

OidoidtextRequired
The request's Oid, Cartegraph's number for it, from a trigger or a search.
FieldsfieldsobjectRequired
The request's field values, by field. Fields left out are not changed.

Outputs

requestobject
A Cartegraph request, with every field of the recordset by its field name
Example output
{
  "request": {
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 1495227176,
    "StatusField": "Open",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

Update task

Change a task's field values. Fields left out are not changed.

Inputs

OidoidtextRequired
The task's Oid, Cartegraph's number for it, from a trigger or a search.
FieldsfieldsobjectRequired
The task's field values, by field. Fields left out are not changed.

Outputs

taskobject
A Cartegraph task, with every field of the recordset by its field name
Example output
{
  "task": {
    "ActivityField": "Patch",
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 242283165,
    "StatusField": "Planned",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

Update work order

Change a work order's field values. Fields left out are not changed.

Inputs

OidoidtextRequired
The work order's Oid, Cartegraph's number for it, from a trigger or a search.
FieldsfieldsobjectRequired
The work order's field values, by field. Fields left out are not changed.

Outputs

work_orderobject
A Cartegraph work order, with every field of the recordset by its field name
Example output
{
  "work_order": {
    "EnteredByField": "Public Works Clerk",
    "EntryDateField": "2026-10-30T09:12:44-05:00",
    "IDField": "2219",
    "InactiveField": false,
    "LastModifiedByField": "Public Works Clerk",
    "NotesField": "Reported by a resident",
    "Oid": 114964549,
    "StatusField": "Open",
    "cgLastModifiedField": "2026-10-30T09:12:44-05:00"
  }
}

On this page