products_all_nested

The products_all_nested view will display all available fields in our product schema.

If using the csv format, it will keep all elements in multi-valued field lists in a single cell. This means a field like prices will show up as a nested JSON object within the CSV.

Included Fields

Field	Included Sub-fields
`asins`	N/A
`brand`	N/A
`categories`	N/A
`colors`	N/A
`count`	N/A
`dateAdded`	N/A
`dateUpdated`	N/A
`descriptions`	`dateSeen` `sourceURLs` `value`
`dimension`	N/A
`ean`	N/A
`features`	`key` `value`
`flavors`	N/A
`imageURLs`	N/A
`isbn`	N/A
`keys`	N/A
`manufacturer`	N/A
`manufacturerNumber`	N/A
`merchants`	`address` `availability` `city` `country` `dateSeen` `name` `phone` `postalCode` `province`
`name`	N/A
`prices`	`amountMin` `amountMax` `availability` `color` `condition` `count` `currency` `dateAdded` `dateSeen` `flavor` `isSale` `merchant` `offer` `returnPolicy` `shipping` `size` `source` `sourceURLs` `warranty`
`reviews`	`date` `dateAdded` `dateSeen` `didPurchase` `doRecommend` `numHelpful` `rating` `sourceURLs` `text` `title` `userCity` `username` `userProvince`
`sizes`	N/A
`skus`	`sourceURLs` `value`
`sourceURLs`	N/A
`upc`	N/A
`vin`	N/A
`websiteID`	N/A
`weight`	N/A

Sample CSV Output

Right-click and choose "Save link as..." to download this sample so you can see it in Excel: products_multiValuedFieldsNested-CSV-example.csv

id,asins,brand,categories,colors,count,dateAdded,dateUpdated,descriptions.dateSeen,descriptions.sourceURLs,descriptions.value,dimension,ean,features.key,features.value,flavors,websiteID,imageURLs,isbn,keys,manufacturer,manufacturerNumber,merchants.address,merchants.availability,merchants.city,merchants.country,merchants.dateSeen,merchants.name,merchants.phone,merchants.postalCode,merchants.province,name,prices.amountMin,prices.amountMax,prices.availability,prices.color,prices.condition,prices.count,prices.currency,prices.dateAdded,prices.dateSeen,prices.flavor,prices.isSale,prices.merchant,prices.offer,prices.returnPolicy,prices.shipping,prices.size,prices.source,prices.sourceURLs,prices.warranty,reviews.date,reviews.dateAdded,reviews.dateSeen,reviews.didPurchase,reviews.doRecommend,reviews.numHelpful,reviews.rating,reviews.sourceURLs,reviews.text,reviews.title,reviews.userCity,reviews.username,reviews.userProvince,sizes,skus.sourceURLs,skus.value,sourceURLs,upc,vin,weight
"AVnjo8-lD1GB75FR6uL3",,,,,,"2015-08-17T18:43:00Z","2016-05-05T17:20:05Z",,,,,,,,,,,,,"sunville",,,,,,,,,,,"Brand New Women's Fashion Rubber Rain Boots / Bottes De Pluie",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"227 g"
"AVnjo8-lD1GB75FR6uL3","B00MKHSLP2",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,"Women",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,"Shoes",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,"Shoes & Handbags",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,"Boots",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Beige Plaid",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Fuchsia",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Black Polka Dots",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Black",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Houndstooth",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Navy Stripe",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Dk Green",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Leopard",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Camo",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Green",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Zebra",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,"Multi-Color Polka Dots",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,"Date first available at Amazon.ca","Jan. 15 2014",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/41-V0orNJkL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/31CXHHQarXL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/411huD5UrRL._SY395_QL70_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"https://images-na.ssl-images-amazon.com/images/I/51UcNOuZSUL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/411HlTw2geL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/41ge8ewa3TL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"https://images-na.ssl-images-amazon.com/images/I/51UcNOuZSUL._SY395_QL70_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/411huD5UrRL._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,"http://ecx.images-amazon.com/images/I/41%2BIJyHAy9L._US40_.jpg",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,"brandnewwomensfashionrubberrainbootsbottesdepluie/b00mkhslp2",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,"2016-04-29T00:00:00Z","Amazon.ca",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,26.950000762939453,26.950000762939453,,,"new",,"CAD","2015-08-17T18:43:00Z","2015-08-10T00:00:00Z",,,"Amazon.ca",,,"free",,,"http://www.amazon.ca/Brand-Womens-Rubber-Bottes-Dotted/dp/B00OMB8O7E",,,,,,,,,,,,,,,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,4.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","These fit fine, made for people with skinny legs. My thicker legs/ muscular have a squishy time.","Four Stars",,"PLAINJANE",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,1.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","A cheap boot that lasted only a few weeks on our property. Mild use and these have already split the seems. Not recommended for anyone. Spend more money and get a good pair.","Cheaply made boot that doesnt last.",,"Brandon",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Excellent quality and very very cute rain boots. Very comfortable - come on rain!!!","Quality and comfort and cute too!",,"Bonnie Hallman",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,1.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Cracked within a few months where it bends for your toes. I've owned a couple of these. the same happened for both as well as the buckle breaking. I'm finally done with it. Will just spend a hit more for hunter boots.","Cracked within a few months.",,"Chiqui Mancini",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Nice boots. A bit loose for my girl friends skinny legs.","Five Stars",,"Etienne",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","very fashionable as well as comfortable","Five Stars",,"jahoody",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","These arrived very fast and are great.","Five Stars",,"Linda Findlay-Palmer",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,3.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Decent boots but one of the buckles broke a day after I received them.","Three Stars",,"Sheena Cormier",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Really like them! Great grips for working on the farm and tall enough too! Found their sizing a little bit smaller than I expected, but still fits good because it has a wide toe area. Now I can farm in style and with any color!","really like them",,"Marie",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"2015-08-17T18:43:00Z","2015-08-15T00:00:00Z",,,,5.0,"http://www.amazon.ca/product-reviews/B00MKHSLP2","Fits perfectly. Love the colour.","Love the colour",,"N.K.",,,,,,,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"https://www.amazon.ca/Brand-Womens-Rubber-Boots-Bottes/dp/B00OL26D4K",,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"http://www.amazon.ca/Brand-Womens-Rubber-Boots-Bottes/dp/B00OL26D4K",,,
"AVnjo8-lD1GB75FR6uL3",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"http://www.amazon.ca/product-reviews/B00MKHSLP2",,,

Sample JSON Output

{
  "asins": [
    "B00MKHSLP2"
  ],
  "categories": [
    "Women",
    "Shoes",
    "Shoes & Handbags",
    "Boots"
  ],
  "colors": [
    "Beige Plaid",
    "Fuchsia",
    "Black Polka Dots",
    "Black",
    "Houndstooth",
    "Navy Stripe",
    "Dk Green",
    "Leopard",
    "Camo",
    "Green",
    "Zebra",
    "Multi-Color Polka Dots"
  ],
  "dateAdded": "2015-08-17T18:43:00Z",
  "dateUpdated": "2016-05-05T17:20:05Z",
  "features": [
    {
      "key": "Date first available at Amazon.ca",
      "value": [
        "Jan. 15 2014"
      ]
    }
  ],
  "imageURLs": [
    "http://ecx.images-amazon.com/images/I/41-V0orNJkL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/31CXHHQarXL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/411huD5UrRL._SY395_QL70_.jpg",
    "https://images-na.ssl-images-amazon.com/images/I/51UcNOuZSUL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/411HlTw2geL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/41ge8ewa3TL._US40_.jpg",
    "https://images-na.ssl-images-amazon.com/images/I/51UcNOuZSUL._SY395_QL70_.jpg",
    "http://ecx.images-amazon.com/images/I/411huD5UrRL._US40_.jpg",
    "http://ecx.images-amazon.com/images/I/41%2BIJyHAy9L._US40_.jpg"
  ],
  "keys": [
    "brandnewwomensfashionrubberrainbootsbottesdepluie/b00mkhslp2"
  ],
  "manufacturer": "sunville",
  "merchants": [
    {
      "dateSeen": [
        "2016-04-29T00:00:00Z"
      ],
      "name": "Amazon.ca"
    }
  ],
  "name": "Brand New Women's Fashion Rubber Rain Boots / Bottes De Pluie",
  "prices": [
    {
      "amountMin": 26.950000762939453,
      "amountMax": 26.950000762939453,
      "condition": "new",
      "currency": "CAD",
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-10T00:00:00Z"
      ],
      "merchant": "Amazon.ca",
      "shipping": "free",
      "sourceURLs": [
        "http://www.amazon.ca/Brand-Womens-Rubber-Bottes-Dotted/dp/B00OMB8O7E"
      ]
    }
  ],
  "reviews": [
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 4,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "These fit fine, made for people with skinny legs. My thicker legs/ muscular have a squishy time.",
      "title": "Four Stars",
      "username": "PLAINJANE"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 1,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "A cheap boot that lasted only a few weeks on our property. Mild use and these have already split the seems. Not recommended for anyone. Spend more money and get a good pair.",
      "title": "Cheaply made boot that doesnt last.",
      "username": "Brandon"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Excellent quality and very very cute rain boots. Very comfortable - come on rain!!!",
      "title": "Quality and comfort and cute too!",
      "username": "Bonnie Hallman"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 1,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Cracked within a few months where it bends for your toes. I've owned a couple of these. the same happened for both as well as the buckle breaking. I'm finally done with it. Will just spend a hit more for hunter boots.",
      "title": "Cracked within a few months.",
      "username": "Chiqui Mancini"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Nice boots. A bit loose for my girl friends skinny legs.",
      "title": "Five Stars",
      "username": "Etienne"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "very fashionable as well as comfortable",
      "title": "Five Stars",
      "username": "jahoody"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "These arrived very fast and are great.",
      "title": "Five Stars",
      "username": "Linda Findlay-Palmer"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 3,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Decent boots but one of the buckles broke a day after I received them.",
      "title": "Three Stars",
      "username": "Sheena Cormier"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Really like them! Great grips for working on the farm and tall enough too! Found their sizing a little bit smaller than I expected, but still fits good because it has a wide toe area. Now I can farm in style and with any color!",
      "title": "really like them",
      "username": "Marie"
    },
    {
      "dateAdded": "2015-08-17T18:43:00Z",
      "dateSeen": [
        "2015-08-15T00:00:00Z"
      ],
      "rating": 5,
      "sourceURLs": [
        "http://www.amazon.ca/product-reviews/B00MKHSLP2"
      ],
      "text": "Fits perfectly. Love the colour.",
      "title": "Love the colour",
      "username": "N.K."
    }
  ],
  "sourceURLs": [
    "https://www.amazon.ca/Brand-Womens-Rubber-Boots-Bottes/dp/B00OL26D4K",
    "http://www.amazon.ca/Brand-Womens-Rubber-Boots-Bottes/dp/B00OL26D4K",
    "http://www.amazon.ca/product-reviews/B00MKHSLP2"
  ],
  "weight": "227 g",
  "id": "AVnjo8-lD1GB75FR6uL3"
}

Was this page helpful?

Last updated 1 week ago

Built with Documentation.AI