POST v1/companies/{companyId}/DetailedProductData/ByProductIdList
This call is intended to target data for a list of specific products
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/ByProductIdList
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,
"ProductIds": [
"f422615b-c5d7-457b-ac18-9d839be9372c",
"23BE37FD-DDBE-4563-8B78-FEE21665E2ED"
]
}
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| companyId | integer |
Required |
Body Parameters
Properties to define which items in the model to return.
DetailedProductDataByProductIdListRequestResource| 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 products 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. |
| ProductIds |
List of Product Id's to get data for. Maximum of 500 |
Collection of globally unique identifier |
None. |
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,
"ProductIds": [
"3860f8fe-2f13-4cfc-95a6-475583966077",
"8f355b30-a33a-47ce-9ceb-3e074acf0bcb"
]
}
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": "30d52805-9b97-495e-9796-dc602ba4f246",
"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": "e6fe5bc8-ea36-4f3b-847a-fc75b34ea04d",
"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": "9393dab1-ec2b-4bea-8c45-4ec66b0c272b",
"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": "9393dab1-ec2b-4bea-8c45-4ec66b0c272b",
"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": "cfe178f9-46f4-453d-91ec-e97e6b7b85a1",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
},
{
"Id": "cfe178f9-46f4-453d-91ec-e97e6b7b85a1",
"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-02-20T19:12:11.4478218+00:00",
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+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-02-20T19:12:11.4478218+00:00",
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00"
}
],
"Prices": [
{
"LocationId": 1,
"ProductId": "c1231c8c-dc51-4b45-97bc-f7b905261893",
"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-02-20T19:12:11.4478218+00:00",
"StopDateUtc": "2025-02-20T19:12:11.4478218+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"StopDateUtc": "2025-02-20T19:12:11.4478218+00:00"
}
],
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00"
},
{
"LocationId": 1,
"ProductId": "c1231c8c-dc51-4b45-97bc-f7b905261893",
"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-02-20T19:12:11.4478218+00:00",
"StopDateUtc": "2025-02-20T19:12:11.4478218+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"StopDateUtc": "2025-02-20T19:12:11.4478218+00:00"
}
],
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00"
}
],
"CreatedDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"ApplicableTaxRates": [
"eb03d918-67c9-4eaf-84c8-2b38a9813fbe",
"9dd46689-6e7b-4e58-8276-db14eebc9fe8"
],
"ClassificationTreeId": 20,
"Manufacturer": "sample string 21",
"MSRP": 1.0,
"MSRPCurrencyCode": "sample string 22"
},
{
"ProductId": "30d52805-9b97-495e-9796-dc602ba4f246",
"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": "e6fe5bc8-ea36-4f3b-847a-fc75b34ea04d",
"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": "9393dab1-ec2b-4bea-8c45-4ec66b0c272b",
"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": "9393dab1-ec2b-4bea-8c45-4ec66b0c272b",
"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": "cfe178f9-46f4-453d-91ec-e97e6b7b85a1",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
},
{
"Id": "cfe178f9-46f4-453d-91ec-e97e6b7b85a1",
"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-02-20T19:12:11.4478218+00:00",
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+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-02-20T19:12:11.4478218+00:00",
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00"
}
],
"Prices": [
{
"LocationId": 1,
"ProductId": "c1231c8c-dc51-4b45-97bc-f7b905261893",
"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-02-20T19:12:11.4478218+00:00",
"StopDateUtc": "2025-02-20T19:12:11.4478218+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"StopDateUtc": "2025-02-20T19:12:11.4478218+00:00"
}
],
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00"
},
{
"LocationId": 1,
"ProductId": "c1231c8c-dc51-4b45-97bc-f7b905261893",
"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-02-20T19:12:11.4478218+00:00",
"StopDateUtc": "2025-02-20T19:12:11.4478218+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"StopDateUtc": "2025-02-20T19:12:11.4478218+00:00"
}
],
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00"
}
],
"CreatedDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"ApplicableTaxRates": [
"eb03d918-67c9-4eaf-84c8-2b38a9813fbe",
"9dd46689-6e7b-4e58-8276-db14eebc9fe8"
],
"ClassificationTreeId": 20,
"Manufacturer": "sample string 21",
"MSRP": 1.0,
"MSRPCurrencyCode": "sample string 22"
}
],
"Packages": [
{
"PackageId": "sample string 1",
"BatchId": "sample string 2",
"ExpiryDate": "2025-02-20T19:12:11.4478218+00:00",
"Strain": "sample string 3",
"SupplierLicense": "sample string 4",
"TestDate": "2025-02-20T19:12:11.4478218+00:00",
"HarvestDate": "2025-02-20T19:12:11.4478218+00:00",
"TestingFacilityName": "sample string 5",
"TestBatchNumber": "sample string 6",
"SupplierName": "sample string 7",
"SupplierId": 1,
"TerpeneProfile": "sample string 8",
"ReceivingId": "e5ec84e7-ef53-424d-9368-35598fa580a0",
"ReceivingDate": "2025-02-20T19:12:11.4478218+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-02-20T19:12:11.4478218+00:00",
"ProductionDate": "2025-02-20T19:12:11.4478218+00:00",
"CreatedDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00"
},
{
"PackageId": "sample string 1",
"BatchId": "sample string 2",
"ExpiryDate": "2025-02-20T19:12:11.4478218+00:00",
"Strain": "sample string 3",
"SupplierLicense": "sample string 4",
"TestDate": "2025-02-20T19:12:11.4478218+00:00",
"HarvestDate": "2025-02-20T19:12:11.4478218+00:00",
"TestingFacilityName": "sample string 5",
"TestBatchNumber": "sample string 6",
"SupplierName": "sample string 7",
"SupplierId": 1,
"TerpeneProfile": "sample string 8",
"ReceivingId": "e5ec84e7-ef53-424d-9368-35598fa580a0",
"ReceivingDate": "2025-02-20T19:12:11.4478218+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-02-20T19:12:11.4478218+00:00",
"ProductionDate": "2025-02-20T19:12:11.4478218+00:00",
"CreatedDateUtc": "2025-02-20T19:12:11.4478218+00:00",
"UpdatedDateUtc": "2025-02-20T19:12:11.4478218+00:00"
}
],
"TaxRates": [
{
"Id": "02c9b77c-12c7-44ec-8f3f-9c31883f1ef3",
"Name": "sample string 2",
"Type": "sample string 3",
"Rate": 4.0,
"Layer": 5,
"CalculatedOn": "sample string 6",
"Locations": [
1,
2
]
},
{
"Id": "02c9b77c-12c7-44ec-8f3f-9c31883f1ef3",
"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"
}
]
}
]
}