Core APIs
...
Product Data API
Reference

CSV Fields

1min

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

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 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