--- title: CSV Fields slug: rainforestapi/product-data-api/reference/csv-fields docTags: createdAt: 2024-07-30T12:48:41.129Z --- # CSV Fields Reference Rainforest API can return data in CSV format by specifying the `output=csv` request parameter. When setting `output=csv` the `csv_fields` parameter determines the fields to include in the CSV result. CSV fields should be specified as a comma seperated list of field names, with **nested fields being expressed in dot notation** . Here's an example of the `csv_fields` parameter: `csv_fields=` Below is a full list of all of the supported CSV Fields shown under their group. | *`Field Group`* | *`Fields in Group`* | | ------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | *`request`* | `type` `url` `page` `max_page` `include_summarization_attributes` `asin` `gtin` `skip_gtin_cache` `seller_id` `amazon_domain` `sort_by` `search_term` `category_id` `question_id` `offers_prime` `offers_free_shipping` `offers_condition_new` `offers_condition_used_acceptable` `offers_condition_used_like_new` `offers_condition_used_very_good` `offers_condition_used_good` `reviewer_type` `review_stars` `review_formats` `review_media_type` `associate_id` `offer_id` `customer_location` `reviewer_profile_pages` `custom_id` `format_id` `store_id` `bestseller_rank` `sales_estimation_category` `wishlist_id` `wishlist_filter` | | *`request_metadata`* | `created_at` `processed_at` `total_time_taken` | | *`wishlist_results`* | `position` `title` `asin` `link` `image` `rating` `ratings_total` `comments` `priority` `requested_count` `purchased_count` `price.currency` `price.value` `added_date.raw` `added_date.utc` `next_page_token` | | *`product`* | `title` `brand` `bestsellers_rank.category` `bestsellers_rank.rank` `bestsellers_rank.link` `bestsellers_rank_flat` `weight` `author.name` `author.link` `format` `shipping_weight` `dimensions` `asin` `link` `amazons_choice.keywords` `amazons_choice.link` `kindle_unlimited` `audible_sample` `proposition_65_warning` `model_number` `has_coupon` `sub_title.text` `sub_title.link` `rating` `description` `ratings_total` `reviews_total` `delivery_message` `main_image.link` `runtime` `editorial_reviews_flat` `categories` `categories_flat` `images.link` `images_count` `images_flat` `videos.link` `videos_count` `videos_flat` `publication_date` `has_360_view` `coupon_text` `first_available.raw` `first_available.utc` `feature_bullets_flat` `feature_bullets_count` `specifications_flat` `book_description` `additional_details_flat` `buybox_winner.new_offers_count` `buybox_winner.new_offers_from.currency` `buybox_winner.new_offers_from.value` `buybox_winner.new_offers_from.raw` `buybox_winner.used_offers_count` `buybox_winner.used_offers_from.currency` `buybox_winner.used_offers_from.value` `buybox_winner.used_offers_from.raw` `buybox_winner.mixed_offers_count` `buybox_winner.mixed_offers_from.currency` `buybox_winner.mixed_offers_from.value` `buybox_winner.mixed_offers_from.raw` `buybox_winner.is_prime` `buybox_winner.availability.type` `buybox_winner.availability.raw` `buybox_winner.availability.dispatch_days` `buybox_winner.fulfillment.type` `buybox_winner.fulfillment.is_sold_by_amazon` `buybox_winner.fulfillment.is_fulfilled_by_amazon` `buybox_winner.fulfillment.is_fulfilled_by_third_party` `buybox_winner.fulfillment.is_sold_by_third_party` `buybox_winner.fulfillment.third_party_seller.name` `buybox_winner.fulfillment.third_party_seller.link` `buybox_winner.fulfillment.standard_delivery.date` `buybox_winner.fulfillment.standard_delivery.name` `buybox_winner.fulfillment.fastest_delivery.date` `buybox_winner.fulfillment.fastest_delivery.name` `buybox_winner.price.currency` `buybox_winner.price.value` `buybox_winner.price.raw` `buybox_winner.minimum_order_quantity.value` `buybox_winner.minimum_order_quantity.hard_maximum` `buybox_winner.maximum_order_quantity.value` `buybox_winner.maximum_order_quantity.hard_maximum` `buybox_winner.amazon_discount.currency` `buybox_winner.amazon_discount.value` `buybox_winner.amazon_discount.raw` `buybox_winner.rrp.currency` `buybox_winner.rrp.value` `buybox_winner.save.currency` `buybox_winner.save.value` `buybox_winner.shipping.currency` `buybox_winner.shipping.value` `buybox_winner.unqualified_buy_box` `add_on_item.is_add_on_item` `more_buying_choices.price.currency` `more_buying_choices.price.value` `more_buying_choices.seller_name` `more_buying_choices.seller_link` `more_buying_choices.free_shipping` `more_buying_choices.position` `a_plus_content.has_a_plus_content` `a_plus_content.third_party` `a_plus_content.company_logo` `a_plus_content.company_description_text` `a_plus_content.body` `a_plus_content.body_text` `also_viewed.title` `also_viewed.link` `also_viewed.asin` `also_viewed.image` `also_viewed.rating` `also_viewed.ratings_total` `also_viewed.is_prime` `also_viewed.price.currency` `also_viewed.price.value` `also_bought.title` `also_bought.link` `also_bought.asin` `also_bought.image` `also_bought.rating` `also_bought.ratings_total` `also_bought.is_prime` `also_bought.price.currency` `also_bought.price.value` `view_to_purchase.title` `view_to_purchase.link` `view_to_purchase.asin` `view_to_purchase.image` `view_to_purchase.rating` `view_to_purchase.ratings_total` `view_to_purchase.is_prime` `view_to_purchase.price.currency` `view_to_purchase.price.value` `sponsored_products.title` `sponsored_products.link` `sponsored_products.asin` `sponsored_products.image` `sponsored_products.rating` `sponsored_products.ratings_total` `sponsored_products.is_prime` `sponsored_products.price.currency` `sponsored_products.price.value` `frequently_bought_together.products.asin` `frequently_bought_together.products.title` `frequently_bought_together.products.link` `frequently_bought_together.products.price.currency` `frequently_bought_together.products.price.value` `variant_asins_flat` `energy_efficiency.rating` `energy_efficiency.rating_image` `energy_efficiency.product_fiche_image` `variants_flat` `publisher` `ingredients` `ingredients_flat` `diet_type` `diet_type_flat` | | *`reviews`* | `summary.rating` `summary.ratings_total` `summary.reviews_total` `summary.reviews_positive` `summary.reviews_critical` `product.title` `product.asin` `product.link` `product.image` `reviews.id` `reviews.title` `reviews.body` `reviews.rating` `reviews.comments` `reviews.verified_purchase` `reviews.attributes_flat` `reviews.helpful_votes` `reviews.date.raw` `reviews.date.utc` `reviews.profile.name` `reviews.profile.link` `reviews.profile.id` `pagination.current_page` `pagination.total_pages` `pagination.total_results` | | *`author_page`* | `author.name` `author.image` `author.biography` `titles.name` `titles.link` `titles.is_bestseller` `titles.release_date` `titles.rating` `titles.price.name` `titles.price.raw` `titles.price.symbol` `titles.price.value` `titles.price.currency` | | *`bestsellers`* | `rank` `position` `title` `sub_title.text` `sub_title.link` `variant` `asin` `link` `image` `rating` `ratings_total` `price.currency` `price.value` `current_category.name` `current_category.link` `current_category.id` `parent_category.name` `parent_category.link` `parent_category.id` `pagination.current_page` `pagination.total_pages` `bestsellers_info.title` `bestsellers_info.current_category.name` `bestsellers_info.current_category.link` `bestsellers_info.current_category.id` `bestsellers_info.parent_category.name` `bestsellers_info.parent_category.link` `bestsellers_info.parent_category.id` | | *`search_results`* | `position` `title` `asin` `link` `image` `rating` `ratings_total` `is_prime` `is_carousel` `sponsored` `author.name` `author.link` `price.currency` `price.value` `availability.raw` `page` `add_on_item.is_add_on_item` `delivery.price.currency` `delivery.price.value` `delivery.price.is_free` `delivery.price.raw` `recent_sales` `pagination.current_page` `pagination.total_pages` `pagination.total_results` | | *`category_results`* | `position` `title` `asin` `link` `image` `rating` `ratings_total` `is_prime` `sponsored` `price.currency` `price.value` `page` `pagination.current_page` `pagination.total_pages` `pagination.total_results` | | *`deals_results`* | `position` `title` `asin` `link` `image` `rating` `ratings_total` `is_prime` `sponsored` `price.currency` `price.value` `pagination.current_page` `pagination.total_pages` `pagination.total_results` | | *`offers`* | `is_prime` `offer_id` `offer_asin` `buybox_winner` `price.currency` `price.value` `minimum_order_quantity.value` `maximum_order_quantity.value` `import_fee.currency` `import_fee.value` `condition.is_new` `condition.title` `condition.comments` `delivery.fulfilled_by_amazon` `delivery.shipped_from_outside_country` `delivery.price.currency` `delivery.price.value` `delivery.price.is_free` `seller.name` `seller.id` `seller.link` `seller.image` `seller.rating` `seller.ratings_total` `seller.ratings_total_percentage` `pagination.current_page` `pagination.total_pages` `pagination.total_results` | | *`stock_estimation`* | `stock_level` `min_quantity` `is_prime` `in_stock` `message` `availability_message` `price.currency` `price.value` `seller.name` `seller.id` `seller.link` `offer_id` `requires_login` `has_stock_estimation` | | *`also_bought`* | `asin` `title` `rating` `ratings_total` `link` `image` `price.currency` `price.value` | | *`shop_by_look`* | `position` `asin` `title` `rating` `ratings_total` `link` `is_prime` `image` `price.currency` `price.value` | | *`seller_profile`* | `seller_details.name` `seller_details.store_link` `seller_details.logo` `seller_details.phone` `seller_details.rating` `seller_details.ratings_total` `seller_details.ratings_total_percentage` `seller_details.detailed_information` `feedback_summary.thirty_days.positive_percent` `feedback_summary.thirty_days.neutral_percent` `feedback_summary.thirty_days.negative_percent` `feedback_summary.thirty_days.count` `feedback_summary.ninety_days.positive_percent` `feedback_summary.ninety_days.neutral_percent` `feedback_summary.ninety_days.negative_percent` `feedback_summary.ninety_days.count` `feedback_summary.twelve_months.positive_percent` `feedback_summary.twelve_months.neutral_percent` `feedback_summary.twelve_months.negative_percent` `feedback_summary.twelve_months.count` `feedback_summary.lifetime.positive_percent` `feedback_summary.lifetime.neutral_percent` `feedback_summary.lifetime.negative_percent` `feedback_summary.lifetime.count` | | *`seller_products`* | `position` `position_overall` `title` `asin` `link` `image` `rating` `ratings_total` `is_prime` `sponsored` `price.currency` `price.value` `page` `pagination.current_page` `pagination.total_pages` `pagination.total_results` | | *`seller_feedback`* | `position` `rater` `rating` `has_response` `body` `date.raw` `date.utc` | | *`reviewer_profile`* | `reviewer_details.name` `reviewer_details.description` `reviewer_details.location` `reviewer_details.occupation` `reviewer_details.rank` `reviewer_details.helpful_votes` `reviewer_details.hearts_count` `reviewer_details.idea_lists_count` `reviewer_details.reviews_count` `reviewer_details.social.facebook` `reviewer_details.social.twitter` `reviewer_details.social.pinterest` `reviewer_details.social.youtube` `reviewer_details.social.instagram` | | *`questions`* | `product.title` `product.asin` `product.link` `product.image` `questions.id` `questions.question` `questions.answer` `questions.link` `questions.helpful_votes` `questions.total_answers` `questions.date.utc` `questions.profile.name` `questions.profile.link` `questions.profile.id` `pagination.current_page` `pagination.total_pages` | | *`question_answers`* | `question.title` `question.date.raw` `question.date.utc` `product.title` `product.asin` `product.link` `product.image` `answers.id` `answers.answer` `answers.helpful_votes` `answers.helpful_votes_out_of` `answers.date.raw` `answers.date.utc` `answers.profile.name` `answers.profile.link` `answers.profile.id` `pagination.current_page` `pagination.total_pages` | | *`formats_editions`* | `formats_editions.position` `formats_editions.link` `formats_editions.asin` `formats_editions.title` `formats_editions.image` `formats_editions.rating` `formats_editions.ratings_total` `formats_editions.publication_date` `formats_editions.publisher` `formats_editions.edition` `formats_editions.format` `formats_editions.price.value` `formats_editions.price.currency` `formats_editions.price.symbol` `formats_editions.price.raw` `pagination.current_page` `pagination.has_next_page` | | *`review_comments`* | `review_comments.id` `review_comments.body` `review_comments.date.raw` `review_comments.date.utc` `review_comments.profile.name` `review_comments.profile.link` `review_comments.profile.id` | | *`autocomplete_results`* | `autocomplete_results.suggestion` `autocomplete_results.spelling_corrected` `autocomplete_results.type` | | *`asin_to_gtin_results`* | `asin_to_gtin_results.value` `asin_to_gtin_results.format` | | *`store_results`* | `position` `title` `asin` `link` `image` `rating` `ratings_total` `price.currency` `price.value` `page` `is_prime` | | *`charts_results`* | `position` `title` `asin` `weeks_on_chart` `author` `agent` `publisher` `link` `image` `rating` `ratings_total` `last_week_position` | | *`sales_estimation`* | `sales_estimation.monthly_sales_estimate` `sales_estimation.weekly_sales_estimate` `sales_estimation.bestseller_rank` |