P4 Collection
P4 Warehouse English
P4 Warehouse English
  • P4 Warehouse Change Log
  • Getting Started Quick Setup
    • Overview
    • FAQ
    • Supply Chain Glossary
    • Create a Warehouse
      • Edit Warehouse
      • Add Zone & Bins
    • Create Users
    • Create a Product
    • Create Provider
    • Create Customer
    • Setup Printers
  • Web Documentation
  • Setup
    • Active Mobile Devices
    • Tenant Configuration
    • System - Configuration
      • Cycle Count
      • Products
      • Communication
      • Calendar View
      • License Plates - LPN
      • Three PL -3PL
      • Reason Codes
      • Fulfillment
        • Releasing
        • Data Entry
        • Shipping Setup
          • Truck Load
            • Email
          • Master Truck Load
            • Operations
            • Email
          • Packslip Configuration
          • Small Parcel Setup
          • Private Fleet Setup
            • Email Notification
          • Small Parcel
            • Email Notification
        • Closing
          • Email Notification
          • Backorders
        • Automation
        • Allocation
        • Waving
        • Document Printing
      • Receiving
        • Document Printing
        • Email Notification
        • Automation
        • Handhelds
        • Operations
        • Data Entry
      • Calendar
      • Reason Codes
    • Products
      • Product Audit
      • Decimal controlled
      • BOM- Bill of Materials
      • Serial Control
      • Lot Control
      • Expiry Product
      • Packsize
      • Product Bundles
    • System Logs
    • System– Audit
    • Query Builder
    • Custom Actions
    • Warehouse
      • Warehouses
      • Zones
      • Bins
      • Dock Doors
    • Translations
    • Reports & KPI
      • Database backups
      • Report Creation
      • KPI Creation
  • Permissions- Users
    • Permission Profiles
    • Add Users
    • User Sessions
  • Printing & Labels
    • Printers
      • Print Queue
      • Print Agent
      • Printer Setup
    • Labels
      • Templates
      • Label Design
  • Fulfillment
    • Fulfillment Operational Setup
      • Customer
      • Cartonization Profiles
      • Carton Sizes
      • Carriers
    • Pick Ticket Creation
      • Back Order
    • Allocation
    • Waving
    • Totes
    • Grouping
    • Truck Load
    • Master Truck Load
    • Totes
    • Shipping
    • Delivery
    • Staging
  • Purchasing
    • Vendors
    • Receiving Calendar
    • Open Purchase Orders
    • Closed Purchase Orders
    • LPN Receiving
  • Production
    • Production Workflow
    • Open Work Orders
    • Closed Work Orders
  • Returns - RMA
    • Open Returns
    • Closed Returns
  • 3rd Party Logistics
    • 3PL Billing Profiles
    • 3PL Clients
    • 3PL Client Invoicing
  • Collaboration
    • Task
    • Cycle Count Approval
  • Analytics - Reporting
    • Reports
      • Create Reports
    • KPI
      • Create KPI
  • Mobile Device Documentation
    • Information for Android Mobile
  • Receiving
    • General Receiving Information
    • PO List
    • PO Receiving
    • PO Photo
    • Product Barcode
    • Un-Receive PO
    • Non-PO Receiving
  • Fulfillment
    • Picking
      • Pick List
      • Pick Ticket Picking
      • Wave Picking
      • Full Pack Picking
      • Carton Picking
    • Staging
      • Tote Merge
      • Tote Counting
      • Print Content Label
      • Un-Picking
      • Tote Move
      • Re-Packing
    • Shipping Pick Tickets
      • Tote / Pallet to Stage
      • Tote to Dock
      • Ship
      • Photo
      • Deliver
      • Pallet / Carton Dimensions
    • Shipping Truck Loads
      • Tote to Dock
      • Ship
      • Photo
  • RMA
    • Returns Process
      • RMA List
      • RMA Receiving
      • Photo
      • Non RMA Receiving
      • Un-Receive RMA
  • Production
    • Production Process
      • Work Order List
      • Picking
      • Production
  • Adjustments
    • Adjustments Process
      • Vendor Return
      • Adjust in
      • Adjust in by Bin
      • Adjust out
      • Adjust out by bin
  • Miscellaneous
    • Pallet Dimensions
    • Inventory
      • Packsize Convert
      • Product Move
      • Full Bin Move
      • Bin Contents
      • Packsize Breakdown
      • Substitute Convert
    • Bulk - LPN
      • LPN Letdown by Bin
      • LPN Letdown by Sku
      • Product Letdown by Bin
      • Product Letdown by Sku
      • LPN Move
    • Cycle Count
      • Cycle Count by Bin
      • Cycle Count by Product
      • Cycle Count by Assignment
    • Product Data
      • Product Dimensions
      • Product Photo
      • Product Location
  • Collaboration
    • Task Assignments
    • Messaging - Chat
  • Contact Us
    • Support
      • Costa Rica
      • USA
      • Peru
      • Panamá
      • Mexico
      • Ecuador
  • REST API
    • P4Warehouse REST API
    • Product Master
      • Create new product
      • Update or edit existing products
      • Retrieve a list of products
      • Delete Product
    • Vendor Master
      • Create new vendor
      • Update or edit existing vendors
      • Retrieve a list of vendors
Powered by GitBook
On this page
  • OData
  • Example of OData query
  1. REST API
  2. Product Master

Retrieve a list of products

OData

P4W utilizes OData when querying database through API calls. Following example retrieves first 20 products, including assigned clients if applicable.

GET https://{tenant_name}.p4warehouse.com/odata/Product

Retrieves a list of first 20 products and product assigned clients when possible.

Query Parameters

Name
Type
Description

$expand*

String

Client base

$orderby*

String

SKU

$top*

Integer

Number of products to retrieve

$count*

Boolean

Whether to displays total number of products available

Headers

Name
Type
Description

ApiKey*

String

System API key

{
    "@odata.context": "https://doc1.p4warehouse.com/odata/$metadata#Product(Client(Id,Name))",
    "@odata.count": 21,
    "value": [
        {
            "Sku": "1234",
            "Upc": null,
            "BarcodeValue": null,
            "BarcodeType": null,
            "Category": null,
            "Description": null,
            "SubstituteGroup": null,
            "HtsCode": null,
            "CountryOfOrigin": null,
            "ReferenceNumber": null,
            "Reference1": null,
            "Reference2": null,
            "Reference3": null,
            "ClientId": null,
            "BomWorkflowId": null,
            "Height": null,
            "Width": null,
            "Length": null,
            "DimsLengthUnitOfMeasure": "M",
            "Weight": null,
            "FreightClass": null,
            "IsHazMat": false,
            "Nmfc": null,
            "CommodityDescription": null,
            "DimsWeightUnitOfMeasure": "Kg",
            "Cube": null,
            "IsBillOfMaterial": false,
            "IsLotControlled": false,
            "LotPattern": null,
            "IsSerialControlled": false,
            "SerialPattern": null,
            "IsExpiryControlled": false,
            "IsDecimalControlled": false,
            "IsPacksizeControlled": false,
            "IsDiscontinued": false,
            "UnitOfMeasure": null,
            "CartonizationBehaviour": "Inherit",
            "Info1": null,
            "Info2": null,
            "Info3": null,
            "Info4": null,
            "Info5": null,
            "Info6": null,
            "Info7": null,
            "Info8": null,
            "Info9": null,
            "Info10": null,
            "Id": "935bfda9-e615-4966-8606-ac037dfcc3fb",
            "DateCreated": "2023-08-15T18:36:06.3294549Z",
            "Client": null
        },
        {
            "Sku": "PRODUCT_A",
            "Upc": "1153453189306",
            "BarcodeValue": "1153453189306",
            "BarcodeType": "Code128",
            "Category": null,
            ...

Example of OData query

https://{tenant_name}.p4warehouse.com/odata/Product
$expand=Client($select=Id,Name)&$orderby=Sku&$top=20&$count=true

Last updated 1 year ago

Use OData syntax () to personalize queries through API calls.

https://www.odata.org/documentation/