POST public-api/transactions/grid-query/transaction-history

Deprecated. Please use grid-query/transaction-history-v2 This API is filterable, sortable, and page-able. It returns a list of the transaction history, very similar to what is returned in the Transaction History web interface.

Request Information

URI Parameters

None.

Body Parameters

GridRequestModel

Name	Description	Type	Additional information
TotalCountFromPriorFetch	This field helps to skip the page count recalculation that goes into calculating the TotalRecordsLongCount. For example - When paging through data using functions like the assetadvancedinfosearch, calculating TotalRecordsLongCount for every page full of data is a time-consuming operation. To avoid that extra calculation, and help prevent throttling, TotalRecordsLongCount is assigned to TotalCountFromPriorFetch in the AdvancedSearchParameters to skip recalculating this total page count and to page through the records faster. By default, this value is a null value, meaning the api should peform a record count of the data prior to fetching the records.	integer	None.
AdditionalSkipCount	This is the additional number of records to skip, in addition to page size and page #. This is useful for quick filter (more) mode of operation. This field is not implemented.	integer	None.
PageSize	Due to the large number of records this API may return, this is a paging API. Set this value to specify the number of records you wish to process per API call. (Recommended 100-500). Note: some grid query api will ignore or cap this value if the requested page size is too large. A large page size (several thousands) could overflow or degrade the serialization of return data.	integer	None.
PageNumber	Due to the large number of records this API may return, this is a paging API. Set this value to specify the page number or record set you wish to process. Generally you would want to keep the PageSize constant (Recommended 100-500) and loop thru the results incrementing this PageNumber until the number of records returned is less than the value you specified for PageSize.	integer	None.
Sort	This is an expression tree. Set this to specify all the columns you wish to sort the data by. Default None. Expects a collection of fieldnames and sort direction: [{"Field":"TotalAvailable","Dir":"desc"}]	Collection of Object	None.
Filter	This is an expression tree. Set this to specify all the columns, values and operators you wish to filter the data by. Default None.	TopLevelFilterType	None.
ClientUtcOffset	If you provide a valid expression tree for the Filter parameter and the filter expression you provide performs one or more comparisons of DateTime values with constants then set this to specify which time zone your DateTime constants represent. Common ClientUtcOffset string values include: Dateline Standard Time, UTC-11, Hawaiian Standard Time, Marquesas Standard Time, Alaskan Standard Time, Pacific Standard Time, Mountain Standard Time, Central Standard Time, Eastern Standard Time, Venezuela Standard Time, Atlantic Standard Time, Newfoundland Standard Time, Greenland Standard Time, UTC-02, Cape Verde Standard Time, GMT Standard Time, W. Europe Standard Time, GTB Standard Time, Russian Standard Time, Arabian Standard Time, Afghanistan Standard Time, Pakistan Standard Time, India Standard Time, China Standard Time, Tokyo Standard Time, AUS Central Standard Time, West Pacific Standard Time, Central Pacific Standard Time, Fiji Standard Time, Samoa Standard Time.	TimeZoneInfoId	None.
FilterBehavior	Internal - specific filter behaviors	FilterBehaviorFlags	None.
IgnoreAttachments	When set to true, does not get the attachment data	boolean	None.
IgnoreGeoLocation	When set to true, does not get the geo location data	boolean	None.
WorkingSiteIdCsvList	Use this comma separated list for values to efficiently filter results to one or more sites.	string	None.

Request Formats

application/json

Sample:

{
  "_sortCriteria": [],
  "TotalCountFromPriorFetch": 1,
  "AdditionalSkipCount": 1,
  "PageSize": 2,
  "PageNumber": 3,
  "Filter": {
    "$id": "1",
    "field": "sample string 1",
    "operator": "sample string 2",
    "value": {},
    "logic": "sample string 4",
    "filters": []
  },
  "ClientUtcOffset": null,
  "FilterBehavior": 0,
  "IgnoreAttachments": true,
  "IgnoreGeoLocation": true,
  "WorkingSiteIdCsvList": "6"
}

Response Information

Resource Description

WaspResultOfListOfTransactionHistoryResponseModel

Name	Description	Type	Additional information
Data	Type specific result that always depends on the function called.	Collection of TransactionHistoryResponseModel	None.
Messages	List of Messages. All APIs should return messages. If an API function returns an error you can find more information about the error or errors in this collection of messages.	Collection of WtResult	None.
BatchNumber	This is a global batch number generated by a mass group of transaction records to be returned to the consumer on each call to rolling transaction rules. This requests that each group of Move/Add/Remove transaction batches is tied together. In prior products (such as Mobile Asset Cloud), all are set to null and the only time when the batch number is generated is for multiple check-out transactions but the old is to generate for each responsible party.	integer	None.
HasError	True if an API function result has an error message in the results. If this is false, the function succeeded but other informative messages may be available.	boolean	None.
HasHttpError	True if an API function call could not be fully posted to the server or the results could not be fully returned.	boolean	None.
HasMessage	True if any message is available.	boolean	None.
HasSuccessWithMoreDataRemaining	True if the server sent part of the data and there is more data available. Use with paging APIs to fetch data one page at a time.	boolean	None.
TotalRecordsLongCount	This is the total number of records available in the database based on the query and filer conditions provided. It is possible that the value can change from call to call as users add and delete records so this should not be used to page through multiple recordsets of data. This is used, for example, to set relative scroll bar sizes. When paging through data using functions like the assetadvancedinfosearch, calculating TotalRecordsLongCount for every page full of data is an time-consuming operation. To avoid that extra calculation, and help prevent throttling, assign TotalRecordsLongCount to TotalCountFromPriorFetch in the AdvancedSearchParameters to skip recalculating this total page count and to page thru the records faster.	integer	None.

Response Formats

application/json

Sample:

{
  "Data": [
    {
      "OtherSiteName": "sample string 1",
      "WaspInternalArchiveDate": "2026-02-09T03:05:26.8006451+00:00",
      "OtherLocationCode": "sample string 2",
      "DepartmentCode": "sample string 3",
      "TransactionAttachments": [
        {
          "TransactionId": 1,
          "AttachmentId": 2,
          "AttachmentIsDefault": true,
          "AttachmentRecordStatus": 3,
          "AttachmentGuid": "96442d46-543a-4512-9da2-88ba16171ff9",
          "AttachmentDataType": "sample string 4",
          "AttachmentDataSize": 1,
          "AttachmentData": "QEA=",
          "AttachmentUriPath": "sample string 5",
          "AttachmentFileName": "sample string 6"
        },
        {
          "TransactionId": 1,
          "AttachmentId": 2,
          "AttachmentIsDefault": true,
          "AttachmentRecordStatus": 3,
          "AttachmentGuid": "96442d46-543a-4512-9da2-88ba16171ff9",
          "AttachmentDataType": "sample string 4",
          "AttachmentDataSize": 1,
          "AttachmentData": "QEA=",
          "AttachmentUriPath": "sample string 5",
          "AttachmentFileName": "sample string 6"
        }
      ],
      "TransactionNotes": [
        {
          "TransactionId": 1,
          "NoteId": 2,
          "TransactionUniqueIdentitifier": "sample string 3",
          "NoteDate": "2026-02-09T03:05:26.8006451+00:00",
          "NoteText": "sample string 4",
          "UserId": "643ab372-f774-4eb8-9011-7ee621483871",
          "UserEmail": "sample string 5",
          "UserFirstName": "sample string 6",
          "UserLastName": "sample string 7",
          "UserLogon": "sample string 8",
          "UserTitle": "sample string 9"
        },
        {
          "TransactionId": 1,
          "NoteId": 2,
          "TransactionUniqueIdentitifier": "sample string 3",
          "NoteDate": "2026-02-09T03:05:26.8006451+00:00",
          "NoteText": "sample string 4",
          "UserId": "643ab372-f774-4eb8-9011-7ee621483871",
          "UserEmail": "sample string 5",
          "UserFirstName": "sample string 6",
          "UserLastName": "sample string 7",
          "UserLogon": "sample string 8",
          "UserTitle": "sample string 9"
        }
      ],
      "HasNotes": "sample string 4",
      "HasSignature": "sample string 5",
      "SalesPrice": 1.0,
      "TransTypeNo": 6,
      "AlternateCaptureUomId": 1,
      "AssetClassId": 7,
      "AssetId": 8,
      "AssetTransactionId": 9,
      "AssetTypeCategoryId": 10,
      "AssetTypeId": 11,
      "AssetTypeManufacturerId": 12,
      "AssetTypeSupplierId": 13,
      "ConditionId": 14,
      "ManufacturerId": 15,
      "RowNumber": 16,
      "SiteId": 17,
      "TrackbyId": 18,
      "TransUserRoleId": 19,
      "AssetTransactionCostKeyId": 1,
      "AssetTransactionIdRank": 1,
      "AssetTransactionLocationKeyId": 1,
      "AssetTransOtherAssetId": 1,
      "AssetTransOtherTransId": 1,
      "CustomerId": 1,
      "DepartmentId": 1,
      "DisposeReasonId": 1,
      "EmployeeId": 1,
      "EmployeeManagerId": 1,
      "LocationId": 1,
      "ContainerId": 1,
      "AtlkContainerLocationId": 20,
      "OrganizationId": 1,
      "PoId": 1,
      "OrderLineId": 1,
      "SupplierId": 1,
      "TransUserDepartmentId": 1,
      "UserManagerId": 1,
      "UserType": 1,
      "EmployeeUserId": "08190bfd-4553-4b50-9e87-92e883040308",
      "AssetApplicationId": 21,
      "TransactionApplicationId": 22,
      "TransQtyUsingAlternateUomId": 1.0,
      "TransactionUniqueIdentitifer": "sample string 23",
      "IsSystemGenerated": true,
      "AssetTransCheckoutQtyCurrentQty": 1.0,
      "AssetTransCost": 1.0,
      "AssetTransCurrentQty": 1.0,
      "AssetTransQtyCurrentQty": 1.0,
      "AssetTransQuantity": 1.0,
      "CurrentQtyInstantaneouslyAtLocationKeyId": 1.0,
      "AssetDefaultCost": 1.0,
      "OrderNumber": "sample string 24",
      "AssetTransBatchNo": "sample string 25",
      "AssetDescription": "sample string 26",
      "AssetModel": "sample string 27",
      "AssetSerialNumber": "sample string 28",
      "AssetTag": "sample string 29",
      "AssetTransReceiptNum": "sample string 30",
      "AssetTransRecordSource": "sample string 31",
      "AssetTypeDescription": "sample string 32",
      "AssetTypeModelNumber": "sample string 33",
      "AssetTypeNumber": "sample string 34",
      "CustomerCompanyName": "sample string 35",
      "CustomerContactEmail": "sample string 36",
      "CustomerContactFirstName": "sample string 37",
      "CustomerContactLastName": "sample string 38",
      "CustomerNumber": "sample string 39",
      "EmployeeEmail": "sample string 40",
      "EmployeeFirstName": "sample string 41",
      "EmployeeLastName": "sample string 42",
      "EmployeeNumber": "sample string 43",
      "LocationCodeOrigValue": "sample string 44",
      "LocationCode": "sample string 45",
      "LocationFullPath": "sample string 46",
      "LocationPrefix": "sample string 47",
      "ParentContainerId": "sample string 48",
      "ContainerTag": "sample string 48",
      "LocationDescription": "sample string 49",
      "ReasonCode": "sample string 50",
      "ReasonLangLabel": "sample string 51",
      "SiteDescription": "sample string 52",
      "SiteName": "sample string 53",
      "SupplierContactEmail": "sample string 54",
      "SupplierContactName": "sample string 55",
      "SupplierEmail": "sample string 56",
      "SupplierName": "sample string 57",
      "SupplierNumber": "sample string 58",
      "SupplierWebsite": "sample string 59",
      "TransExtCustom1": "sample string 60",
      "TransExtCustom10": "sample string 61",
      "TransExtCustom2": "sample string 62",
      "TransExtCustom3": "sample string 63",
      "TransExtCustom4": "sample string 64",
      "TransExtCustom5": "sample string 65",
      "TransExtCustom6": "sample string 66",
      "TransExtCustom7": "sample string 67",
      "TransExtCustom8": "sample string 68",
      "TransExtCustom9": "sample string 69",
      "TransExtCustomer": "sample string 70",
      "TransExtReferenceNumber": "sample string 71",
      "TransExtSupplier": "sample string 72",
      "TransExtSalesPrice": 1.0,
      "TransTypeDescription": "sample string 73",
      "TransTypeLangLabel": "sample string 74",
      "UserEmail": "sample string 75",
      "UserFirstName": "sample string 76",
      "UserLastName": "sample string 77",
      "UserTitle": "sample string 78",
      "UserId": "f568889d-de1f-46b2-9c33-5388efc111fd",
      "AssetTransDate": "2026-02-09T03:05:26.8006451+00:00",
      "SortingIndex": 81,
      "UserLogon": "sample string 82",
      "ReasonId": 1,
      "AssetTransEntryDate": "2026-02-09T03:05:26.8006451+00:00",
      "CustomerFirstName": "sample string 84",
      "CustomerLastName": "sample string 85",
      "SerialNumber": "sample string 86",
      "UserTransactionDate": "2026-02-09T03:05:26.8006451+00:00",
      "TransactionCost": 1.0,
      "Category": "sample string 87",
      "ActionItem": "sample string 88",
      "ManufacturerName": "sample string 89",
      "Assignee": "sample string 90",
      "CustomerNameCalculated": "sample string 91",
      "VendorSupplierNameCalculated": "sample string 92",
      "TransactionDueDate": "2026-02-09T03:05:26.8006451+00:00",
      "Lot": "sample string 93",
      "DateCode": "sample string 94",
      "RefNumber": "sample string 95",
      "TrackbyContainerId": "sample string 96",
      "LicensePlateNumber": "sample string 96",
      "BaseUomToAlternateUomDivisor": 1.0,
      "NameOfAlternateUomId": "sample string 97",
      "Latitude": 1.0,
      "Longitude": 1.0,
      "Altitude": 1.0,
      "Accuracy": 1.0
    },
    {
      "OtherSiteName": "sample string 1",
      "WaspInternalArchiveDate": "2026-02-09T03:05:26.8006451+00:00",
      "OtherLocationCode": "sample string 2",
      "DepartmentCode": "sample string 3",
      "TransactionAttachments": [
        {
          "TransactionId": 1,
          "AttachmentId": 2,
          "AttachmentIsDefault": true,
          "AttachmentRecordStatus": 3,
          "AttachmentGuid": "96442d46-543a-4512-9da2-88ba16171ff9",
          "AttachmentDataType": "sample string 4",
          "AttachmentDataSize": 1,
          "AttachmentData": "QEA=",
          "AttachmentUriPath": "sample string 5",
          "AttachmentFileName": "sample string 6"
        },
        {
          "TransactionId": 1,
          "AttachmentId": 2,
          "AttachmentIsDefault": true,
          "AttachmentRecordStatus": 3,
          "AttachmentGuid": "96442d46-543a-4512-9da2-88ba16171ff9",
          "AttachmentDataType": "sample string 4",
          "AttachmentDataSize": 1,
          "AttachmentData": "QEA=",
          "AttachmentUriPath": "sample string 5",
          "AttachmentFileName": "sample string 6"
        }
      ],
      "TransactionNotes": [
        {
          "TransactionId": 1,
          "NoteId": 2,
          "TransactionUniqueIdentitifier": "sample string 3",
          "NoteDate": "2026-02-09T03:05:26.8006451+00:00",
          "NoteText": "sample string 4",
          "UserId": "643ab372-f774-4eb8-9011-7ee621483871",
          "UserEmail": "sample string 5",
          "UserFirstName": "sample string 6",
          "UserLastName": "sample string 7",
          "UserLogon": "sample string 8",
          "UserTitle": "sample string 9"
        },
        {
          "TransactionId": 1,
          "NoteId": 2,
          "TransactionUniqueIdentitifier": "sample string 3",
          "NoteDate": "2026-02-09T03:05:26.8006451+00:00",
          "NoteText": "sample string 4",
          "UserId": "643ab372-f774-4eb8-9011-7ee621483871",
          "UserEmail": "sample string 5",
          "UserFirstName": "sample string 6",
          "UserLastName": "sample string 7",
          "UserLogon": "sample string 8",
          "UserTitle": "sample string 9"
        }
      ],
      "HasNotes": "sample string 4",
      "HasSignature": "sample string 5",
      "SalesPrice": 1.0,
      "TransTypeNo": 6,
      "AlternateCaptureUomId": 1,
      "AssetClassId": 7,
      "AssetId": 8,
      "AssetTransactionId": 9,
      "AssetTypeCategoryId": 10,
      "AssetTypeId": 11,
      "AssetTypeManufacturerId": 12,
      "AssetTypeSupplierId": 13,
      "ConditionId": 14,
      "ManufacturerId": 15,
      "RowNumber": 16,
      "SiteId": 17,
      "TrackbyId": 18,
      "TransUserRoleId": 19,
      "AssetTransactionCostKeyId": 1,
      "AssetTransactionIdRank": 1,
      "AssetTransactionLocationKeyId": 1,
      "AssetTransOtherAssetId": 1,
      "AssetTransOtherTransId": 1,
      "CustomerId": 1,
      "DepartmentId": 1,
      "DisposeReasonId": 1,
      "EmployeeId": 1,
      "EmployeeManagerId": 1,
      "LocationId": 1,
      "ContainerId": 1,
      "AtlkContainerLocationId": 20,
      "OrganizationId": 1,
      "PoId": 1,
      "OrderLineId": 1,
      "SupplierId": 1,
      "TransUserDepartmentId": 1,
      "UserManagerId": 1,
      "UserType": 1,
      "EmployeeUserId": "08190bfd-4553-4b50-9e87-92e883040308",
      "AssetApplicationId": 21,
      "TransactionApplicationId": 22,
      "TransQtyUsingAlternateUomId": 1.0,
      "TransactionUniqueIdentitifer": "sample string 23",
      "IsSystemGenerated": true,
      "AssetTransCheckoutQtyCurrentQty": 1.0,
      "AssetTransCost": 1.0,
      "AssetTransCurrentQty": 1.0,
      "AssetTransQtyCurrentQty": 1.0,
      "AssetTransQuantity": 1.0,
      "CurrentQtyInstantaneouslyAtLocationKeyId": 1.0,
      "AssetDefaultCost": 1.0,
      "OrderNumber": "sample string 24",
      "AssetTransBatchNo": "sample string 25",
      "AssetDescription": "sample string 26",
      "AssetModel": "sample string 27",
      "AssetSerialNumber": "sample string 28",
      "AssetTag": "sample string 29",
      "AssetTransReceiptNum": "sample string 30",
      "AssetTransRecordSource": "sample string 31",
      "AssetTypeDescription": "sample string 32",
      "AssetTypeModelNumber": "sample string 33",
      "AssetTypeNumber": "sample string 34",
      "CustomerCompanyName": "sample string 35",
      "CustomerContactEmail": "sample string 36",
      "CustomerContactFirstName": "sample string 37",
      "CustomerContactLastName": "sample string 38",
      "CustomerNumber": "sample string 39",
      "EmployeeEmail": "sample string 40",
      "EmployeeFirstName": "sample string 41",
      "EmployeeLastName": "sample string 42",
      "EmployeeNumber": "sample string 43",
      "LocationCodeOrigValue": "sample string 44",
      "LocationCode": "sample string 45",
      "LocationFullPath": "sample string 46",
      "LocationPrefix": "sample string 47",
      "ParentContainerId": "sample string 48",
      "ContainerTag": "sample string 48",
      "LocationDescription": "sample string 49",
      "ReasonCode": "sample string 50",
      "ReasonLangLabel": "sample string 51",
      "SiteDescription": "sample string 52",
      "SiteName": "sample string 53",
      "SupplierContactEmail": "sample string 54",
      "SupplierContactName": "sample string 55",
      "SupplierEmail": "sample string 56",
      "SupplierName": "sample string 57",
      "SupplierNumber": "sample string 58",
      "SupplierWebsite": "sample string 59",
      "TransExtCustom1": "sample string 60",
      "TransExtCustom10": "sample string 61",
      "TransExtCustom2": "sample string 62",
      "TransExtCustom3": "sample string 63",
      "TransExtCustom4": "sample string 64",
      "TransExtCustom5": "sample string 65",
      "TransExtCustom6": "sample string 66",
      "TransExtCustom7": "sample string 67",
      "TransExtCustom8": "sample string 68",
      "TransExtCustom9": "sample string 69",
      "TransExtCustomer": "sample string 70",
      "TransExtReferenceNumber": "sample string 71",
      "TransExtSupplier": "sample string 72",
      "TransExtSalesPrice": 1.0,
      "TransTypeDescription": "sample string 73",
      "TransTypeLangLabel": "sample string 74",
      "UserEmail": "sample string 75",
      "UserFirstName": "sample string 76",
      "UserLastName": "sample string 77",
      "UserTitle": "sample string 78",
      "UserId": "f568889d-de1f-46b2-9c33-5388efc111fd",
      "AssetTransDate": "2026-02-09T03:05:26.8006451+00:00",
      "SortingIndex": 81,
      "UserLogon": "sample string 82",
      "ReasonId": 1,
      "AssetTransEntryDate": "2026-02-09T03:05:26.8006451+00:00",
      "CustomerFirstName": "sample string 84",
      "CustomerLastName": "sample string 85",
      "SerialNumber": "sample string 86",
      "UserTransactionDate": "2026-02-09T03:05:26.8006451+00:00",
      "TransactionCost": 1.0,
      "Category": "sample string 87",
      "ActionItem": "sample string 88",
      "ManufacturerName": "sample string 89",
      "Assignee": "sample string 90",
      "CustomerNameCalculated": "sample string 91",
      "VendorSupplierNameCalculated": "sample string 92",
      "TransactionDueDate": "2026-02-09T03:05:26.8006451+00:00",
      "Lot": "sample string 93",
      "DateCode": "sample string 94",
      "RefNumber": "sample string 95",
      "TrackbyContainerId": "sample string 96",
      "LicensePlateNumber": "sample string 96",
      "BaseUomToAlternateUomDivisor": 1.0,
      "NameOfAlternateUomId": "sample string 97",
      "Latitude": 1.0,
      "Longitude": 1.0,
      "Altitude": 1.0,
      "Accuracy": 1.0
    }
  ],
  "Messages": [
    {
      "ResultCode": 0,
      "Message": "sample string 1",
      "HttpStatusCode": 200,
      "FieldName": "sample string 2"
    },
    {
      "ResultCode": 0,
      "Message": "sample string 1",
      "HttpStatusCode": 200,
      "FieldName": "sample string 2"
    }
  ],
  "BatchNumber": 1,
  "HasError": false,
  "HasHttpError": false,
  "HasMessage": true,
  "HasSuccessWithMoreDataRemaining": false,
  "TotalRecordsLongCount": 1
}