List Items

Retrieves List of items from the database.

Retrieve product data from Xorosoft ERP using the supported query filters. Use this endpoint to synchronize reference or transaction data with external systems while respecting private app permissions.

get

Authorizations

AuthorizationstringRequired

Query parameters

idnumberOptional

A comma-separated list of item ids.

item_numberstringOptional

A comma-separated list of item numbers.

since_idstringOptional

Restrict results to after the specified ID.

created_at_minstringOptional

Show items created at or after date (format: 2014-04-25T16:15:47-04:00).

updated_at_minstringOptional

Show items updated at or after date (format: 2014-04-25T16:15:47-04:00).

created_at_maxstringOptional

Show items created at or before date (format: 2014-04-25T16:15:47-04:00).

updated_at_maxstringOptional

Show items updated at or before date (format: 2014-04-25T16:15:47-04:00.

upcstringOptional

Universal product code assigned to the item.

base_part_numberstringOptional

Base part number used to identify a product family or variant group.

tagsstringOptional

Comma-separated tags used to filter matching records.

option1_valuestringOptional

Variant option 1 value, such as size, color, or another configured product option.

option2_valuestringOptional

Variant option 2 value, such as size, color, or another configured product option.

pagestringOptional

Page number for paginated responses.

Default: 1

account3pl_idstringOptional

3PL account identifier.

seasonstringOptional

Season name or code assigned to the product or item.

querystringOptional

Search text used by the endpoint where supported.

Responses

200

OK

application/json

IsForwardRequestbooleanOptional

MessagestringOptional

MessageTitlestring · nullableOptional

ResultbooleanOptional

get/api/xerp/product/item/getitem

GET /api/xerp/product/item/getitem HTTP/1.1
Host: res.xorosoft.io
Authorization: Basic username:password
Accept: */*

200

OK

{
  "Data": [
    {
      "ActiveFlag": true,
      "ActiveFlagStr": null,
      "AdjAccntId": "B78982BA2D4920A8A4458A69483E",
      "AdjAccountName": "Inventory Adjustment",
      "AlertNote": "Alert note testing",
      "AllowBackorderFlag": false,
      "AssetAccntId": "B78982BA2D4904D8EC7BC2DD4107",
      "AssetAccountName": "Inventory Asset",
      "BasePartNumber": "BC",
      "BrandId": null,
      "BrandName": "",
      "CARB": "",
      "CategoryId": null,
      "CategoryName": "",
      "CogsAccntId": "B78982BA2D4986B2025A1F184BE8",
      "CogsAccountName": "Cost of Goods Sold",
      "CooCodeIso2": "",
      "CreateDttm": "07/18/2018 11:10:08 AM",
      "CreateSource": "xadmin",
      "CurrencyCode": null,
      "CurrencyPriceList": [],
      "CustomPrice1": null,
      "CustomPrice10": null,
      "CustomPrice11": null,
      "CustomPrice12": null,
      "CustomPrice13": null,
      "CustomPrice14": null,
      "CustomPrice2": null,
      "CustomPrice3": null,
      "CustomPrice4": null,
      "CustomPrice5": null,
      "CustomPrice6": null,
      "CustomPrice7": null,
      "CustomPrice8": null,
      "CustomPrice9": null,
      "CustomPriceLabels": null,
      "DefaultLocationClassName": "",
      "DefaultLocationId": null,
      "DefaultLocationName": "",
      "DefaultStoreId": null,
      "DefaultStoreName": "",
      "DefaultVendorId": null,
      "DefaultVendorName": "",
      "Description": "Battery Connector",
      "DiscountedPrice": null,
      "DoNotUpdateAccounts": false,
      "DropShipItemFlag": false,
      "ExpenseAccntId": "",
      "ExpenseAccountName": "",
      "ExpirationDate": null,
      "ForceSalesTaxCode": false,
      "ForceSalesTaxCodeStr": "N",
      "GenderCode": "",
      "GroupId": null,
      "GroupName": "",
      "HSCode": "",
      "HasMultiCurPrice": false,
      "HazmatCode": "",
      "HazmatId": null,
      "HazmatName": "",
      "Height": null,
      "HomeCurrencyCode": null,
      "Id": 30111,
      "ImagePath": "/Images/resources/no-image.gif",
      "IncomeAccntId": "B78982BA2D499B7F9313970147E6",
      "IncomeAccountName": "Apparel",
      "IsBomItemFlag": false,
      "IsPurchasableFlag": true,
      "IsPurchasableFlagStr": null,
      "IsRawMaterialFlag": false,
      "IsRawMaterialFlagStr": null,
      "IsSelected": false,
      "IsSellableFlag": true,
      "IsSellableFlagStr": null,
      "IsStockingItemFlag": true,
      "IsTaxableOnPurchase": false,
      "IsTaxableOnPurchaseStr": null,
      "IsTaxableOnSale": false,
      "IsTaxableOnSaleStr": null,
      "IsTransferableFlag": true,
      "IsTransferableFlagStr": "Y",
      "ItemBarcode": "",
      "ItemNumber": "BC",
      "ItemProductCategoryName": null,
      "ItemTrackingTypeId": null,
      "ItemTrackingTypeName": null,
      "ItemTypeId": 10,
      "ItemTypeName": "Inventory",
      "ItemUpc": "",
      "Length": null,
      "ManufactureItemFlag": false,
      "ManufactureItemFlagStr": null,
      "Margin": "22.22%",
      "MaterialId": null,
      "MaterialName": "",
      "ModifyDttm": "10/03/2018 05:00:49 PM",
      "ModifySource": "xadmin",
      "MultipleUomFlag": false,
      "Name": null,
      "NeedsTrackingFlag": false,
      "OldItemNumber": "BC",
      "Option1Name": "",
      "Option1Seq": 0,
      "Option1Value": "",
      "Option1ValueCode": "",
      "Option1ValueId": null,
      "Option2Name": "",
      "Option2Seq": 0,
      "Option2Value": "",
      "Option2ValueCode": "",
      "Option2ValueId": null,
      "Option3Name": "",
      "Option3Seq": 0,
      "Option3Value": "",
      "Option3ValueCode": "",
      "Option3ValueId": null,
      "OptionArray": null,
      "ProductHeaderId": 4669,
      "ProductImageId": null,
      "ProductImages": null,
      "ProjectClassId": null,
      "ProjectClassName": null,
      "PurchaseNotes": "",
      "PurchaseTaxCode": "",
      "PurchaseTaxCodeId": null,
      "PurchaseTaxCodeName": "",
      "QtyDecimalFlag": false,
      "ReOrderPointQty": null,
      "ReOrderQty": null,
      "ReadonlyFlag": false,
      "RemoveImageFlag": false,
      "ReorderPointQtyList": null,
      "RestockingFeePer": null,
      "ReturnableFlag": true,
      "ReturnableFlagStr": "Y",
      "SaleTaxCode": "",
      "SaleTaxCodeName": "",
      "SalesNotes": "",
      "SalesTaxCodeId": null,
      "ScrapAccntId": "",
      "ScrapAccountName": "",
      "SeasonIdList": null,
      "SeasonValues": null,
      "SellPkgQty": 1,
      "SellUomCode": null,
      "SellUomId": 4,
      "SellUomName": "Each",
      "ShelfLife": "",
      "SizeUomCode": null,
      "SizeUomId": 6,
      "SizeUomName": "Centimetre",
      "StandardUnitCost": 7,
      "StandardUnitPrice": 9,
      "Tags": "",
      "ThirdPartyImageRefNo": null,
      "Title": "BC",
      "UseImageForProductPreviewFlag": false,
      "UseImageForProductPreviewFlagStr": null,
      "VariantInfo": "",
      "VariantInfoColored": "",
      "VelocityCodeId": null,
      "WarrantyTime": "",
      "WarrantyUOM": "",
      "WebUrl": "",
      "Weight": null,
      "WeightUomCode": null,
      "WeightUomId": 2,
      "WeightUomName": "Gram",
      "Width": null,
      "WipAccntId": "",
      "WipAccountName": ""
    }
  ],
  "IsForwardRequest": false,
  "Message": "Item data loaded successfully",
  "MessageTitle": null,
  "Result": true
}