POST v1/companies/{companyId}/DetailedProductData/UpdatedAsOf/{updatedAsOfUTC}
This call is intended for incremental updates.
Information:
Additional Documentation
See Cova Data Platform API guide
Base URL:
https://api.covasoft.net/dataplatform
Example of a call would be:
POST /dataplatform/v1/Companies/{companyId}/DetailedProductData/UpdatedAsOf/{updatedAsOfUtc}
Host: api.covasoft.net
Authorization: Bearer {your token}
Accept: application/json
Content-Type: application/json
{
"LocationId": 12346,
"IncludeProductSkusAndUpcs": true,
"IncludeProductSpecifications": true,
"IncludeClassifications": false,
"IncludeProductAssets": true,
"IncludeAvailability": true,
"IncludePackageDetails": true,
"IncludePricing": true,
"IncludeTaxes": true,
"InStockOnly": false,
"IncludeAllLifecycles": false,
"SellingRoomOnly": true,
"Skip": 0,
"Top": 100
}
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| companyId | integer |
Required |
|
| updatedAsOfUTC | date |
Required |
Body Parameters
Properties to define which items in the model to return.
DetailedProductDataRequestResource| Name | Description | Type | Additional information |
|---|---|---|---|
| LocationId |
If provided only data for the provided location will be returned. If null is provided information for all locations will be returned. |
integer |
None. |
| IncludeProductSkusAndUpcs |
Indicates whether to include product SKUs and UPCs. |
boolean |
None. |
| IncludeProductSpecifications |
Indicates whether to include product specifications. |
boolean |
None. |
| IncludeClassifications |
Indicates whether to include the classification collection |
boolean |
None. |
| IncludeProductAssets |
Indicates whether to include product assets. |
boolean |
None. |
| IncludeAvailability |
Indicates whether to include availability data. |
boolean |
None. |
| IncludePackageDetails |
Indicates whether to include package details for any packages associated with the product. |
boolean |
None. |
| InStockOnly |
Indicates whether to only include products/packages that have stock. Only applies if IncludeAvailability is true. |
boolean |
None. |
| SellingRoomOnly |
Indicates whether to include product availability data for all rooms or only the default selling room. Only applies if IncludeAvailability is true. |
boolean |
None. |
| IncludePricing |
Indicates whether to include product pricing data. |
boolean |
None. |
| IncludeTaxes |
Indicates whether to include applicable product tax rate data. |
boolean |
None. |
| IncludeAllLifecycles |
Indicates whether to include all lifecycles, or only Active products |
boolean |
None. |
| Skip |
Number of records to skip. |
integer |
None. |
| Top |
Number of records to take. |
integer |
Range: inclusive between 1 and 500 |
Request Formats
application/json, text/json
Sample:
{
"LocationId": 1,
"IncludeProductSkusAndUpcs": true,
"IncludeProductSpecifications": true,
"IncludeClassifications": true,
"IncludeProductAssets": true,
"IncludeAvailability": true,
"IncludePackageDetails": true,
"InStockOnly": true,
"SellingRoomOnly": true,
"IncludePricing": true,
"IncludeTaxes": true,
"IncludeAllLifecycles": true,
"Skip": 12,
"Top": 13
}
Response Information
Resource Description
DetailedProductDataResource| Name | Description | Type | Additional information |
|---|---|---|---|
| Products | Collection of DetailedProductResource |
None. |
|
| Packages | Collection of PackageResource |
None. |
|
| TaxRates | Collection of TaxRateResource |
None. |
|
| Classifications | Collection of ClassificationResource |
None. |
Response Formats
application/json, text/json
Sample:
{
"Products": [
{
"ProductId": "c62815c7-c64f-4a97-9e21-7a96cfad20ed",
"MasterProductId": 2,
"MasterProductName": 3,
"VariationId": 1,
"Slug": "sample string 4",
"CatalogSku": "sample string 5",
"IsArchived": true,
"MeasurementType": "sample string 7",
"IsBatchTracked": true,
"IsNonStock": true,
"LifeCycle": "sample string 10",
"ClassificationId": 11,
"ClassificationName": "sample string 12",
"ClassificationPath": "sample string 13",
"Name": "sample string 14",
"ShortDescription": "sample string 15",
"LongDescription": "sample string 16",
"HeroShotAssetId": "3a58f7a7-6da9-49ff-8871-7cc50f1f4c20",
"HeroShotUri": "sample string 17",
"SupplierSkus": [
{
"SKU": "sample string 1",
"SupplierId": 1,
"Supplier": "sample string 2",
"Description": "sample string 3"
},
{
"SKU": "sample string 1",
"SupplierId": 1,
"Supplier": "sample string 2",
"Description": "sample string 3"
}
],
"ManufacturerSkus": [
{
"SKU": "sample string 1",
"Description": "sample string 2"
},
{
"SKU": "sample string 1",
"Description": "sample string 2"
}
],
"Upcs": [
{
"UPC": "sample string 1",
"Description": "sample string 2"
},
{
"UPC": "sample string 1",
"Description": "sample string 2"
}
],
"ProductSpecifications": [
{
"FieldGroupId": "bdbd0554-7898-4dac-b6fd-f4e23566ead0",
"FieldGroup": "sample string 2",
"FieldId": 3,
"FieldName": "sample string 4",
"StringId": "sample string 5",
"DisplayName": "sample string 6",
"Value": "sample string 7",
"Type": "sample string 8",
"Unit": "sample string 9"
},
{
"FieldGroupId": "bdbd0554-7898-4dac-b6fd-f4e23566ead0",
"FieldGroup": "sample string 2",
"FieldId": 3,
"FieldName": "sample string 4",
"StringId": "sample string 5",
"DisplayName": "sample string 6",
"Value": "sample string 7",
"Type": "sample string 8",
"Unit": "sample string 9"
}
],
"Assets": [
{
"Id": "5055e55f-19e4-4120-85f7-c7028acf749b",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
},
{
"Id": "5055e55f-19e4-4120-85f7-c7028acf749b",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
}
],
"Availability": [
{
"LocationId": 1,
"RoomId": 2,
"PackageId": "sample string 3",
"BatchId": "sample string 4",
"UnitId": 5,
"InStockQuantity": 6.0,
"OnOrderQuantity": 7.0,
"TransferInQuantity": 8.0,
"TransferOutQuantity": 9.0,
"TotalCostInStock": 10.0,
"UnitCost": 11.0,
"ReceivedDate": "2025-01-18T05:00:23.1971289+00:00",
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
},
{
"LocationId": 1,
"RoomId": 2,
"PackageId": "sample string 3",
"BatchId": "sample string 4",
"UnitId": 5,
"InStockQuantity": 6.0,
"OnOrderQuantity": 7.0,
"TransferInQuantity": 8.0,
"TransferOutQuantity": 9.0,
"TotalCostInStock": 10.0,
"UnitCost": 11.0,
"ReceivedDate": "2025-01-18T05:00:23.1971289+00:00",
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
}
],
"Prices": [
{
"LocationId": 1,
"ProductId": "410e9e21-dca3-40b1-b049-b74d32dc6020",
"TierId": 1,
"TierName": "sample string 3",
"TierQuantity": 1.0,
"GroupId": 1,
"GroupName": "sample string 4",
"ShelfId": 1,
"ShelfName": "sample string 5",
"Price": 6.0,
"AtTierPrice": 1.0,
"SalePrices": [
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"StopDateUtc": "2025-01-18T05:00:23.1971289+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"StopDateUtc": "2025-01-18T05:00:23.1971289+00:00"
}
],
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
},
{
"LocationId": 1,
"ProductId": "410e9e21-dca3-40b1-b049-b74d32dc6020",
"TierId": 1,
"TierName": "sample string 3",
"TierQuantity": 1.0,
"GroupId": 1,
"GroupName": "sample string 4",
"ShelfId": 1,
"ShelfName": "sample string 5",
"Price": 6.0,
"AtTierPrice": 1.0,
"SalePrices": [
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"StopDateUtc": "2025-01-18T05:00:23.1971289+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"StopDateUtc": "2025-01-18T05:00:23.1971289+00:00"
}
],
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
}
],
"CreatedDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"ApplicableTaxRates": [
"3daf525b-650e-4c53-a381-854147c7bd7b",
"ea6cbb82-22ef-4053-8f79-d0f0e2d6202a"
],
"ClassificationTreeId": 20,
"Manufacturer": "sample string 21",
"MSRP": 1.0,
"MSRPCurrencyCode": "sample string 22"
},
{
"ProductId": "c62815c7-c64f-4a97-9e21-7a96cfad20ed",
"MasterProductId": 2,
"MasterProductName": 3,
"VariationId": 1,
"Slug": "sample string 4",
"CatalogSku": "sample string 5",
"IsArchived": true,
"MeasurementType": "sample string 7",
"IsBatchTracked": true,
"IsNonStock": true,
"LifeCycle": "sample string 10",
"ClassificationId": 11,
"ClassificationName": "sample string 12",
"ClassificationPath": "sample string 13",
"Name": "sample string 14",
"ShortDescription": "sample string 15",
"LongDescription": "sample string 16",
"HeroShotAssetId": "3a58f7a7-6da9-49ff-8871-7cc50f1f4c20",
"HeroShotUri": "sample string 17",
"SupplierSkus": [
{
"SKU": "sample string 1",
"SupplierId": 1,
"Supplier": "sample string 2",
"Description": "sample string 3"
},
{
"SKU": "sample string 1",
"SupplierId": 1,
"Supplier": "sample string 2",
"Description": "sample string 3"
}
],
"ManufacturerSkus": [
{
"SKU": "sample string 1",
"Description": "sample string 2"
},
{
"SKU": "sample string 1",
"Description": "sample string 2"
}
],
"Upcs": [
{
"UPC": "sample string 1",
"Description": "sample string 2"
},
{
"UPC": "sample string 1",
"Description": "sample string 2"
}
],
"ProductSpecifications": [
{
"FieldGroupId": "bdbd0554-7898-4dac-b6fd-f4e23566ead0",
"FieldGroup": "sample string 2",
"FieldId": 3,
"FieldName": "sample string 4",
"StringId": "sample string 5",
"DisplayName": "sample string 6",
"Value": "sample string 7",
"Type": "sample string 8",
"Unit": "sample string 9"
},
{
"FieldGroupId": "bdbd0554-7898-4dac-b6fd-f4e23566ead0",
"FieldGroup": "sample string 2",
"FieldId": 3,
"FieldName": "sample string 4",
"StringId": "sample string 5",
"DisplayName": "sample string 6",
"Value": "sample string 7",
"Type": "sample string 8",
"Unit": "sample string 9"
}
],
"Assets": [
{
"Id": "5055e55f-19e4-4120-85f7-c7028acf749b",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
},
{
"Id": "5055e55f-19e4-4120-85f7-c7028acf749b",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
}
],
"Availability": [
{
"LocationId": 1,
"RoomId": 2,
"PackageId": "sample string 3",
"BatchId": "sample string 4",
"UnitId": 5,
"InStockQuantity": 6.0,
"OnOrderQuantity": 7.0,
"TransferInQuantity": 8.0,
"TransferOutQuantity": 9.0,
"TotalCostInStock": 10.0,
"UnitCost": 11.0,
"ReceivedDate": "2025-01-18T05:00:23.1971289+00:00",
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
},
{
"LocationId": 1,
"RoomId": 2,
"PackageId": "sample string 3",
"BatchId": "sample string 4",
"UnitId": 5,
"InStockQuantity": 6.0,
"OnOrderQuantity": 7.0,
"TransferInQuantity": 8.0,
"TransferOutQuantity": 9.0,
"TotalCostInStock": 10.0,
"UnitCost": 11.0,
"ReceivedDate": "2025-01-18T05:00:23.1971289+00:00",
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
}
],
"Prices": [
{
"LocationId": 1,
"ProductId": "410e9e21-dca3-40b1-b049-b74d32dc6020",
"TierId": 1,
"TierName": "sample string 3",
"TierQuantity": 1.0,
"GroupId": 1,
"GroupName": "sample string 4",
"ShelfId": 1,
"ShelfName": "sample string 5",
"Price": 6.0,
"AtTierPrice": 1.0,
"SalePrices": [
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"StopDateUtc": "2025-01-18T05:00:23.1971289+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"StopDateUtc": "2025-01-18T05:00:23.1971289+00:00"
}
],
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
},
{
"LocationId": 1,
"ProductId": "410e9e21-dca3-40b1-b049-b74d32dc6020",
"TierId": 1,
"TierName": "sample string 3",
"TierQuantity": 1.0,
"GroupId": 1,
"GroupName": "sample string 4",
"ShelfId": 1,
"ShelfName": "sample string 5",
"Price": 6.0,
"AtTierPrice": 1.0,
"SalePrices": [
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"StopDateUtc": "2025-01-18T05:00:23.1971289+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"StopDateUtc": "2025-01-18T05:00:23.1971289+00:00"
}
],
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
}
],
"CreatedDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"ApplicableTaxRates": [
"3daf525b-650e-4c53-a381-854147c7bd7b",
"ea6cbb82-22ef-4053-8f79-d0f0e2d6202a"
],
"ClassificationTreeId": 20,
"Manufacturer": "sample string 21",
"MSRP": 1.0,
"MSRPCurrencyCode": "sample string 22"
}
],
"Packages": [
{
"PackageId": "sample string 1",
"BatchId": "sample string 2",
"ExpiryDate": "2025-01-18T05:00:23.1971289+00:00",
"Strain": "sample string 3",
"SupplierLicense": "sample string 4",
"TestDate": "2025-01-18T05:00:23.1971289+00:00",
"HarvestDate": "2025-01-18T05:00:23.1971289+00:00",
"TestingFacilityName": "sample string 5",
"TestBatchNumber": "sample string 6",
"SupplierName": "sample string 7",
"SupplierId": 1,
"TerpeneProfile": "sample string 8",
"ReceivingId": "13934e57-9513-44b2-a233-cbe5eb9e4b49",
"ReceivingDate": "2025-01-18T05:00:23.1971289+00:00",
"Cannabinoids": [
{
"CannabinoidType": "sample string 1",
"MeasurementType": "sample string 2",
"MinValue": 3.0,
"MaxValue": 4.0
},
{
"CannabinoidType": "sample string 1",
"MeasurementType": "sample string 2",
"MinValue": 3.0,
"MaxValue": 4.0
}
],
"PackagedDate": "2025-01-18T05:00:23.1971289+00:00",
"ProductionDate": "2025-01-18T05:00:23.1971289+00:00",
"CreatedDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
},
{
"PackageId": "sample string 1",
"BatchId": "sample string 2",
"ExpiryDate": "2025-01-18T05:00:23.1971289+00:00",
"Strain": "sample string 3",
"SupplierLicense": "sample string 4",
"TestDate": "2025-01-18T05:00:23.1971289+00:00",
"HarvestDate": "2025-01-18T05:00:23.1971289+00:00",
"TestingFacilityName": "sample string 5",
"TestBatchNumber": "sample string 6",
"SupplierName": "sample string 7",
"SupplierId": 1,
"TerpeneProfile": "sample string 8",
"ReceivingId": "13934e57-9513-44b2-a233-cbe5eb9e4b49",
"ReceivingDate": "2025-01-18T05:00:23.1971289+00:00",
"Cannabinoids": [
{
"CannabinoidType": "sample string 1",
"MeasurementType": "sample string 2",
"MinValue": 3.0,
"MaxValue": 4.0
},
{
"CannabinoidType": "sample string 1",
"MeasurementType": "sample string 2",
"MinValue": 3.0,
"MaxValue": 4.0
}
],
"PackagedDate": "2025-01-18T05:00:23.1971289+00:00",
"ProductionDate": "2025-01-18T05:00:23.1971289+00:00",
"CreatedDateUtc": "2025-01-18T05:00:23.1971289+00:00",
"UpdatedDateUtc": "2025-01-18T05:00:23.1971289+00:00"
}
],
"TaxRates": [
{
"Id": "2e80036b-0927-445f-bcde-fede44771c00",
"Name": "sample string 2",
"Type": "sample string 3",
"Rate": 4.0,
"Layer": 5,
"CalculatedOn": "sample string 6",
"Locations": [
1,
2
]
},
{
"Id": "2e80036b-0927-445f-bcde-fede44771c00",
"Name": "sample string 2",
"Type": "sample string 3",
"Rate": 4.0,
"Layer": 5,
"CalculatedOn": "sample string 6",
"Locations": [
1,
2
]
}
],
"Classifications": [
{
"TreeId": 1,
"Id": 2,
"Name": "sample string 3",
"ParentCategories": [
{
"Id": 1,
"Name": "sample string 2"
},
{
"Id": 1,
"Name": "sample string 2"
}
]
},
{
"TreeId": 1,
"Id": 2,
"Name": "sample string 3",
"ParentCategories": [
{
"Id": 1,
"Name": "sample string 2"
},
{
"Id": 1,
"Name": "sample string 2"
}
]
}
]
}