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": "2ed71fe5-0e3a-43f4-bb43-9525a6fef8fc",
"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": "89283248-ee5c-4789-87b7-329c2708e6fb",
"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": "2f97f4cc-24a9-484f-a410-842f8e3054c0",
"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": "2f97f4cc-24a9-484f-a410-842f8e3054c0",
"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": "f377bc3f-541b-44af-82c2-57bb74cb3a04",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
},
{
"Id": "f377bc3f-541b-44af-82c2-57bb74cb3a04",
"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,
"TotalCostInStock": 7.0,
"UnitCost": 8.0,
"ReceivedDate": "2024-11-07T08:55:43.2954537+00:00",
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
},
{
"LocationId": 1,
"RoomId": 2,
"PackageId": "sample string 3",
"BatchId": "sample string 4",
"UnitId": 5,
"InStockQuantity": 6.0,
"TotalCostInStock": 7.0,
"UnitCost": 8.0,
"ReceivedDate": "2024-11-07T08:55:43.2954537+00:00",
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
}
],
"Prices": [
{
"LocationId": 1,
"ProductId": "8336262e-94b8-4e84-8551-f64aa6ae78fb",
"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": "2024-11-07T08:55:43.2954537+00:00",
"StopDateUtc": "2024-11-07T08:55:43.2954537+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"StopDateUtc": "2024-11-07T08:55:43.2954537+00:00"
}
],
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
},
{
"LocationId": 1,
"ProductId": "8336262e-94b8-4e84-8551-f64aa6ae78fb",
"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": "2024-11-07T08:55:43.2954537+00:00",
"StopDateUtc": "2024-11-07T08:55:43.2954537+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"StopDateUtc": "2024-11-07T08:55:43.2954537+00:00"
}
],
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
}
],
"CreatedDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"ApplicableTaxRates": [
"a8be2359-137e-4283-be61-881f0a8aedca",
"df48da25-6d79-4eac-901d-2661651ba324"
],
"ClassificationTreeId": 20,
"Manufacturer": "sample string 21",
"MSRP": 1.0,
"MSRPCurrencyCode": "sample string 22"
},
{
"ProductId": "2ed71fe5-0e3a-43f4-bb43-9525a6fef8fc",
"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": "89283248-ee5c-4789-87b7-329c2708e6fb",
"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": "2f97f4cc-24a9-484f-a410-842f8e3054c0",
"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": "2f97f4cc-24a9-484f-a410-842f8e3054c0",
"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": "f377bc3f-541b-44af-82c2-57bb74cb3a04",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
},
{
"Id": "f377bc3f-541b-44af-82c2-57bb74cb3a04",
"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,
"TotalCostInStock": 7.0,
"UnitCost": 8.0,
"ReceivedDate": "2024-11-07T08:55:43.2954537+00:00",
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
},
{
"LocationId": 1,
"RoomId": 2,
"PackageId": "sample string 3",
"BatchId": "sample string 4",
"UnitId": 5,
"InStockQuantity": 6.0,
"TotalCostInStock": 7.0,
"UnitCost": 8.0,
"ReceivedDate": "2024-11-07T08:55:43.2954537+00:00",
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
}
],
"Prices": [
{
"LocationId": 1,
"ProductId": "8336262e-94b8-4e84-8551-f64aa6ae78fb",
"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": "2024-11-07T08:55:43.2954537+00:00",
"StopDateUtc": "2024-11-07T08:55:43.2954537+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"StopDateUtc": "2024-11-07T08:55:43.2954537+00:00"
}
],
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
},
{
"LocationId": 1,
"ProductId": "8336262e-94b8-4e84-8551-f64aa6ae78fb",
"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": "2024-11-07T08:55:43.2954537+00:00",
"StopDateUtc": "2024-11-07T08:55:43.2954537+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"StopDateUtc": "2024-11-07T08:55:43.2954537+00:00"
}
],
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
}
],
"CreatedDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"ApplicableTaxRates": [
"a8be2359-137e-4283-be61-881f0a8aedca",
"df48da25-6d79-4eac-901d-2661651ba324"
],
"ClassificationTreeId": 20,
"Manufacturer": "sample string 21",
"MSRP": 1.0,
"MSRPCurrencyCode": "sample string 22"
}
],
"Packages": [
{
"PackageId": "sample string 1",
"BatchId": "sample string 2",
"ExpiryDate": "2024-11-07T08:55:43.2954537+00:00",
"Strain": "sample string 3",
"SupplierLicense": "sample string 4",
"TestDate": "2024-11-07T08:55:43.2954537+00:00",
"HarvestDate": "2024-11-07T08:55:43.2954537+00:00",
"TestingFacilityName": "sample string 5",
"TestBatchNumber": "sample string 6",
"SupplierName": "sample string 7",
"SupplierId": 1,
"TerpeneProfile": "sample string 8",
"ReceivingId": "0ca36baf-6be4-49ae-8eae-8bed8da9a743",
"ReceivingDate": "2024-11-07T08:55:43.2954537+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": "2024-11-07T08:55:43.2954537+00:00",
"ProductionDate": "2024-11-07T08:55:43.2954537+00:00",
"CreatedDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
},
{
"PackageId": "sample string 1",
"BatchId": "sample string 2",
"ExpiryDate": "2024-11-07T08:55:43.2954537+00:00",
"Strain": "sample string 3",
"SupplierLicense": "sample string 4",
"TestDate": "2024-11-07T08:55:43.2954537+00:00",
"HarvestDate": "2024-11-07T08:55:43.2954537+00:00",
"TestingFacilityName": "sample string 5",
"TestBatchNumber": "sample string 6",
"SupplierName": "sample string 7",
"SupplierId": 1,
"TerpeneProfile": "sample string 8",
"ReceivingId": "0ca36baf-6be4-49ae-8eae-8bed8da9a743",
"ReceivingDate": "2024-11-07T08:55:43.2954537+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": "2024-11-07T08:55:43.2954537+00:00",
"ProductionDate": "2024-11-07T08:55:43.2954537+00:00",
"CreatedDateUtc": "2024-11-07T08:55:43.2954537+00:00",
"UpdatedDateUtc": "2024-11-07T08:55:43.2954537+00:00"
}
],
"TaxRates": [
{
"Id": "6b78fac8-36bb-4aca-9ca9-98e110b89f95",
"Name": "sample string 2",
"Type": "sample string 3",
"Rate": 4.0,
"Layer": 5,
"CalculatedOn": "sample string 6",
"Locations": [
1,
2
]
},
{
"Id": "6b78fac8-36bb-4aca-9ca9-98e110b89f95",
"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"
}
]
}
]
}