Resolve a current Utah DABS SKU
curl --request GET \
--url http://127.0.0.1:5185/v1/products/by-sku/{sku}const options = {method: 'GET'};
fetch('http://127.0.0.1:5185/v1/products/by-sku/{sku}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "http://127.0.0.1:5185/v1/products/by-sku/{sku}"
response = requests.get(url)
print(response.text){
"data": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"source_ids": {
"utah_dabs_sku": "347210"
},
"name": "<string>",
"brand": "<string>",
"brand_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"brand_slug": "<string>",
"product_family": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"slug": "<string>",
"name": "<string>",
"relationship_type": "expression"
},
"package_size": {
"milliliters": 2,
"container_count": 2,
"unit_milliliters": 2,
"total_milliliters": 2,
"display": "8 × 355 mL",
"interpretation": "single_container",
"basis": "normalized_source_size",
"normalization_state": "normalized"
},
"price": {
"amount_minor": 1,
"currency": "USD",
"display": "$19.99",
"source": "utah_dabs_workbook",
"times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
}
},
"status": {
"code": "1",
"label": "General distribution",
"lifecycle": "active",
"source_raw": "<string>"
},
"categories": [
{
"id": "<string>",
"name": "<string>"
}
],
"catalog_times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
},
"catalog_presence": {
"state": "present",
"reported_in_latest_complete_snapshot": true,
"consecutive_missing_complete_snapshots": 1,
"last_seen_at": "2023-11-07T05:31:56Z",
"first_missing_at": "2023-11-07T05:31:56Z",
"last_missing_at": "2023-11-07T05:31:56Z",
"reviewed_at": "2023-11-07T05:31:56Z",
"missing_does_not_imply_zero_inventory": true
},
"dabs_flags": {
"new_item_raw": true,
"on_spa_raw": true,
"semantics": "source_flags_unverified",
"times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
}
},
"inventory_retrieved_at": "2023-11-07T05:31:56Z",
"availability_summary": {
"scope_store_count": 1,
"reported_positive_store_count": 1,
"eligible_positive_store_count": 1,
"reported_zero_store_count": 1,
"row_absent_store_count": 1,
"unchecked_store_count": 1,
"retrieved_at_min": "2023-11-07T05:31:56Z",
"retrieved_at_max": "2023-11-07T05:31:56Z",
"retrieval_policy_id": "<string>",
"meets_retrieval_policy": true,
"upstream_age_known": false,
"last_refresh_attempt": {
"attempted_at": "2023-11-07T05:31:56Z",
"status": "succeeded"
}
},
"search_group": {
"type": "product_family",
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"member_count": 3,
"representative_product_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
},
"source_fields": {
"utah_dabs_workbook": {
"sku_raw": "<string>",
"name_raw": "<string>",
"size_value_raw": "<string>",
"size_unit_raw": "<string>",
"status_raw": "<string>",
"display_group_raw": "<string>",
"div_code_raw": "<string>",
"dept_code_raw": "<string>",
"class_code_raw": "<string>",
"price_raw": "<string>"
},
"utah_dabs_locator": {
"sku_raw": "<string>",
"name_raw": "<string>",
"size_value_raw": "<string>",
"size_unit_raw": "<string>",
"status_raw": "<string>",
"display_group_raw": "<string>",
"div_code_raw": "<string>",
"dept_code_raw": "<string>",
"class_code_raw": "<string>",
"price_raw": "<string>"
}
},
"aggregate_inventory": {
"warehouse_quantity_reported": 1,
"aggregate_store_quantity_reported": 1,
"on_order_quantity_reported": 1,
"in_stock_flag_raw": true,
"quantity_semantics": "dabs_reported_unverified",
"times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
}
},
"observed_history": {
"tracking_started_at": "2023-11-07T05:31:56Z",
"earliest_observed_at": "2023-11-07T05:31:56Z",
"latest_observed_at": "2023-11-07T05:31:56Z",
"retained_change_count": 1,
"recent_change_count_30d": 1,
"last_price_change_at": "2023-11-07T05:31:56Z",
"last_inventory_change_at": "2023-11-07T05:31:56Z",
"observed_price": {
"currency": "USD",
"minimum_amount_minor": 1,
"maximum_amount_minor": 1
},
"currently_reporting_stock_store_count": 1,
"last_reported_positive_at": "2023-11-07T05:31:56Z",
"retention_days": 1,
"semantics": "published_observations_not_inferred_sales_or_continuous_history"
},
"family_members": [
{
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"source_ids": {
"utah_dabs_sku": "347210"
},
"name": "<string>",
"brand": "<string>",
"relationship_type": "expression",
"vintage_year": 1999,
"age_statement": "<string>",
"package_size": {
"milliliters": 2,
"container_count": 2,
"unit_milliliters": 2,
"total_milliliters": 2,
"display": "8 × 355 mL",
"interpretation": "single_container",
"basis": "normalized_source_size",
"normalization_state": "normalized"
},
"price": {
"amount_minor": 1,
"currency": "USD",
"display": "$19.99",
"source": "utah_dabs_workbook",
"times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
}
},
"status": {
"code": "1",
"label": "General distribution",
"lifecycle": "active",
"source_raw": "<string>"
},
"inventory_retrieved_at": "2023-11-07T05:31:56Z",
"availability_summary": {
"scope_store_count": 1,
"reported_positive_store_count": 1,
"eligible_positive_store_count": 1,
"reported_zero_store_count": 1,
"row_absent_store_count": 1,
"unchecked_store_count": 1,
"retrieved_at_min": "2023-11-07T05:31:56Z",
"retrieved_at_max": "2023-11-07T05:31:56Z",
"retrieval_policy_id": "<string>",
"meets_retrieval_policy": true,
"upstream_age_known": false,
"last_refresh_attempt": {
"attempted_at": "2023-11-07T05:31:56Z",
"status": "succeeded"
}
}
}
],
"identifier_matches": [
{
"source": "utah_dabs_sku",
"value": "347210",
"relationship": "current",
"current_value": "347210"
}
],
"name_components": {
"product_name": "<string>",
"expression": "<string>",
"age_statement": "<string>",
"pack_count": 2
},
"attributes": {
"vintage_year": 1999,
"proof": 120,
"alcohol_by_volume_percent": 50,
"alcohol_by_volume_basis": "explicit_label",
"wine_varietals": [
"cabernet_sauvignon"
],
"package_form": "can",
"beverage_styles": [
"blanco"
],
"origin_country_codes": [
"AR"
],
"production_designations": [
"bottled_in_bond"
],
"certifications": [
"kosher_for_passover_mevushal"
],
"source_programs": [
"special_order"
],
"review": {
"state": "confirmed",
"rule_version": "<string>",
"reviewed_at": "2023-11-07T05:31:56Z"
}
}
},
"meta": {
"freshness": {
"catalog": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
},
"inventory": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at_min": "2023-11-07T05:31:56Z",
"retrieved_at_max": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z",
"upstream_age_known": false
}
},
"warnings": [
{
"code": "INVENTORY_COVERAGE_PARTIAL"
}
]
}
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}Resolve a current Utah DABS SKU
Resolves an unambiguous current or historical Utah DABS SKU to the current published product. data.identifier_matches states whether the requested value is current, an active alias, or historical. Conflicted and ambiguous identities return 404 rather than guessing. Leading zeroes are required.
Resolve a current Utah DABS SKU
curl --request GET \
--url http://127.0.0.1:5185/v1/products/by-sku/{sku}const options = {method: 'GET'};
fetch('http://127.0.0.1:5185/v1/products/by-sku/{sku}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));import requests
url = "http://127.0.0.1:5185/v1/products/by-sku/{sku}"
response = requests.get(url)
print(response.text){
"data": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"source_ids": {
"utah_dabs_sku": "347210"
},
"name": "<string>",
"brand": "<string>",
"brand_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"brand_slug": "<string>",
"product_family": {
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"slug": "<string>",
"name": "<string>",
"relationship_type": "expression"
},
"package_size": {
"milliliters": 2,
"container_count": 2,
"unit_milliliters": 2,
"total_milliliters": 2,
"display": "8 × 355 mL",
"interpretation": "single_container",
"basis": "normalized_source_size",
"normalization_state": "normalized"
},
"price": {
"amount_minor": 1,
"currency": "USD",
"display": "$19.99",
"source": "utah_dabs_workbook",
"times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
}
},
"status": {
"code": "1",
"label": "General distribution",
"lifecycle": "active",
"source_raw": "<string>"
},
"categories": [
{
"id": "<string>",
"name": "<string>"
}
],
"catalog_times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
},
"catalog_presence": {
"state": "present",
"reported_in_latest_complete_snapshot": true,
"consecutive_missing_complete_snapshots": 1,
"last_seen_at": "2023-11-07T05:31:56Z",
"first_missing_at": "2023-11-07T05:31:56Z",
"last_missing_at": "2023-11-07T05:31:56Z",
"reviewed_at": "2023-11-07T05:31:56Z",
"missing_does_not_imply_zero_inventory": true
},
"dabs_flags": {
"new_item_raw": true,
"on_spa_raw": true,
"semantics": "source_flags_unverified",
"times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
}
},
"inventory_retrieved_at": "2023-11-07T05:31:56Z",
"availability_summary": {
"scope_store_count": 1,
"reported_positive_store_count": 1,
"eligible_positive_store_count": 1,
"reported_zero_store_count": 1,
"row_absent_store_count": 1,
"unchecked_store_count": 1,
"retrieved_at_min": "2023-11-07T05:31:56Z",
"retrieved_at_max": "2023-11-07T05:31:56Z",
"retrieval_policy_id": "<string>",
"meets_retrieval_policy": true,
"upstream_age_known": false,
"last_refresh_attempt": {
"attempted_at": "2023-11-07T05:31:56Z",
"status": "succeeded"
}
},
"search_group": {
"type": "product_family",
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"member_count": 3,
"representative_product_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
},
"source_fields": {
"utah_dabs_workbook": {
"sku_raw": "<string>",
"name_raw": "<string>",
"size_value_raw": "<string>",
"size_unit_raw": "<string>",
"status_raw": "<string>",
"display_group_raw": "<string>",
"div_code_raw": "<string>",
"dept_code_raw": "<string>",
"class_code_raw": "<string>",
"price_raw": "<string>"
},
"utah_dabs_locator": {
"sku_raw": "<string>",
"name_raw": "<string>",
"size_value_raw": "<string>",
"size_unit_raw": "<string>",
"status_raw": "<string>",
"display_group_raw": "<string>",
"div_code_raw": "<string>",
"dept_code_raw": "<string>",
"class_code_raw": "<string>",
"price_raw": "<string>"
}
},
"aggregate_inventory": {
"warehouse_quantity_reported": 1,
"aggregate_store_quantity_reported": 1,
"on_order_quantity_reported": 1,
"in_stock_flag_raw": true,
"quantity_semantics": "dabs_reported_unverified",
"times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
}
},
"observed_history": {
"tracking_started_at": "2023-11-07T05:31:56Z",
"earliest_observed_at": "2023-11-07T05:31:56Z",
"latest_observed_at": "2023-11-07T05:31:56Z",
"retained_change_count": 1,
"recent_change_count_30d": 1,
"last_price_change_at": "2023-11-07T05:31:56Z",
"last_inventory_change_at": "2023-11-07T05:31:56Z",
"observed_price": {
"currency": "USD",
"minimum_amount_minor": 1,
"maximum_amount_minor": 1
},
"currently_reporting_stock_store_count": 1,
"last_reported_positive_at": "2023-11-07T05:31:56Z",
"retention_days": 1,
"semantics": "published_observations_not_inferred_sales_or_continuous_history"
},
"family_members": [
{
"id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"source_ids": {
"utah_dabs_sku": "347210"
},
"name": "<string>",
"brand": "<string>",
"relationship_type": "expression",
"vintage_year": 1999,
"age_statement": "<string>",
"package_size": {
"milliliters": 2,
"container_count": 2,
"unit_milliliters": 2,
"total_milliliters": 2,
"display": "8 × 355 mL",
"interpretation": "single_container",
"basis": "normalized_source_size",
"normalization_state": "normalized"
},
"price": {
"amount_minor": 1,
"currency": "USD",
"display": "$19.99",
"source": "utah_dabs_workbook",
"times": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
}
},
"status": {
"code": "1",
"label": "General distribution",
"lifecycle": "active",
"source_raw": "<string>"
},
"inventory_retrieved_at": "2023-11-07T05:31:56Z",
"availability_summary": {
"scope_store_count": 1,
"reported_positive_store_count": 1,
"eligible_positive_store_count": 1,
"reported_zero_store_count": 1,
"row_absent_store_count": 1,
"unchecked_store_count": 1,
"retrieved_at_min": "2023-11-07T05:31:56Z",
"retrieved_at_max": "2023-11-07T05:31:56Z",
"retrieval_policy_id": "<string>",
"meets_retrieval_policy": true,
"upstream_age_known": false,
"last_refresh_attempt": {
"attempted_at": "2023-11-07T05:31:56Z",
"status": "succeeded"
}
}
}
],
"identifier_matches": [
{
"source": "utah_dabs_sku",
"value": "347210",
"relationship": "current",
"current_value": "347210"
}
],
"name_components": {
"product_name": "<string>",
"expression": "<string>",
"age_statement": "<string>",
"pack_count": 2
},
"attributes": {
"vintage_year": 1999,
"proof": 120,
"alcohol_by_volume_percent": 50,
"alcohol_by_volume_basis": "explicit_label",
"wine_varietals": [
"cabernet_sauvignon"
],
"package_form": "can",
"beverage_styles": [
"blanco"
],
"origin_country_codes": [
"AR"
],
"production_designations": [
"bottled_in_bond"
],
"certifications": [
"kosher_for_passover_mevushal"
],
"source_programs": [
"special_order"
],
"review": {
"state": "confirmed",
"rule_version": "<string>",
"reviewed_at": "2023-11-07T05:31:56Z"
}
}
},
"meta": {
"freshness": {
"catalog": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z"
},
"inventory": {
"source_updated_at": "2023-11-07T05:31:56Z",
"retrieved_at_min": "2023-11-07T05:31:56Z",
"retrieved_at_max": "2023-11-07T05:31:56Z",
"published_at": "2023-11-07T05:31:56Z",
"upstream_age_known": false
}
},
"warnings": [
{
"code": "INVENTORY_COVERAGE_PARTIAL"
}
]
}
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}{
"type": "<string>",
"title": "<string>",
"status": 499,
"detail": "<string>",
"instance": "<string>",
"code": "<string>",
"request_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"invalid_params": [
{
"name": "<string>",
"reason": "<string>"
}
]
}