- query
- The Target URL you submitted. Populated on all three of our rows, including the two that failed - it echoes back what was asked for, which is what lets you reconcile a result set against your input list.
- sku_code
- Intended to carry Target's own item number. Empty on our row, even though that number is visible in the URL itself as the
A-… segment. If you need it, parse it from url rather than waiting for the column. - product_url
- Intended to carry the canonical product page. Empty on our row -
url carried the address instead. Note that this column does not exist at all in the thirteen-column form. - name
- The product title as the listing states it. Populated, and a full retail title: brand, model, configuration and finish all in one string. This is the column the service delivers most reliably here.
- description
- Intended to carry the longer product text. Empty on our row.
- parsed_price
- Intended to carry the price as a bare number. Empty on our row, and absent entirely from the thirteen-column form. See the note below: the page does not serve a price to read.
- price
- Intended to carry the price as displayed. Empty on our row, for the same reason.
- currency
- Intended to carry the currency the price is quoted in. Empty on our row - with no price there is nothing to denominate.
- availability
- Intended to carry stock status. Empty on our row. Target publishes availability per store and per fulfilment method, so treat its absence as the listing not handing one over rather than as the item being unavailable.
- rating
- Intended to carry an average customer rating. Empty on our row.
- reviews
- Intended to carry the review count behind that rating. Empty on our row.
- images
- Every image on the listing. Populated - a real Target image URL on the product's own image host. Along with
name, this is what the run actually delivered. - brand
- Intended to carry the manufacturer. Empty on our row, although on this particular product the maker is the first word of
name. Parse it from the name if you need to group by it. - sku
- Intended to carry a second identifier. Empty on our row, so we cannot tell you whether Target populates it differently from
sku_code. - url
- The address the row was produced from. Populated, and equal to
query on our row. The item id is inside it, which makes it the practical identifier for this service. - image
- The primary image on its own, so the common case needs no string splitting. Populated, and identical to
images on our row. - status
- A per-row flag written by our exporter, not by Target. Across our three runs it took two values:
ok on one row and http 404 on two, the latter from a placeholder address that does not exist. Reconcile on this column.
Two things this table cannot tell you on its own. First, why the money columns are empty. The vendor's own service note records that the price comes only from Target's separate RedSky API, which is protected and refuses datacenter addresses outright - and a direct fetch of the same product page agrees with that completely: roughly 685 KB of HTML carrying the product name, the item id and nearly a thousand image-host references, with no structured-data block and no price anywhere, plus a preconnect hint pointing at that very API. The page you can read does not contain the number, so no scraper reading that page will return it. Second, the header itself moved. Our successful run is seventeen columns; both later runs are thirteen, having dropped sku_code, product_url, parsed_price and images. Check which form you are holding before you diff two exports.