Purchase Order Upload
Purchase order upload consist of two steps. First is to get the list of the purchase orders you wish to upload.
Step 1
OData query below retrieves tickets that are complete (filter - 'PurchaseOrder' equals 'Closed') and have not been uploaded yet (filter - 'UploadDate' equals null).
GET https://{tenant_name}.p4warehouse.com/odata/PurchaseOrder
Query Parameters
| Name | Type | Description |
|---|---|---|
$select* | String | A list of subset of properties to include in the response. |
$orderby* | String | Parameter that specifies a custom sort order for search results. |
$expand* | String | A list of related data entities to be included in the response |
$filter | String | Query filter for OData specification filter https://docs.oasis-open.org/odata/odata/v4.01/odata-v4.01-part1-protocol.html#_Toc31358948 |
Headers
| Name | Type | Description |
|---|---|---|
ApiKey* | String | System API key |
{
"@odata.context": "https://{tenant_name}.p4warehouse.com/odata/$metadata#PurchaseOrder(Id,PurchaseOrderNumber,ReferenceNumber,Client(Id,Name),Lines(Id,ReceivedQuantity,ReferenceNumber,Product(Id,Sku),LineDetails()))",
"value": [
{
"Id": "b4150a8e-672c-4275-9477-ed9703e206c7",
"PurchaseOrderNumber": "PO-0000040",
"ReferenceNumber": null,
"Client": null,
"Lines": [
{
"Id": "8d6b6883-21dd-44c6-8808-d1c35cc852db",
"ReceivedQuantity": 100.00,
"ReferenceNumber": null,
"Product": {
"Id": "dd7591f3-886e-4eb0-b2d2-591e172c7fde",
"Sku": "PRODUCT011"
},
"LineDetails": [
{
"SerialNumber": null,
"LotNumber": null,
"ExpiryDate": "2025-03-01T00:00:00Z",
"ProductPacksizeId": null,
"PacksizeEachCount": null
}
]
},
{
"Id": "b5009064-4535-4505-8aa1-04c7de4d01fb",
"ReceivedQuantity": 5.00,
"ReferenceNumber": null,
"Product": {
"Id": "e8466c29-33a7-4705-a783-711619c1cc4a",
"Sku": "PRODUCT015"
},
"LineDetails": [
{
"SerialNumber": "9995",
"LotNumber": null,
"ExpiryDate": null,
"ProductPacksizeId": null,
"PacksizeEachCount": null
},
{
"SerialNumber": "9998",
"LotNumber": null,
"ExpiryDate": null,
"ProductPacksizeId": null,
"PacksizeEachCount": null
},
{
"SerialNumber": "9997",
"LotNumber": null,
"ExpiryDate": null,
"ProductPacksizeId": null,
"PacksizeEachCount": null
},
{
"SerialNumber": "9996",
"LotNumber": null,
"ExpiryDate": null,
"ProductPacksizeId": null,
"PacksizeEachCount": null
},
{
"SerialNumber": "9999",
"LotNumber": null,
"ExpiryDate": null,
"ProductPacksizeId": null,
"PacksizeEachCount": null
}
]
},
{
"Id": "fd09cdfe-3a0c-4232-b7f6-0f7e9e33eb25",
"ReceivedQuantity": 150.00,
"ReferenceNumber": null,
"Product": {
"Id": "c2fe579c-c4c3-4a23-91fb-8e685eafe729",
"Sku": "PRODUCT016"
},
"LineDetails": [
{
"SerialNumber": null,
"LotNumber": "321",
"ExpiryDate": null,
"ProductPacksizeId": null,
"PacksizeEachCount": null
}
]
},
{
"Id": "037046e5-b562-452b-b38f-491083db04f4",
"ReceivedQuantity": 50.00,
"ReferenceNumber": null,
"Product": {
"Id": "96da0f95-5cf6-4422-91a4-ec71383ee65d",
"Sku": "PRODUCT017"
},
"LineDetails": [
{
"SerialNumber": null,
"LotNumber": null,
"ExpiryDate": null,
"ProductPacksizeId": "dd025abc-3ded-47ef-9235-52d04a9c4e40",
"PacksizeEachCount": 10
}
]
}
]
},
{
"Id": "78eedcee-59e6-4418-a8ef-3eb8c87fe038",
"PurchaseOrderNumber": "PO-0000012",
"ReferenceNumber": null,
"Client": {
"Id": "ce54af79-2587-4053-8c65-b13734f4bf39",
"Name": "01"
},
"Lines": [
{
"Id": "b36651ff-5d8c-4c9b-ba49-cfff5f10105e",
"ReceivedQuantity": 150.00,
"ReferenceNumber": null,
"Product": {
"Id": "3a7a6ba2-6e69-474f-9769-a6bfb7f5c092",
"Sku": "PRODUCT004"
},
"LineDetails": []
}
]
},
{
"Id": "7efc5a1b-f04c-4a4a-9537-b92acc6f9614",
"PurchaseOrderNumber": "PO-0000014",
"ReferenceNumber": null,
"Client": {
"Id": "91c64445-04d0-41da-a9ce-f05c0db7d4d4",
"Name": "02"
},
"Lines": [
{
"Id": "996cf18a-27ab-47fb-95d4-51f7379a9e1d",
"ReceivedQuantity": 10.00,
"ReferenceNumber": null,
"Product": {
"Id": "9c1e8c1c-24e3-46da-921f-899124d60ba7",
"Sku": "PRODUCT002"
},
"LineDetails": []
}
]
},
{
"Id": "51ebe7a2-fd82-447b-86ca-0674921fe8ab",
"PurchaseOrderNumber": "PO-0000020",
"ReferenceNumber": null,
"Client": {
"Id": "ce54af79-2587-4053-8c65-b13734f4bf39",
"Name": "01"
},
"Lines": [
{
"Id": "f71b71ee-8058-499e-a9af-e22fe6647619",
"ReceivedQuantity": 75.00,
"ReferenceNumber": null,
"Product": {
"Id": "3a7a6ba2-6e69-474f-9769-a6bfb7f5c092",
"Sku": "PRODUCT004"
},
"LineDetails": []
}
]
},
{
"Id": "465def65-e44c-47ff-9d91-c1ce11164d70",
"PurchaseOrderNumber": "PO-0000024",
"ReferenceNumber": null,
"Client": {
"Id": "91c64445-04d0-41da-a9ce-f05c0db7d4d4",
"Name": "02"
},
"Lines": [
{
"Id": "a0138243-932d-45be-8b1c-8a0c311c2aa2",
"ReceivedQuantity": 4000.00,
"ReferenceNumber": null,
"Product": {
"Id": "a3bc0471-4947-44a6-b325-1d64a2ec06d3",
"Sku": "PRODUCT014"
},
"LineDetails": [
{
"PurchaseOrderLineId": "a0138243-932d-45be-8b1c-8a0c311c2aa2",
"ReceivedQuantity": 400.00,
"LotNumber": null,
"SerialNumber": null,
"ExpiryDate": null,
"ProductPacksizeId": "db43bc73-7bb2-4f38-8df9-6eb693ca01d9",
"PacksizeEachCount": 10,
"Id": "59f649f0-a48b-43e9-9df1-14589c65ec09",
"DateCreated": "2023-05-05T17:13:31.2136599Z"
}
]
}
]
},
{
"Id": "1120b9e0-43d3-4424-8f12-98eec1797b3f",
"PurchaseOrderNumber": "PO-0000025",
"ReferenceNumber": null,
"Client": {
"Id": "91c64445-04d0-41da-a9ce-f05c0db7d4d4",
"Name": "02"
},
"Lines": [
{
"Id": "2cab928d-4755-4fb0-841d-78b1f93da57c",
"ReceivedQuantity": 400.00,
"ReferenceNumber": null,
"Product": {
"Id": "a3bc0471-4947-44a6-b325-1d64a2ec06d3",
"Sku": "PRODUCT014"
},
"LineDetails": [
{
"PurchaseOrderLineId": "2cab928d-4755-4fb0-841d-78b1f93da57c",
"ReceivedQuantity": 40.00,
"LotNumber": null,
"SerialNumber": null,
"ExpiryDate": null,
"ProductPacksizeId": "db43bc73-7bb2-4f38-8df9-6eb693ca01d9",
"PacksizeEachCount": 10,
"Id": "e4e6fd11-a068-49bf-9a3e-e65ac773dde7",
"DateCreated": "2023-05-05T17:20:21.2372339Z"
}
]
}
]
}
]
}OData Query Example
Here is a JSON example of OData query used to retrieve closed purchase orders that have not been uploaded yet.
https://{tenant_name}.p4warehouse.com/odata/PurchaseOrder?$select=Id,PurchaseOrderNumber,ReferenceNumber
&$expand=Client($select=Id,Name),
Lines($orderby=LineNumber;
$select=Id,ReceivedQuantity,ReferenceNumber;
$expand=Product($select=Id,Sku),
LineDetails($select=SerialNumber,LotNumber,ExpiryDate,ProductPacksizeId,PacksizeEachCount))
&$orderby=PurchaseOrderNumber
&$filter=IsWarehouseTransfer eq false and UploadDate eq null and PurchaseOrderState eq 'Closed'Notice: Utilize 'LineDetails' data members to customise your query. For example, filter closed purchase orders by 'SerialNumber' to find a specific purchase record.
Step 2
Update purchase order upload status depending on the result of the previous step. This action will prevent repeated uploads of the same pick tickets going forward.
If upload is successful, use 'CreateOrUpdate' endpoint, update pick ticket 'Upload' status as shown below.
POST https://doc1.p4warehouse.com/api/PurchaseOrderApi/CreateOrUpdate
Headers
| Name | Type | Description |
|---|---|---|
ApiKey* | String | System API key |
Request Body
| Name | Type | Description |
|---|---|---|
"Id"* | String | Purchase order Id generated by the system |
"UploadDate"* | String | Date of purchase order upload |
"UploadedSuceeded"* | Boolean | True |
"UploadMessage" | String | Message to be displayed |
{
"$id": "1",
"PickTicketNumber": "PCK-0000112",
"FreightTypeEnum": 2,
"FreightType": "PrivateFleet",
"DockDoorId": null,
"DockDoor": null,
"PickTicketStateEnum": 16,
"PickTicketState": "Closed",
"CustomerId": "dcdbda00-0640-4752-9413-513deea2f2a1",
"Customer": {
"$id": "2",
"CustomerCode": "WAL1",
"ClientId": null,
"Client": null,
"CompanyName": "Walmart",
"ContactPerson": "John Smith",
"Email": "j.smith@walmart.com",
"Phone": "2123542411",
"TaxId": null,
"BillToName": "702 SW 8th Street",
"BillToPhone": "8009256279",
"BillToAddress1": "702 SW 8th Street",
"BillToAddress2": null,
"BillToCity": "Bentonville",
"BillToStateProvince": "AR",
"BillToZipPostal": "72716",
"BillToCountry": "US",
"DefaultCountOnShip": null,
"DefaultSignOnShip": null,
"DefaultCountOnDelivery": null,
"DefaultSignOnDelivery": null,
"TruckLoadConsolidationGroup": null,
"Description": "DemoCustomer03",
"Logo": null,
"PackslipDisclaimer": null,
"ProformaInvoiceDisclaimer": null,
"ReturnsDisclaimer": null,
"IsGeneratePickTicketBackOrder": null,
"IsPrintPackslipOnShip": null,
"IsPrintTruckLoadOnSign": null,
"OutboundProductExpiryAllowance": null,
"InboundProductExpiryAllowance": null,
"Addresses": [],
"PickTickets": [
{
"$ref": "1"
}
],
"CustomerReturns": [],
"CartonizationProfileId": "fe1dd8b8-0899-4db3-8824-180a9c27426b",
"CartonizationProfile": null,
"Info1": null,
"Info2": null,
"Info3": null,
"Info4": null,
"Info5": null,
"Info6": null,
"Info7": null,
"Info8": null,
"Info9": null,
"Info10": null,
"Id": "dcdbda00-0640-4752-9413-513deea2f2a1",
"DateCreated": "2022-06-10T17:02:14.2266505+00:00",
"TypeName": "Pro4Soft.TenantData.Entities.Business.Fulfillment.Customer",
"TypeNameShort": "Customer"
},
"PoNumber": null,
"IsWarehouseTransfer": false,
"ToWarehouseId": null,
"ToWarehouse": null,
"WarehouseTransferPurchaseOrders": null,
"ParentBackOrderId": null,
"ParentBackOrder": null,
"BackOrders": null,
"CountOnShip": false,
"SignOnShip": false,
"DriverId": "1",
"VehicleId": "1",
"SealNumber": "1",
"ShipConfirmSignature": null,
"CountOnDelivery": false,
"SignOnDelivery": false,
"DeliveryConfirmSignature": null,
"QuotedTruckLoadShippingCost": null,
"ActualTruckLoadShippingCost": null,
"Carrier": null,
"ShippingService": null,
"SmallParcelOptionsObject": {
"$id": "3",
"IsCountOnShip": false,
"IsSignOnShip": false,
"IsCountOnDelivery": false,
"IsSignOnDelivery": false,
"Carrier": null,
"Service": null,
"CarrierScac": null,
"FreightChargeTerms": 0,
"PaymentType": 0,
"CarrierAccountNumber": null,
"InternationTaxId": null,
"IsResidential": false,
"COD": false,
"SaturdayPickup": false,
"SaturdayDelivery": false,
"SignatureRequired": false,
"PrintReturnLabel": false,
"BillToName": null,
"BillToPhone": null,
"BillToAddress1": null,
"BillToAddress2": null,
"BillToCity": null,
"BillToStateProvince": null,
"BillToZipPostalCode": null,
"BillToCountry": null
},
"SmallParcelOptions": "{\"IsCountOnShip\":false,\"IsSignOnShip\":false,\"IsCountOnDelivery\":false,\"IsSignOnDelivery\":false,\"Carrier\":null,\"Service\":null,\"CarrierScac\":null,\"FreightChargeTerms\":\"Empty\",\"PaymentType\":\"Prepay\",\"CarrierAccountNumber\":null,\"InternationTaxId\":null,\"IsResidential\":false,\"COD\":false,\"SaturdayPickup\":false,\"SaturdayDelivery\":false,\"SignatureRequired\":false,\"PrintReturnLabel\":false,\"BillToName\":null,\"BillToPhone\":null,\"BillToAddress1\":null,\"BillToAddress2\":null,\"BillToCity\":null,\"BillToStateProvince\":null,\"BillToZipPostalCode\":null,\"BillToCountry\":null}",
"ReferenceNumber": null,
"Reference1": null,
"Reference2": null,
"Reference3": null,
"ShippingRuleCode": "RL-00003",
"ShipVia": null,
"AllocationSettings": "{\"UserId\":null,\"Ids\":null,\"AllocationSourceEnum\":\"PickTicket\",\"AllocationSource\":\"PickTicket\",\"Zones\":[{\"Selected\":true,\"ZoneCode\":\"A1\",\"ProductHandling\":\"ByProduct\"},{\"Selected\":true,\"ZoneCode\":\"B1\",\"ProductHandling\":\"ByLpn\"},{\"Selected\":false,\"ZoneCode\":\"C1\",\"ProductHandling\":\"ByProduct\"},{\"Selected\":false,\"ZoneCode\":\"S1\",\"ProductHandling\":\"ByProduct\"}],\"General\":{\"AllocationStyleEnum\":\"FIFO\",\"AllocationStyleDatasource\":[\"FIFO\",\"LIFO\",\"BinName\",\"MostProductFirst\",\"LeastProductFirst\"],\"AllocationStyle\":\"FIFO\",\"ShowShortOptions\":true,\"ShortOptionsDatasource\":[\"PickShort\",\"HoldShort\"],\"ShortOptionsEnum\":\"HoldShort\",\"ShortOptions\":\"HoldShort\",\"ObeyZoneSequence\":true,\"AllocateBulk\":true,\"HoldLetdown\":true,\"RestockZone\":null},\"Expiry\":{\"ExpiryAllocationPrecedenceEnum\":\"NoPrecedence\",\"ExpiryAllocationPrecedenceDatasource\":[\"NoPrecedence\",\"OldestFirst\",\"NewestFirst\"],\"ExpiryAllocationPrecedence\":\"NoPrecedence\",\"HasExpiry\":false},\"Boms\":{\"HasBoms\":true,\"GenerateProduction\":false,\"AutoRelease\":false},\"Lots\":{\"HasLots\":false,\"LotAllocationStyleEnum\":\"Inherit\",\"LotAllocationStyleDatasource\":[\"Inherit\",\"Alphabetical\",\"MaxQtyFirst\",\"MinQtyFirst\"],\"LotAllocationStyle\":\"Inherit\",\"AllocatePartial\":true},\"Packsizes\":{\"HasPacksizes\":false,\"AllocateEaches\":true,\"PacksizeBreakdown\":true,\"BreakToInnerPacks\":false,\"PacksizeAllocationStyleEnum\":\"Inherit\",\"PacksizeAllocationStyleDatasource\":[\"Inherit\",\"BiggerPacksizeFirst\",\"SmallerPacksizeFirst\"],\"PacksizeAllocationStyle\":\"Inherit\"}}",
"GeoTimeStamp": null,
"CurrentLongitude": null,
"CurrentLatitude": null,
"ShipToGeoCodedAddress": "1675 S Christopher Columbus Blvd,\nPhiladelphia,\nPA 19148,\nUSA",
"ShipToLatitude": 39.9263713,
"ShipToLongitude": -75.141586199999992,
"ShipToEmail": "j.smith@walmart.com",
"ShipToAttnTo": null,
"ShipToName": "1675 S Christopher Columbus Blvd",
"ShipToPhone": "2154684224",
"ShipToAddress1": "1675 S Christopher Columbus Blvd",
"ShipToAddress2": null,
"ShipToCity": "Philadelphia",
"ShipToStateProvince": "PA",
"ShipToZipPostal": "19148",
"ShipToCountry": "US",
"ShipToHash": "1675 S Christopher Columbus BlvdPhiladelphiaPA19148US",
"BillToName": "702 SW 8th Street",
"BillToPhone": "8009256279",
"BillToAddress1": "702 SW 8th Street",
"BillToAddress2": null,
"BillToCity": "Bentonville",
"BillToStateProvince": "AR",
"BillToZipPostal": "72716",
"BillToCountry": "US",
"ShipFromGeoCodedAddress": "Burr Ridge,\nIL,\nUSA",
"ShipFromLatitude": 41.748920299999988,
"ShipFromLongitude": -87.918391899999989,
"AppointmentNumber": null,
"AppointmentDate": null,
"RouteNumber": null,
"Container": null,
"ShipFromName": "Demo P4B",
"ShipFromPhone": "708-519-0932",
"ShipFromAddress1": "3607 Hog Camp Road",
"ShipFromAddress2": "2",
"ShipFromCity": "Burr Ridge",
"ShipFromStateProvince": "IL",
"ShipFromZipPostal": "61257",
"ShipFromCountry": "US",
"WaveNumber": "WV0000109",
"Comments": null,
"PickingInstructions": null,
"SystemMessage": null,
"IsHeldShort": null,
"IsPendingLetdown": false,
"IsPendingProduction": null,
"IsPendingPacksizeBreakdown": false,
"FirstPickBinId": null,
"FirstPickBin": null,
"CancelDate": null,
"RequiredDate": null,
"MustArriveDate": null,
"ReleasedToFloorDate": "2023-03-28T10:00:18.5785163-04:00",
"AllocatedDate": "2023-03-28T10:00:24.9836673-04:00",
"CartonizeDate": null,
"WavedDate": "2023-03-28T10:01:27.5712585-04:00",
"PickingStartedDate": "2023-03-28T10:02:44.1057465-04:00",
"PickingCompletedDate": "2023-03-28T10:04:04.0781174-04:00",
"ShipConfirmDate": null,
"ShippedDate": "2023-03-28T10:05:25.2062269-04:00",
"DeliveryConfirmDate": null,
"CloseDate": "2023-03-28T10:05:39.3813728-04:00",
"SuspendedDate": null,
"UploadDate": "2023-05-28T10:01:27.5712585-04:00",
"UploadedSuceeded": true,
"UploadMessage": null,
"WarehouseId": "1ab1f713-a451-4019-9e3c-25624374508c",
"Warehouse": null,
"ClientId": null,
"Client": null,
"Lines": [
{
"$id": "4",
"LineNumber": 2,
"PickTicketId": "1f779add-e7f5-4709-abfa-7bad00c6e4ae",
"PickTicket": {
"$ref": "1"
},
"ProductId": "26abbbbd-ef13-418e-a96d-815c3c237303",
"Product": null,
"ProductBundleId": null,
"ProductBundle": null,
"Packsize": null,
"NumberOfPacks": null,
"LotNumber": null,
"Instructions": null,
"ReferenceNumber": null,
"Reference1": null,
"Reference2": null,
"Reference3": null,
"OrderedQuantity": 30.00,
"AllocatedQuantity": null,
"PendingProduction": null,
"PickedQuantity": 30.00,
"ShippedQuantity": null,
"DeliveredQuantity": null,
"SalesPrice": null,
"ToteLines": [
{
"$id": "5",
"ToteMasterId": "77344a8d-273f-4206-a99a-ce893c25acd5",
"ToteMaster": {
"$id": "6",
"Sscc18Code": "00000000000000000857",
"PickTicketId": "1f779add-e7f5-4709-abfa-7bad00c6e4ae",
"PickTicket": {
"$ref": "1"
},
"TruckLoadId": null,
"TruckLoad": null,
"CartonSizeId": "9ac81fef-6714-4416-99dd-955cc50a4007",
"CartonSize": null,
"CartonizationResultId": null,
"CartonizationResult": null,
"DockDoorId": null,
"DockDoor": null,
"BigText": "A",
"Sku": null,
"Upc": null,
"CartonNumber": 1,
"BinId": null,
"Bin": null,
"LicensePlateId": null,
"LicensePlate": null,
"SmallParcelOptionsObject": {
"$id": "7",
"IsCountOnShip": false,
"IsSignOnShip": false,
"IsCountOnDelivery": false,
"IsSignOnDelivery": false,
"Carrier": null,
"Service": null,
"CarrierScac": null,
"FreightChargeTerms": 0,
"PaymentType": 0,
"CarrierAccountNumber": null,
"InternationTaxId": null,
"IsResidential": false,
"COD": false,
"SaturdayPickup": false,
"SaturdayDelivery": false,
"SignatureRequired": false,
"PrintReturnLabel": false,
"BillToName": null,
"BillToPhone": null,
"BillToAddress1": null,
"BillToAddress2": null,
"BillToCity": null,
"BillToStateProvince": null,
"BillToZipPostalCode": null,
"BillToCountry": null
},
"SmallParcelOptions": "{\"IsCountOnShip\":false,\"IsSignOnShip\":false,\"IsCountOnDelivery\":false,\"IsSignOnDelivery\":false,\"Carrier\":null,\"Service\":null,\"CarrierScac\":null,\"FreightChargeTerms\":\"Empty\",\"PaymentType\":\"Prepay\",\"CarrierAccountNumber\":null,\"InternationTaxId\":null,\"IsResidential\":false,\"COD\":false,\"SaturdayPickup\":false,\"SaturdayDelivery\":false,\"SignatureRequired\":false,\"PrintReturnLabel\":false,\"BillToName\":null,\"BillToPhone\":null,\"BillToAddress1\":null,\"BillToAddress2\":null,\"BillToCity\":null,\"BillToStateProvince\":null,\"BillToZipPostalCode\":null,\"BillToCountry\":null}",
"Carrier": null,
"ShippingService": null,
"ShipmentId": null,
"TrackTraceNumber": null,
"ShippingLabelZpl": null,
"ShippingCost": null,
"ShippingCostCurrency": null,
"CarrierPickupManifest": null,
"CarrierPickupDateTime": null,
"Length": 25.00,
"Width": 15.00,
"Height": 20.00,
"Cube": 7500.00,
"LengthUnitOfMeasureEnum": 9,
"LengthUnitOfMeasure": "Cm",
"Weight": null,
"WeightUnitOfMeasureEnum": 1,
"WeightUnitOfMeasure": "Kg",
"ToteTypeEnum": 0,
"ToteType": "Carton",
"ShippingCostIncurredEnum": 0,
"ShippingCostIncurred": "Tenant",
"Lines": [
{
"$ref": "5"
},
{
"$id": "8",
"ToteMasterId": "77344a8d-273f-4206-a99a-ce893c25acd5",
"ToteMaster": {
"$ref": "6"
},
"ProductId": "eca6e721-9a16-4b61-b739-06a0f099f3d3",
"Product": null,
"PickedQuantity": 20.00,
"ShippedQuantity": 20.00,
"DeliveredQuantity": 20.00,
"LineDetails": [],
"PickTicketLineId": "39ff10f1-9d1d-4322-b47e-1b8d51787e50",
"PickTicketLine": {
"$id": "9",
"LineNumber": 1,
"PickTicketId": "1f779add-e7f5-4709-abfa-7bad00c6e4ae",
"PickTicket": {
"$ref": "1"
},
"ProductId": "eca6e721-9a16-4b61-b739-06a0f099f3d3",
"Product": null,
"ProductBundleId": null,
"ProductBundle": null,
"Packsize": null,
"NumberOfPacks": null,
"LotNumber": null,
"Instructions": null,
"ReferenceNumber": null,
"Reference1": null,
"Reference2": null,
"Reference3": null,
"OrderedQuantity": 20.00,
"AllocatedQuantity": null,
"PendingProduction": null,
"PickedQuantity": 20.00,
"ShippedQuantity": null,
"DeliveredQuantity": null,
"SalesPrice": null,
"ToteLines": [
{
"$ref": "8"
}
],
"InventoryReservations": [],
"InventoryPickShorts": [],
"ProductionOrders": [],
"Info1": null,
"Info2": null,
"Info3": null,
"Info4": null,
"Info5": null,
"Info6": null,
"Info7": null,
"Info8": null,
"Info9": null,
"Info10": null,
"Id": "39ff10f1-9d1d-4322-b47e-1b8d51787e50",
"DateCreated": "2023-03-28T13:59:59.2813007+00:00",
"TypeName": "Pro4Soft.TenantData.Entities.Business.Fulfillment.PickTicketLine",
"TypeNameShort": "PickTicketLine"
},
"Id": "b9d74d7e-8bd9-4e5d-8b67-625d55639eac",
"DateCreated": "2023-03-28T14:02:44.013682+00:00",
"TypeName": "Pro4Soft.TenantData.Entities.Business.Fulfillment.ToteLine",
"TypeNameShort": "ToteLine"
},
{
"$id": "10",
"ToteMasterId": "77344a8d-273f-4206-a99a-ce893c25acd5",
"ToteMaster": {
"$ref": "6"
},
"ProductId": "3e3c425e-bd87-4cc4-bb58-ee13f95255bb",
"Product": null,
"PickedQuantity": 10.00,
"ShippedQuantity": 10.00,
"DeliveredQuantity": 10.00,
"LineDetails": [],
"PickTicketLineId": "2db53e98-60c7-4733-aba9-c19aca8cba2c",
"PickTicketLine": {
"$id": "11",
"LineNumber": 3,
"PickTicketId": "1f779add-e7f5-4709-abfa-7bad00c6e4ae",
"PickTicket": {
"$ref": "1"
},
"ProductId": "3e3c425e-bd87-4cc4-bb58-ee13f95255bb",
"Product": null,
"ProductBundleId": null,
"ProductBundle": null,
"Packsize": null,
"NumberOfPacks": null,
"LotNumber": null,
"Instructions": null,
"ReferenceNumber": null,
"Reference1": null,
"Reference2": null,
"Reference3": null,
"OrderedQuantity": 10.00,
"AllocatedQuantity": null,
"PendingProduction": null,
"PickedQuantity": 10.00,
"ShippedQuantity": null,
"DeliveredQuantity": null,
"SalesPrice": null,
"ToteLines": [
{
"$ref": "10"
}
],
"InventoryReservations": [],
"InventoryPickShorts": [],
"ProductionOrders": [],
"Info1": null,
"Info2": null,
"Info3": null,
"Info4": null,
"Info5": null,
"Info6": null,
"Info7": null,
"Info8": null,
"Info9": null,
"Info10": null,
"Id": "2db53e98-60c7-4733-aba9-c19aca8cba2c",
"DateCreated": "2023-03-28T14:00:11.3770622+00:00",
"TypeName": "Pro4Soft.TenantData.Entities.Business.Fulfillment.PickTicketLine",
"TypeNameShort": "PickTicketLine"
},
"Id": "31348e00-c069-4085-9e59-fc30431356cc",
"DateCreated": "2023-03-28T14:04:04.0421454+00:00",
"TypeName": "Pro4Soft.TenantData.Entities.Business.Fulfillment.ToteLine",
"TypeNameShort": "ToteLine"
}
],
"Id": "77344a8d-273f-4206-a99a-ce893c25acd5",
"DateCreated": "2023-03-28T14:01:27.5712585+00:00",
"TypeName": "Pro4Soft.TenantData.Entities.Business.Fulfillment.ToteMaster",
"TypeNameShort": "ToteMaster"
},
"ProductId": "26abbbbd-ef13-418e-a96d-815c3c237303",
"Product": null,
"PickedQuantity": 30.00,
"ShippedQuantity": 30.00,
"DeliveredQuantity": 30.00,
"LineDetails": [],
"PickTicketLineId": "d1fa4817-cb0a-42cb-a832-0f465baef8b5",
"PickTicketLine": {
"$ref": "4"
},
"Id": "6d736574-531a-459f-b8ba-a6c576cd6118",
"DateCreated": "2023-03-28T14:03:14.3265815+00:00",
"TypeName": "Pro4Soft.TenantData.Entities.Business.Fulfillment.ToteLine",
"TypeNameShort": "ToteLine"
}
],
"InventoryReservations": [],
"InventoryPickShorts": [],
"ProductionOrders": [],
"Info1": null,
"Info2": null,
"Info3": null,
"Info4": null,
"Info5": null,
"Info6": null,
"Info7": null,
"Info8": null,
"Info9": null,
"Info10": null,
"Id": "d1fa4817-cb0a-42cb-a832-0f465baef8b5",
"DateCreated": "2023-03-28T14:00:04.3102222+00:00",
"TypeName": "Pro4Soft.TenantData.Entities.Business.Fulfillment.PickTicketLine",
"TypeNameShort": "PickTicketLine"
},
{
"$ref": "9"
},
{
"$ref": "11"
}
],
"Totes": [
{
"$ref": "6"
}
],
"CartonizationDetails": [],
"AssignedUserId": null,
"AssignedUser": null,
"Tag1": null,
"Tag2": null,
"Tag3": null,
"Tag4": null,
"Tag5": null,
"Info1": null,
"Info2": null,
"Info3": null,
"Info4": null,
"Info5": null,
"Info6": null,
"Info7": null,
"Info8": null,
"Info9": null,
"Info10": null,
"Id": "1f779add-e7f5-4709-abfa-7bad00c6e4ae",
"DateCreated": "2023-03-28T13:59:44.3502204+00:00",
"TypeName": "Pro4Soft.TenantData.Entities.Business.Fulfillment.PickTicket",
"TypeNameShort": "PickTicket"
}Specified cast is not valid.Successful Upload JSON Example
api/PurchaseOrderApi/CreateOrUpdate
{
Id = (string),
UploadDate = DateTime,
UploadedSuceeded = true,
UploadMessage = (string) null,
}If the upload was unsuccessful, set 'UploadedSuceeded' Boolean as 'False'.
POST https://doc1.p4warehouse.com/api/PurchaseOrderApi/CreateOrUpdate
Headers
| Name | Type | Description |
|---|---|---|
ApiKey | String | System API key |
Request Body
| Name | Type | Description |
|---|---|---|
"Id" | String | Purchase order Id generated by the system |
"UploadDate" | String | Date of purchase order upload |
"UploadedSuceeded" | Boolean | False |
"UploadMessage" | String | Error message to be displayed |
Specified cast is not valid.Unsuccessful Upload JSON Example
api/PurchaseOrderApi/CreateOrUpdate
{
Id = string,
UploadDate = DateTime,
UploadedSuceeded = false,
UploadMessage = (string) null,
}