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": [
"7019c1da-c005-4d00-af1f-4c09afc043d0",
"3c996b7a-74c4-4d27-94ed-0c7830912abd"
]
}
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": "46e64b7a-b0ba-48f9-9c3a-5f422fcac49a",
"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": "b86323f5-cd00-4e06-8502-c22411f9c288",
"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": "1e862bbb-8d74-4394-ada9-a2e206f1847f",
"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": "1e862bbb-8d74-4394-ada9-a2e206f1847f",
"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": "9eb833b9-5417-4933-9599-fc8fa8e572e8",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
},
{
"Id": "9eb833b9-5417-4933-9599-fc8fa8e572e8",
"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:21:31.2693692+00:00",
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+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:21:31.2693692+00:00",
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00"
}
],
"Prices": [
{
"LocationId": 1,
"ProductId": "0c730957-0794-4cff-9ef1-ebcabb91cae3",
"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:21:31.2693692+00:00",
"StopDateUtc": "2025-01-18T05:21:31.2693692+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"StopDateUtc": "2025-01-18T05:21:31.2693692+00:00"
}
],
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00"
},
{
"LocationId": 1,
"ProductId": "0c730957-0794-4cff-9ef1-ebcabb91cae3",
"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:21:31.2693692+00:00",
"StopDateUtc": "2025-01-18T05:21:31.2693692+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"StopDateUtc": "2025-01-18T05:21:31.2693692+00:00"
}
],
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00"
}
],
"CreatedDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"ApplicableTaxRates": [
"0a1eb9af-1034-49b2-923f-5ac3aa62f459",
"9ec764ee-7b24-4482-afa3-a40cb9c8c96d"
],
"ClassificationTreeId": 20,
"Manufacturer": "sample string 21",
"MSRP": 1.0,
"MSRPCurrencyCode": "sample string 22"
},
{
"ProductId": "46e64b7a-b0ba-48f9-9c3a-5f422fcac49a",
"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": "b86323f5-cd00-4e06-8502-c22411f9c288",
"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": "1e862bbb-8d74-4394-ada9-a2e206f1847f",
"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": "1e862bbb-8d74-4394-ada9-a2e206f1847f",
"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": "9eb833b9-5417-4933-9599-fc8fa8e572e8",
"Name": "sample string 2",
"Uri": "sample string 3",
"Type": "sample string 4",
"IsHidden": true
},
{
"Id": "9eb833b9-5417-4933-9599-fc8fa8e572e8",
"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:21:31.2693692+00:00",
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+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:21:31.2693692+00:00",
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00"
}
],
"Prices": [
{
"LocationId": 1,
"ProductId": "0c730957-0794-4cff-9ef1-ebcabb91cae3",
"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:21:31.2693692+00:00",
"StopDateUtc": "2025-01-18T05:21:31.2693692+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"StopDateUtc": "2025-01-18T05:21:31.2693692+00:00"
}
],
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00"
},
{
"LocationId": 1,
"ProductId": "0c730957-0794-4cff-9ef1-ebcabb91cae3",
"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:21:31.2693692+00:00",
"StopDateUtc": "2025-01-18T05:21:31.2693692+00:00"
},
{
"SalePrice": 1.0,
"AtTierSalePrice": 1.0,
"StartDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"StopDateUtc": "2025-01-18T05:21:31.2693692+00:00"
}
],
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00"
}
],
"CreatedDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"ApplicableTaxRates": [
"0a1eb9af-1034-49b2-923f-5ac3aa62f459",
"9ec764ee-7b24-4482-afa3-a40cb9c8c96d"
],
"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:21:31.2693692+00:00",
"Strain": "sample string 3",
"SupplierLicense": "sample string 4",
"TestDate": "2025-01-18T05:21:31.2693692+00:00",
"HarvestDate": "2025-01-18T05:21:31.2693692+00:00",
"TestingFacilityName": "sample string 5",
"TestBatchNumber": "sample string 6",
"SupplierName": "sample string 7",
"SupplierId": 1,
"TerpeneProfile": "sample string 8",
"ReceivingId": "b48c4060-8197-4caf-98b0-2458b47c5000",
"ReceivingDate": "2025-01-18T05:21:31.2693692+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:21:31.2693692+00:00",
"ProductionDate": "2025-01-18T05:21:31.2693692+00:00",
"CreatedDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00"
},
{
"PackageId": "sample string 1",
"BatchId": "sample string 2",
"ExpiryDate": "2025-01-18T05:21:31.2693692+00:00",
"Strain": "sample string 3",
"SupplierLicense": "sample string 4",
"TestDate": "2025-01-18T05:21:31.2693692+00:00",
"HarvestDate": "2025-01-18T05:21:31.2693692+00:00",
"TestingFacilityName": "sample string 5",
"TestBatchNumber": "sample string 6",
"SupplierName": "sample string 7",
"SupplierId": 1,
"TerpeneProfile": "sample string 8",
"ReceivingId": "b48c4060-8197-4caf-98b0-2458b47c5000",
"ReceivingDate": "2025-01-18T05:21:31.2693692+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:21:31.2693692+00:00",
"ProductionDate": "2025-01-18T05:21:31.2693692+00:00",
"CreatedDateUtc": "2025-01-18T05:21:31.2693692+00:00",
"UpdatedDateUtc": "2025-01-18T05:21:31.2693692+00:00"
}
],
"TaxRates": [
{
"Id": "2998c8d6-e6e5-4d64-9936-da68fd55163d",
"Name": "sample string 2",
"Type": "sample string 3",
"Rate": 4.0,
"Layer": 5,
"CalculatedOn": "sample string 6",
"Locations": [
1,
2
]
},
{
"Id": "2998c8d6-e6e5-4d64-9936-da68fd55163d",
"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"
}
]
}
]
}