Not logged in - Login
< back

Custom Search - Items

SEARCH BASICS

  • All searches are done as POST requests to the API.
  • Search parameters are sent in the body of a request in a JSON format.
  • All search request bodies must contain a "StaticFields" array, an "OfficeIds" array, and also paging parameters properties "PageSize" and "PageNumber".
  • "OfficeIds" must be included in the request and allows a search to filter by Office.
  • As options, the request can also include "orderBy" which will be a field name and "orderByAsc" which can be either true or false.

SEARCH CRITERIA

The body of a search request must include a search criteria. These criteria Ids are used in the "searchCriteria" property of the request body. The criteria are different depending on the field. For easier reference, the search criteria can be broken down into the following groups:

Group 1 - TEXT FIELDS

Text Fields can be searched with the following criteria:

- Equals, Not Equals, Starts With, Text Search
These criteria are represented as follows:
Equals:
{
"id": 0,
},
Not Equals
{
"id": 1,
},
Starts With
{
"id": 2,
},
Text Search
{
"id": 25,
}

Group 2 - DATE FIELDS

Date Fields can be searched with the following criteria:
( Note - X is number of days)
- Before, After, Between, Exactly, Newer than X, Older than X, Between X and Y, Current Week, Last Week, Month To Date, Last Month, Year To Date, Last Year
These criteria are represented as follows:
Before
{
"id": 6,
},
After
{
"id": 7,
},
Between
{
"id": 8,
},
Exactly
{
"id": 13,
},
Newer Than
{
"id": 12,
},
Older Than
{
"id": 11,
},
Between X and Y
{
"id": 18,
},
Current Week
{
"id": 19,
},
LastWeek
{
"id": 20,
},
Month To Date
{
"id": 21,
},
Last Month
{
"id": 22,
},
Year To Date
{
"id": 23,
},
Last Year
{
"id": 24,
}

Group 3 - DROPDOWN FIELDS

Dropdown fields can be searched with the following criteria:
- Equals, Not Equals, Select All
These criteria are represented as follows
Equals
{
"id": 0,
},
Not Equals
{
"id": 1,
},
Select All is the default and does not need to be specified in the search request body.

Group 4 - BOOLEAN FIELDS

Boolean fields (true or false) can be searched with the following criteria:
- Equals, Not Equals
These criteria are represented as follows:
Equals
{
"id": 0,
},
Not Equals
{
"id": 1,
},

Field Types

Field Types are specified using Ids, and are included in the body as "typeId"
These are the field types and their Ids:

  • TEXTFIELD: 0,
  • TEXTAREA: 1,
  • DATE: 2,
  • DROPDOWN: 3,
  • BOOLEAN: 4,
  • TYPEAHEAD: 5,
  • LOCATION: 6,
  • MULTIPLECHECKBOX: 7,
  • NUMBER: 8*

ITEMS SEARCH

The following fields can be searched for items:
Note the field name in parentheses - this will be used in our search request Json body

Group 1 - Text Fields

  • Description (Description)

  • Recovered At (RecoveredAt)

  • Make (Make)

  • Model (Model)

  • Serial Number (SerialNumber)

Group 2 Date Searches

  • Created Date (Created Date)
  • Recovery Date (Recovery Date)
  • Created Date (Created Date)

Group 3 Dropdown Fields

  • Custody Reason (CustodyReason)       
  • Status (Status)
  • Category (Category)

Group 4 Boolean Fields

       
  • Created By (Created By)       
  • Recovered By (Recovered By)       
  • Storage Location (Storage Location)

Examples

Here is the endpoint for an item search:
This is a POST request.
https://securelb.trackerproducts.com/api/items/search

Text Field Search With A Date Restriction

Here is the body for a search with a text field.
We are searching the description field with a value of "bottle" using the text search criteria type.
This value is added in the "model" property of the request body
Note that for "searchCriteria" we need to only provide the criteria id
Also note the "typeId" property is the field type as outlined above.
We are also searching a created date after 06-01-2018.
The "typeId" is now changed to the value corresponding to field type date
Note that "model" is the date of the search is the to date.
Also, dates can be searched with just day, month, and year or can be a full date with time.
So, the "model" below could also be "2018-06-01"

POST - https://securelb.trackerproducts.com/api/items/search
{ "tags": [],
"IsSearchingInSublocations": false,
"DynamicFields": [],
"StaticFields": [
{
"name": "ITEM_DATE_CREATED",
"typeId": 2,
"fieldName": "DateCreated",
"searchCriteriasType": 2,
"searchCriterias": [],
"searchCriteria": 7,
"toDate": null,
"model": "2018-06-01T04:00:00.000Z"
},
{
"name": "ITEM_DESCRIPTION",
"typeId": 1,
"fieldName": "Description",
"searchCriterias": [],
"searchCriteria": 25,
"model": "bottle"
},
{
"name": "NAV.TAGS",
"typeId": 5,
"fieldName": "Tags",
"searchCriteriasType": 1,
"typeAheadTemplate": "",
"searchCriterias": [],
"searchCriteria": 0,
"model": "tags"
},
{
"name": "SEARCH.OFFICE_SELECTION",
"typeId": 7,
"fieldName": "OfficeSelection",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "offices"
},
"searchCriterias": [],
"selectedOffices": [],
"model": [
{
"id": 1,
"name": "Tracker Products - 1 Office",
"selected": true
},
{
"id": 231,
"name": "Tracker Products - 231 Office",
"selected": true
}
],
"searchCriteria": 0
}
],
"officeIds": [
1,
231
],
"orderBy": "PrimaryCaseNumber",
"orderByAsc": true,
"PageSize": 100,
"peopleIds": [ ],
"PageNumber": 1,
"SavedSearchEntities": [
{
"name": "SEARCH.SAVED_SEARCH.CASES",
"typeId": 3,
"fieldName": "SavedSearchId_cases",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "cases"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
},
{
"id": 919,
"name": "All Cases"
},
{
"id": 920,
"name": "All Cases Last 365 Days"
},
{
"id": 978,
"name": "All Cases Drug Offense"
},
{
"id": 37034,
"name": "Case Officer Mike"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.DISPOSALS",
"typeId": 3,
"fieldName": "SavedSearchId_disposals",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "disposals"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.CHECKINS",
"typeId": 3,
"fieldName": "SavedSearchId_checkins",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "checkins"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.CHECKOUTS",
"typeId": 3,
"fieldName": "SavedSearchId_checkouts",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "checkouts"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.MOVES",
"typeId": 3,
"fieldName": "SavedSearchId_moves",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "moves"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.TRANSFERS",
"typeId": 3,
"fieldName": "SavedSearchId_transfers",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "transfers"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
}
]
}

This search returned 7 items, here is a sample of the data returned:

{
"count": 7,
"data": [
{
"formDataParsed": [],
"sequentialCaseId": "1",
"sequentialCaseIdNested": {
"section": 1,
"nested": null
},
"barcode": "8e9c1a40-18d6-477d-89fc-63bae6e93e76",
"description": "empty bottle",
"recoveryDate": "2018-06-14T04:00:00Z",
"recoveryLocation": "Newport, KY, USA",
"active": true,
"locationId": 45986,
"location": "Drawer 2",
"lastLocationId": 45986,
"lastLocation": "Drawer 2",
"statusId": 1,
"status": "Checked In",
"categoryId": 138,
"category": "Accessory",
"custodyReasonId": 5,
"custodyReason": "Evidence",
"recoveredById": 1,
"recoveredBy": "Jack Sparrow",
"submittedById": 1,
"submittedBy": "Jack Sparrow",
"custodianId": null,
"custodian": null,
"currentOfficeId": 1,
"primaryCaseId": 2933683,
"primaryCaseNumber": "2018-0614-01",
"primaryCaseOfficer": "Jack 3176D103FF Sparrow",
"isPrimaryCaseRestricted": false,
"make": null,
"model": null,
"serialNumber": null,
"creatingOrgId": 1,
"dateCreated": "2018-06-14T13:07:16.958Z",
"loaningOrgId": null,
"incomingOrgId": null,
"sequentialOrgId": 151006,
"cases": [
2933683
],
"caseModels": [],
"media": null,
"mediaAmount": 0,
"rootMediaFolderId": 0,
"formData": null,
"formDataAmount": 0,
"notes": [],
"notesAmount": 0,
"tags": [],
"tagsAmount": 0,
"barcodes": [],
"barcodesAmount": 0,
"id": 4932612,
"sqlId": 4801402,
"people": null,
"peopleIds": [],
"peopleNames": null,
"parentItemId": null,
"parentItemDescription": null,
"parentSequentialOrgId": null,
"childItems": [],
"childItemsAmount": 0,
"tasks": null,
"tasksAmount": 0,
"historiesAmount": 0,
"isForbidden": false
},
{


Group 2 - Date Fields

Here is a search for items with a created date in the last 7 days:
Note that the "model" is not needed for this search type.

POST - https://securelb.trackerproducts.com/api/items/search
{
"tags": [ ],
"IsSearchingInSublocations": false,
"DynamicFields": [ ],
"StaticFields": [
{
"name": "ITEM_DATE_CREATED",
"typeId": 2,
"fieldName": "DateCreated",
"searchCriteriasType": 2,
"searchCriterias": [],
"searchCriteria": 20,
"toDate": null
},
{
"name": "NAV.TAGS",
"typeId": 5,
"fieldName": "Tags",
"searchCriteriasType": 1,
"typeAheadTemplate": "",
"searchCriterias": [],
"searchCriteria": 0,
"model": "tags"
},
{
"name": "SEARCH.OFFICE_SELECTION",
"typeId": 7,
"fieldName": "OfficeSelection",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "offices"
},
"searchCriterias": [],
"selectedOffices": [],
"model": [
{
"id": 1,
"name": "Tracker Products - 1 Office",
"selected": true
},
{
"id": 231,
"name": "Tracker Products - 231 Office",
"selected": true
}
],
"searchCriteria": 0
}
],
"officeIds": [
1,
231
],
"orderBy": "PrimaryCaseNumber",
"orderByAsc": true,
"PageSize": 100,
"peopleIds": [ ],
"PageNumber": 1,
"SavedSearchEntities": [
{
"name": "SEARCH.SAVED_SEARCH.CASES",
"typeId": 3,
"fieldName": "SavedSearchId_cases",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "cases"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
},
{
"id": 919,
"name": "All Cases"
},
{
"id": 37034,
"name": "Case Officer Mike"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.DISPOSALS",
"typeId": 3,
"fieldName": "SavedSearchId_disposals",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "disposals"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.CHECKINS",
"typeId": 3,
"fieldName": "SavedSearchId_checkins",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "checkins"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.CHECKOUTS",
"typeId": 3,
"fieldName": "SavedSearchId_checkouts",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "checkouts"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.MOVES",
"typeId": 3,
"fieldName": "SavedSearchId_moves",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "moves"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.TRANSFERS",
"typeId": 3,
"fieldName": "SavedSearchId_transfers",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "transfers"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
}
]
}

And here is a sample of the returned data for this request: {
"count": 4,
"data": [
{
"formDataParsed": [
{
"value": "123456",
"searchName": "816.field2765",
"customFormId": 816,
"customFormName": "Test 2",
"fieldName": null,
"fieldType": "text",
"name": "Test Item Form",
"text": null
}
],
"sequentialCaseId": "3",
"sequentialCaseIdNested": {
"section": 3,
"nested": null
},
"barcode": "edc68cb1-f74a-41ab-a792-a27a39b61e5e",
"description": "iphone",
"recoveryDate": "2018-07-30T04:00:00Z",
"recoveryLocation": "Norwood, OH, USA",
"active": true,
"locationId": 45986,
"location": "Drawer 2",
"lastLocationId": 45986,
"lastLocation": "Drawer 2",
"statusId": 1,
"status": "Checked In",
"categoryId": 28,
"category": "Cellular Phone",
"custodyReasonId": 5,
"custodyReason": "Evidence",
"recoveredById": 1,
"recoveredBy": "Jack Sparrow",
"submittedById": 1,
"submittedBy": "Jack Sparrow",
"custodianId": null,
"custodian": null,
"currentOfficeId": 1,
"primaryCaseId": 2933700,
"primaryCaseNumber": "2018-0730-01",
"primaryCaseOfficer": "Jack 3176D103FF Sparrow",
"isPrimaryCaseRestricted": false,
"make": null,
"model": null,
"serialNumber": null,
"creatingOrgId": 1,
"dateCreated": "2018-07-30T15:08:41.103Z",
"loaningOrgId": null,
"incomingOrgId": null,
"sequentialOrgId": 151051,
"cases": [
2933700
],
"caseModels": [],
"media": null,
"mediaAmount": 0,
"rootMediaFolderId": 0,
"formData": null,
"formDataAmount": 1,
"notes": [],
"notesAmount": 0,
"tags": [
{
"tagModelId": 12406,
"name": "Phone"
}
],
"tagsAmount": 1,
"barcodes": [],
"barcodesAmount": 0,
"id": 4935657,
"sqlId": 4811445,
"people": null,
"peopleIds": [],
"peopleNames": null,
"parentItemId": null,
"parentItemDescription": null,
"parentSequentialOrgId": null,
"childItems": [],
"childItemsAmount": 0,
"tasks": null,
"tasksAmount": 0,
"historiesAmount": 0,
"isForbidden": false
},
{


Group 3 - Dropdown Fields

In order to search these fields you will first need to get the Ids that will be used as our "model" values

Dropdown fields can also be searched with not equals criteria.


Group 4 - Boolean Fields

Boolean fields can be searched by specifying true or false in the "model" property of the search request body.


Special Searches (items)

We recently changed the format in which we return custom search item data. Clients who have created integrations with this format can still receive search request data as before by using the following endpoint.
The difference here is the format in which this endpoint returns custom form data.
The body of this request will be slightly different if searching on a textfield. The available search criteria for this endpoint are as follows:

- Equals, Not Equals, Contains
These criteria are represented as follows:
Equals:
{
"id": 0,
},
Not Equals
{
"id": 1,
},
Contains
{
"id": 4,
},

POST - https://securelb.trackerproducts.com/api/items/searchMongo

And here is the body of the request: {
"tags": [],
"IsSearchingInSublocations": false,
"DynamicFields": [
],
"StaticFields": [
{
"name": "ITEM_DATE_CREATED",
"typeId": 2,
"fieldName": "DateCreated",
"searchCriteriasType": 2,
"searchCriterias": [],
"searchCriteria": 7,
"toDate": null,
"model": "2018-05-01T04:00:00.000Z"
},
{
"name": "ITEM_DESCRIPTION",
"typeId": 1,
"fieldName": "Description",
"searchCriterias": [],
"searchCriteria": 4,
"model": "bottle"
},
{
"name": "NAV.TAGS",
"typeId": 5,
"fieldName": "Tags",
"searchCriteriasType": 1,
"typeAheadTemplate": "",
"searchCriterias": [],
"searchCriteria": 0,
"model": "tags"
},
{
"name": "SEARCH.OFFICE_SELECTION",
"typeId": 7,
"fieldName": "OfficeSelection",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "offices"
},
"searchCriterias": [],\ "selectedOffices": [],
"model": [
{
"id": 1,
"name": "Tracker Products - 1 Office",
"selected": true
},
{
"id": 231,
"name": "Tracker Products - 231 Office",
"selected": true
}
],
"searchCriteria": 0
}
],
"officeIds": [
1,
231
],
"orderBy": "PrimaryCaseNumber",
"orderByAsc": true,
"PageSize": 100,
"peopleIds": [
],
"PageNumber": 1,\ "SavedSearchEntities": [
{
"name": "SEARCH.SAVED_SEARCH.CASES",
"typeId": 3,
"fieldName": "SavedSearchId_cases",\ "searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "cases"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
},
{
"id": 919,
"name": "All Cases"
},
{
"id": 920,
"name": "All Cases Last 365 Days"
},
{
"id": 37034,
"name": "Case Officer Mike"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.DISPOSALS",
"typeId": 3,
"fieldName": "SavedSearchId_disposals",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "disposals"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.CHECKINS",
"typeId": 3,
"fieldName": "SavedSearchId_checkins",
"searchCriteriasType": 5,\ "dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "checkins"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.CHECKOUTS",
"typeId": 3,
"fieldName": "SavedSearchId_checkouts",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "checkouts"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.MOVES",
"typeId": 3,
"fieldName": "SavedSearchId_moves",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "moves"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
},
{
"name": "SEARCH.SAVED_SEARCH.TRANSFERS",
"typeId": 3,
"fieldName": "SavedSearchId_transfers",
"searchCriteriasType": 5,
"dropdownEntities": {
"entity": "SavedSearches",
"options": {
"model": "transfers"
}
},
"searchCriterias": [],
"dropdownValues": [
{
"id": null,
"name": "Select all"
}
],
"searchCriteria": 0
}
]
}

This returns the following results: {
"count": 20,
"data": [
{
"formDataParsed": [
{
"value": "123456",
"searchName": "816.field2765",
"customFormId": 816,
"customFormName": "Test 2",
"fieldName": null,
"fieldType": "text",
"name": "Test Item Form",
"text": null
}
],
"sequentialCaseId": "1",
"sequentialCaseIdNested": {
"section": 1,
"nested": null
},
"barcode": "93946b8c-9846-4d60-8456-64cdf6bd99d8",
"description": "empty bottle",
"recoveryDate": "2018-05-11T04:00:00Z",
"recoveryLocation": "Newport, KY, USA",
"active": true,
"locationId": 45986,
"location": "Drawer 2",
"lastLocationId": 45986,
"lastLocation": "Drawer 2",
"statusId": 1,
"status": "Checked In",
"categoryId": 138,
"category": "Accessory",
"custodyReasonId": 5,
"custodyReason": "Evidence",
"recoveredById": 1,
"recoveredBy": "Jack Sparrow",
"submittedById": 1,
"submittedBy": "Jack Sparrow",
"custodianId": null,
"custodian": null,
"currentOfficeId": 1,
"primaryCaseId": 2933670,
"primaryCaseNumber": "2018-0511-01",
"primaryCaseOfficer": "Jack 3176D103FF Sparrow",
"isPrimaryCaseRestricted": false,
"make": null,
"model": null,
"serialNumber": null,
"creatingOrgId": 1,
"dateCreated": "2018-05-11T17:13:30.912Z",
"loaningOrgId": null,
"incomingOrgId": null,
"sequentialOrgId": 150996,
"cases": [
2933670
],
"caseModels": [],
"media": null,
"mediaAmount": 8,
"rootMediaFolderId": 153732,
"formData": [
{
"id": "5b6b6996185c8a2a00cf6e63",
"active": true,
"entityId": 4932596,
"formId": 816,
"formName": "Test 2",
"dateFields": null,
"data": "{\"field2765\":\"123456\"}",
"organizationId": 1,
"officeId": 1,
"visibilityId": 0
}
],
"formDataAmount": 1,
"notes": [],
"notesAmount": 0,
"tags": [],
"tagsAmount": 0,
"barcodes": [],
"barcodesAmount": 0,
"id": 4932596,
"sqlId": 4791388,
"people": null,
"peopleIds": [],
"peopleNames": null,
"parentItemId": null,
"parentItemDescription": null,
"parentSequentialOrgId": null,
"childItems": [],
"childItemsAmount": 0,
"tasks": [],
"tasksAmount": 0,
"historiesAmount": 0,
"isForbidden": false
},
{
"formDataParsed": [],
"sequentialCaseId": "2",
"sequentialCaseIdNested": {
"section": 2,
"nested": null
},
"barcode": "a60afee7-e739-489a-848d-ec342327b1bf",\ "description": "empty bottle 2",
"recoveryDate": "2018-05-11T04:00:00Z",
"recoveryLocation": "Newport, KY, USA",
"active": true,
"locationId": null,
"location": null,
"lastLocationId": 45986,
"lastLocation": "Drawer 2",
"statusId": 2,
"status": "Checked Out",
"categoryId": 138,
"category": "Accessory",
"custodyReasonId": 5,
"custodyReason": "Evidence",
"recoveredById": 1,
"recoveredBy": "Jack Sparrow",
"submittedById": 1,
"submittedBy": "Jack Sparrow",
"custodianId": 1,
"custodian": "Jack 3176D103FF Sparrow",
"currentOfficeId": 1,
"primaryCaseId": 2933670,
"primaryCaseNumber": "2018-0511-01",
"primaryCaseOfficer": "Jack 3176D103FF Sparrow",
"isPrimaryCaseRestricted": false,
"make": null,
"model": null,
"serialNumber": null,
"creatingOrgId": 1,
"dateCreated": "2018-05-11T17:14:11.204Z",
"loaningOrgId": null,
"incomingOrgId": null,
"sequentialOrgId": 150997,
"cases": [
2933670
],
"caseModels": [],
"media": null,
"mediaAmount": 0,
"rootMediaFolderId": 153733,
"formData": null,
"formDataAmount": 0,
"notes": [],
"notesAmount": 0,
"tags": [],
"tagsAmount": 0,
"barcodes": [],
"barcodesAmount": 0,
"id": 4932597,
"sqlId": 4791389,
"people": null,
"peopleIds": [],
"peopleNames": null,
"parentItemId": null,
"parentItemDescription": null,
"parentSequentialOrgId": null,
"childItems": [],
"childItemsAmount": 0,
"tasks": [],
"tasksAmount": 0,
"historiesAmount": 0,
"isForbidden": false
},