Getting Record Counts: $count

This keyword will always occur after a trailing slash and can include query parameters. It will return the total record count (with respect to the supplied query parameters).

GET http://restapi.lucity.net/gbaMS/Work/WorkOrders.svc/$count

GET http://restapi.lucity.net/gbaMS/Work/WorkOrders.svc/$count?Filter=WKORDER+WHERE+WO_STAT_CD%3C950

GET http://restapi.lucity.net/gbaMS/Work/WorkOrders.svc/MainTaskCode/$count

See Also

Special Functions

Getting pick lists: {PropertyName}/ and {PropertyName}/$count

Caching support on lookups

Special lookups

Getting a new empty object: $new

Getting metadata: $fields

Discoverability

Document attachments, uploads, downloads

Working with Existing Filters: $filters and $myfilters

Errors

Commands

Tools

Clearing Cached Data: $cache

Warnings and Conflicts

Getting live updates based on property changes made by an end user

Secure Fields

ObjectCanBeEditied,ObjectCanBeDeleted

SQL Injection Considerations