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
| Action | What it does |
|---|---|
| Add attachment | Attach a file, such as a photo, to a request, task, work order or asset. |
| Complete task | Mark a task Completed, optionally with when the work finished and a note. |
| Create asset | Add an asset, such as a new sign, from field values. |
| Create request | Make a request in Cartegraph from field values. |
| Create task | Make a task, such as patching a pothole, optionally on an asset. |
| Create work order | Make a work order in Cartegraph from field values. |
| Delete record | Delete a request, task, work order or asset. |
| Get asset | Get an asset with all its fields. |
| Get current user | Get the Cartegraph user the connection signs in as, and their security role. |
| Get request | Get a request with all its fields. |
| Get task | Get a task with all its fields. |
| Get work order | Get a work order with all its fields. |
| List asset tasks | List the tasks on an asset, newest first. |
| List asset types | List the kinds of asset the site keeps, such as Signs and Storm Inlets. |
| List attachments | List the files attached to a request, task, work order or asset. |
| List field values | List the values a field can take, such as every task status or activity. |
| List fields | List the fields of requests, tasks, work orders or a kind of asset, with their names. |
| Search assets | Find assets of a kind by ID or a Cartegraph filter, newest first. |
| Search requests | Find requests by status, ID or a Cartegraph filter, newest first. |
| Search tasks | Find tasks by status, ID or a Cartegraph filter, newest first. |
| Search work orders | Find work orders by status, ID or a Cartegraph filter, newest first. |
| Update asset | Change an asset's field values. |
| Update request | Change a request's field values. |
| Update task | Change a task's field values. |
| Update work order | Change 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 type
record_typetextRequired - Requests, tasks, work orders, or a kind of asset.
- Oid
oidtextRequired - The record's Oid, Cartegraph's number for it, from a trigger or a search.
- File
filetext - The file to attach: upload one or pick one from an earlier step.
- Text
contenttext - Text to attach as a text file, when no file is given.
- File name
file_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
- Oid
oidtextRequired - The task's Oid, Cartegraph's number for it, from a trigger or a search.
- Finished
finisheddate and time - When the work finished.
- Notes
notestext - 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 asset
asset_typetextRequired - The kind of asset, such as Signs.
- Fields
fieldsobjectRequired - 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
- Fields
fieldsobjectRequired - 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
- Activity
activitytext - The work to do, such as Patch.
- Fields
fieldsobject - The task's field values, by field. Fields left out are not changed.
- Kind of asset
asset_typetext - To make the task on an asset: its kind, such as Signs.
- Asset Oid
asset_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
- Fields
fieldsobjectRequired - 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 type
record_typetextRequired - Requests, tasks, work orders, or a kind of asset.
- Oid
oidtextRequired - 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 asset
asset_typetextRequired - The kind of asset, such as Signs.
- Oid
oidtextRequired - 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
- Oid
oidtextRequired - 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
- Oid
oidtextRequired - 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
- Oid
oidtextRequired - 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 asset
asset_typetextRequired - The kind of asset, such as Signs.
- Oid
oidtextRequired - The asset's Oid, Cartegraph's number for it, from a trigger or a search.
- Most results
limitnumber - 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 type
record_typetextRequired - Requests, tasks, work orders, or a kind of asset.
- Oid
oidtextRequired - 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 type
record_typetextRequired - Requests, tasks, work orders, or a kind of asset.
- Field
fieldtextRequired - 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 type
record_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 asset
asset_typetextRequired - The kind of asset, such as Signs.
- ID
record_idtext - Only the record with this ID, as people see it, such as 2219.
- Filter
filter_expressiontext - Cartegraph's own filter, for anything else, such as ([Priority] is equal to "High").
- Most results
limitnumber - How many to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.
- Skip
offsetnumber - 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
- Status
statustext - Only records with this status.
- ID
record_idtext - Only the record with this ID, as people see it, such as 2219.
- Filter
filter_expressiontext - Cartegraph's own filter, for anything else, such as ([Priority] is equal to "High").
- Most results
limitnumber - How many to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.
- Skip
offsetnumber - 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
- Status
statustext - Only records with this status.
- ID
record_idtext - Only the record with this ID, as people see it, such as 2219.
- Filter
filter_expressiontext - Cartegraph's own filter, for anything else, such as ([Priority] is equal to "High").
- Most results
limitnumber - How many to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.
- Skip
offsetnumber - 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
- Status
statustext - Only records with this status.
- ID
record_idtext - Only the record with this ID, as people see it, such as 2219.
- Filter
filter_expressiontext - Cartegraph's own filter, for anything else, such as ([Priority] is equal to "High").
- Most results
limitnumber - How many to return at most, 1 to 1000. Defaults to 100.From 1 to 1000.
- Skip
offsetnumber - 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 asset
asset_typetextRequired - The kind of asset, such as Signs.
- Oid
oidtextRequired - The asset's Oid, Cartegraph's number for it, from a trigger or a search.
- Fields
fieldsobjectRequired - 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
- Oid
oidtextRequired - The request's Oid, Cartegraph's number for it, from a trigger or a search.
- Fields
fieldsobjectRequired - 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
- Oid
oidtextRequired - The task's Oid, Cartegraph's number for it, from a trigger or a search.
- Fields
fieldsobjectRequired - 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
- Oid
oidtextRequired - The work order's Oid, Cartegraph's number for it, from a trigger or a search.
- Fields
fieldsobjectRequired - 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"
}
}