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	Type	Additional information
TotalCountFromPriorFetch	integer	None.
AdditionalSkipCount	integer	None.
PageSize	integer	None.
PageNumber	integer	None.
Sort	Collection of Object	None.
Filter	TopLevelFilterType	None.
ClientUtcOffset	TimeZoneInfoId	None.
FilterBehavior	FilterBehaviorFlags	None.
IgnoreAttachments	boolean	None.
IgnoreGeoLocation	boolean	None.
WorkingSiteIdCsvList	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	Type	Additional information
Data	Collection of TransactionHistoryResponseModel	None.
Messages	Collection of WtResult	None.
BatchNumber	integer	None.
HasError	boolean	None.
HasHttpError	boolean	None.
HasMessage	boolean	None.
HasSuccessWithMoreDataRemaining	boolean	None.
TotalRecordsLongCount	integer	None.

Response Formats

application/json

Sample:

{
  "Data": [
    {
      "OtherSiteName": "sample string 1",
      "WaspInternalArchiveDate": "2026-02-27T14:06:33.5569208+00:00",
      "OtherLocationCode": "sample string 2",
      "DepartmentCode": "sample string 3",
      "TransactionAttachments": [
        {
          "TransactionId": 1,
          "AttachmentId": 2,
          "AttachmentIsDefault": true,
          "AttachmentRecordStatus": 3,
          "AttachmentGuid": "b0018121-ecf4-4cef-bfcc-c83b900370b2",
          "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": "b0018121-ecf4-4cef-bfcc-c83b900370b2",
          "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-27T14:06:33.5569208+00:00",
          "NoteText": "sample string 4",
          "UserId": "fdf6a6ea-5e88-4cab-9055-ff9f0c1cf652",
          "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-27T14:06:33.5569208+00:00",
          "NoteText": "sample string 4",
          "UserId": "fdf6a6ea-5e88-4cab-9055-ff9f0c1cf652",
          "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": "6bd726e0-5b5c-441e-8303-27acbe0d765a",
      "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": "90b50e2e-7c69-43e0-bda8-adc04d345a14",
      "AssetTransDate": "2026-02-27T14:06:33.5569208+00:00",
      "SortingIndex": 81,
      "UserLogon": "sample string 82",
      "ReasonId": 1,
      "AssetTransEntryDate": "2026-02-27T14:06:33.5569208+00:00",
      "CustomerFirstName": "sample string 84",
      "CustomerLastName": "sample string 85",
      "SerialNumber": "sample string 86",
      "UserTransactionDate": "2026-02-27T14:06:33.5569208+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-27T14:06:33.5569208+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-27T14:06:33.5569208+00:00",
      "OtherLocationCode": "sample string 2",
      "DepartmentCode": "sample string 3",
      "TransactionAttachments": [
        {
          "TransactionId": 1,
          "AttachmentId": 2,
          "AttachmentIsDefault": true,
          "AttachmentRecordStatus": 3,
          "AttachmentGuid": "b0018121-ecf4-4cef-bfcc-c83b900370b2",
          "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": "b0018121-ecf4-4cef-bfcc-c83b900370b2",
          "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-27T14:06:33.5569208+00:00",
          "NoteText": "sample string 4",
          "UserId": "fdf6a6ea-5e88-4cab-9055-ff9f0c1cf652",
          "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-27T14:06:33.5569208+00:00",
          "NoteText": "sample string 4",
          "UserId": "fdf6a6ea-5e88-4cab-9055-ff9f0c1cf652",
          "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": "6bd726e0-5b5c-441e-8303-27acbe0d765a",
      "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": "90b50e2e-7c69-43e0-bda8-adc04d345a14",
      "AssetTransDate": "2026-02-27T14:06:33.5569208+00:00",
      "SortingIndex": 81,
      "UserLogon": "sample string 82",
      "ReasonId": 1,
      "AssetTransEntryDate": "2026-02-27T14:06:33.5569208+00:00",
      "CustomerFirstName": "sample string 84",
      "CustomerLastName": "sample string 85",
      "SerialNumber": "sample string 86",
      "UserTransactionDate": "2026-02-27T14:06:33.5569208+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-27T14:06:33.5569208+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
}