Dealers Entity
The honda_auto_api_dealers and acura_auto_api_dealers transformed assets merge
dealer records from two source endpoints. Several fields are produced by both sources
in different formats; this document describes those differences and any normalization
considerations.
Sources
| Source | Endpoint | Notes |
|---|---|---|
dealers | GET /platform/api/v1/dealer | Primary dealer source — see Dealer Locator |
inventory_and_dealers | GET /platform/api/v3/inventoryAndDealers | Secondary; dealer records are a by-product of inventory fetch — see Inventory and Dealers |
Field format differences
phone
| Source | Format | Example |
|---|---|---|
dealers (v1) | Formatted string | (601) 362-4803 |
inventory_and_dealers (v3) | Raw digits only | 6013624803 |
Both values represent the same phone number. Stripping punctuation or reformatting raw digits would produce a deterministic result.
city
| Source | Format | Example |
|---|---|---|
dealers (v1) | Mixed case | "Jackson" |
inventory_and_dealers (v3) | Unknown — format differences observed but no examples captured |
zip_code
| Source | Format | Example |
|---|---|---|
dealers (v1) | 5-digit | "39201" |
inventory_and_dealers (v3) | 9-digit ZIP+4 | "392011234" |
Truncating to 5 digits would produce a deterministic result.
street
Format differences between the two sources have been observed but no specific examples have been captured.
web_address
| Source | Example |
|---|---|
dealers (v1) | https://www.normreeveshondavista.com |
inventory_and_dealers (v3) | https://www.normreeveshondavista.com/ |
The v3 source appends a trailing slash in some cases. Both values resolve to the same URL. Stripping trailing slashes would produce a deterministic result.
asa_ranking
Honda-only field present only in the v1/dealer response (ASARanking). Not present
in the v3/inventoryAndDealers dealer records; v3 always contributes null.
See Dealer Locator — Known data quality issues for additional context on the field's semantics.