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

NameDescriptionTypeAdditional information
companyId

integer

Required

updatedAsOfUTC

date

Required

Body Parameters

Properties to define which items in the model to return.

DetailedProductDataRequestResource
NameDescriptionTypeAdditional 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.

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 availability data for products that have stock (Quantity > 0). Only applies if IncludeAvailability is true. NOTE: this does not exclude product details for items without stock.

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.

Skip

Number of records to skip.

integer

None.

Top

Number of records to take.

integer

Range: inclusive between 1 and 500

IncludeTaxes

Indicates whether to include product tax data.

boolean

None.

IncludeClassifications

Indicates whether to include the canonical classification collection.

boolean

None.

IncludeAllLifecycles

Indicates whether to include all lifecycles, or only Active products.

boolean

None.

IncludeArchived

Indicates whether to include archived products.

boolean

None.

IncludeRegularPricingOnly

Indicates whether to include all types of prices (regular, group, tier) or just regular prices. Only applies if IncludePricing is true.

boolean

None.

Request Formats

application/json, text/json

Sample:
{
  "LocationId": 1,
  "IncludeProductSkusAndUpcs": true,
  "IncludeProductSpecifications": true,
  "IncludeProductAssets": true,
  "IncludeAvailability": true,
  "IncludePackageDetails": true,
  "InStockOnly": true,
  "SellingRoomOnly": true,
  "IncludePricing": true,
  "Skip": 9,
  "Top": 10,
  "IncludeTaxes": true,
  "IncludeClassifications": true,
  "IncludeAllLifecycles": true,
  "IncludeArchived": true,
  "IncludeRegularPricingOnly": true
}

Response Information

Resource Description

DetailedProductDataResource
NameDescriptionTypeAdditional 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": "d9a121fe-c449-4062-9ab9-6a5d115c37f8",
      "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": "7c9f042a-4fb8-49a0-b99b-10e8a8f24fa1",
      "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": "b56412cf-57c7-4f84-8921-b515d6925768",
          "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": "b56412cf-57c7-4f84-8921-b515d6925768",
          "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": "4dbdaf59-bad0-4775-836b-1ba52a56e9dd",
          "Name": "sample string 2",
          "Uri": "sample string 3",
          "Type": "sample string 4",
          "IsHidden": true
        },
        {
          "Id": "4dbdaf59-bad0-4775-836b-1ba52a56e9dd",
          "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-12-11T16:29:04.9372537+00:00",
          "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
          "IsSellingRoom": true,
          "FirstReceivedDateUtc": "2025-12-11T16:29:04.9372537+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-12-11T16:29:04.9372537+00:00",
          "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
          "IsSellingRoom": true,
          "FirstReceivedDateUtc": "2025-12-11T16:29:04.9372537+00:00"
        }
      ],
      "Prices": [
        {
          "LocationId": 1,
          "ProductId": "295a85aa-dc04-4155-861e-46a8a9b031f4",
          "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-12-11T16:29:04.9372537+00:00",
              "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
            },
            {
              "SalePrice": 1.0,
              "AtTierSalePrice": 1.0,
              "StartDateUtc": "2025-12-11T16:29:04.9372537+00:00",
              "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
            }
          ],
          "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00"
        },
        {
          "LocationId": 1,
          "ProductId": "295a85aa-dc04-4155-861e-46a8a9b031f4",
          "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-12-11T16:29:04.9372537+00:00",
              "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
            },
            {
              "SalePrice": 1.0,
              "AtTierSalePrice": 1.0,
              "StartDateUtc": "2025-12-11T16:29:04.9372537+00:00",
              "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
            }
          ],
          "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00"
        }
      ],
      "CreatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
      "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
      "ApplicableTaxRates": [
        "e530a1a7-9c46-4d42-84dc-92d6b7cc94b1",
        "b0a2e411-0499-4f47-94f6-76c5b5d297ab"
      ],
      "ClassificationTreeId": 20,
      "Manufacturer": "sample string 21",
      "MSRP": 1.0,
      "MSRPCurrencyCode": "sample string 22",
      "CompanyLevelRegularPrice": {
        "Price": 1.0,
        "SalePrices": [
          {
            "SalePrice": 1.0,
            "StartDateUtc": "2025-12-11T16:29:04.9372537+00:00",
            "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
          },
          {
            "SalePrice": 1.0,
            "StartDateUtc": "2025-12-11T16:29:04.9372537+00:00",
            "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
          }
        ]
      }
    },
    {
      "ProductId": "d9a121fe-c449-4062-9ab9-6a5d115c37f8",
      "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": "7c9f042a-4fb8-49a0-b99b-10e8a8f24fa1",
      "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": "b56412cf-57c7-4f84-8921-b515d6925768",
          "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": "b56412cf-57c7-4f84-8921-b515d6925768",
          "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": "4dbdaf59-bad0-4775-836b-1ba52a56e9dd",
          "Name": "sample string 2",
          "Uri": "sample string 3",
          "Type": "sample string 4",
          "IsHidden": true
        },
        {
          "Id": "4dbdaf59-bad0-4775-836b-1ba52a56e9dd",
          "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-12-11T16:29:04.9372537+00:00",
          "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
          "IsSellingRoom": true,
          "FirstReceivedDateUtc": "2025-12-11T16:29:04.9372537+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-12-11T16:29:04.9372537+00:00",
          "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
          "IsSellingRoom": true,
          "FirstReceivedDateUtc": "2025-12-11T16:29:04.9372537+00:00"
        }
      ],
      "Prices": [
        {
          "LocationId": 1,
          "ProductId": "295a85aa-dc04-4155-861e-46a8a9b031f4",
          "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-12-11T16:29:04.9372537+00:00",
              "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
            },
            {
              "SalePrice": 1.0,
              "AtTierSalePrice": 1.0,
              "StartDateUtc": "2025-12-11T16:29:04.9372537+00:00",
              "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
            }
          ],
          "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00"
        },
        {
          "LocationId": 1,
          "ProductId": "295a85aa-dc04-4155-861e-46a8a9b031f4",
          "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-12-11T16:29:04.9372537+00:00",
              "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
            },
            {
              "SalePrice": 1.0,
              "AtTierSalePrice": 1.0,
              "StartDateUtc": "2025-12-11T16:29:04.9372537+00:00",
              "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
            }
          ],
          "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00"
        }
      ],
      "CreatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
      "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
      "ApplicableTaxRates": [
        "e530a1a7-9c46-4d42-84dc-92d6b7cc94b1",
        "b0a2e411-0499-4f47-94f6-76c5b5d297ab"
      ],
      "ClassificationTreeId": 20,
      "Manufacturer": "sample string 21",
      "MSRP": 1.0,
      "MSRPCurrencyCode": "sample string 22",
      "CompanyLevelRegularPrice": {
        "Price": 1.0,
        "SalePrices": [
          {
            "SalePrice": 1.0,
            "StartDateUtc": "2025-12-11T16:29:04.9372537+00:00",
            "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
          },
          {
            "SalePrice": 1.0,
            "StartDateUtc": "2025-12-11T16:29:04.9372537+00:00",
            "StopDateUtc": "2025-12-11T16:29:04.9372537+00:00"
          }
        ]
      }
    }
  ],
  "Packages": [
    {
      "PackageId": "sample string 1",
      "BatchId": "sample string 2",
      "ExpiryDate": "2025-12-11T16:29:04.9372537+00:00",
      "Strain": "sample string 3",
      "SupplierLicense": "sample string 4",
      "TestDate": "2025-12-11T16:29:04.9372537+00:00",
      "HarvestDate": "2025-12-11T16:29:04.9372537+00:00",
      "TestingFacilityName": "sample string 5",
      "TestBatchNumber": "sample string 6",
      "SupplierName": "sample string 7",
      "SupplierId": 1,
      "TerpeneProfile": "sample string 8",
      "ReceivingId": "d8eb4136-c975-4c85-8206-027f8acbfeb2",
      "ReceivingDate": "2025-12-11T16:29:04.9372537+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-12-11T16:29:04.9372537+00:00",
      "ProductionDate": "2025-12-11T16:29:04.9372537+00:00",
      "CreatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
      "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00"
    },
    {
      "PackageId": "sample string 1",
      "BatchId": "sample string 2",
      "ExpiryDate": "2025-12-11T16:29:04.9372537+00:00",
      "Strain": "sample string 3",
      "SupplierLicense": "sample string 4",
      "TestDate": "2025-12-11T16:29:04.9372537+00:00",
      "HarvestDate": "2025-12-11T16:29:04.9372537+00:00",
      "TestingFacilityName": "sample string 5",
      "TestBatchNumber": "sample string 6",
      "SupplierName": "sample string 7",
      "SupplierId": 1,
      "TerpeneProfile": "sample string 8",
      "ReceivingId": "d8eb4136-c975-4c85-8206-027f8acbfeb2",
      "ReceivingDate": "2025-12-11T16:29:04.9372537+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-12-11T16:29:04.9372537+00:00",
      "ProductionDate": "2025-12-11T16:29:04.9372537+00:00",
      "CreatedDateUtc": "2025-12-11T16:29:04.9372537+00:00",
      "UpdatedDateUtc": "2025-12-11T16:29:04.9372537+00:00"
    }
  ],
  "TaxRates": [
    {
      "Id": "d842a114-8c57-4b91-b5ce-5c02e48e890a",
      "Name": "sample string 2",
      "Type": "sample string 3",
      "Rate": 4.0,
      "Layer": 5,
      "CalculatedOn": "sample string 6",
      "Locations": [
        1,
        2
      ]
    },
    {
      "Id": "d842a114-8c57-4b91-b5ce-5c02e48e890a",
      "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"
        }
      ]
    }
  ]
}