Schema Information of Rainforest Connector

This topic provides a structured reference to assist you in working with Daton's Rainforest connector and the associated fields and tables.

Need help with something?

Talk to data expert

Tables/APIs

The following is the list of tables or APIs associated with the Rainforest connector:

seller_products

Retrieves seller product listing results for a single seller on Amazon - the seller is specified using the seller_id and amazon_domain parameters.Source API documentation:

  1.  Parameters: https://www.rainforestapi.com/docs/product-data-api/parameters/seller-products
  2.  Results: https://www.rainforestapi.com/docs/product-data-api/results/seller-products

Replication type: Full Load​

Field Name
Data Type
position
NUMERIC
title
STRING
asin
STRING
link
STRING
recent_sales
STRING
image
STRING
unit_price
STRING
is_prime
BOOLEAN
rating
NUMERIC
ratings_total
NUMERIC
is_small_business
BOOLEAN
availability
RECORD
categories
RECORD
coupon
RECORD
price
RECORD
prices
RECORD

reviews

Rainforest API will return all Customer Reviews for the product specified in either the asin and amazon_domain parameters or the url parameter. Reviews are retrieved from the customer reviews page for a single product on Amazon.

Source API documentation:

  1. Parameters: https://www.rainforestapi.com/docs/product-data-api/parameters/reviews
  2. Results: https://www.rainforestapi.com/docs/product-data-api/results/reviews

Replication type: Full Load​

FIELDS

Field Name
Data Type
asin
STRING
request_info
RECORD
request_parameters
RECORD
request_metadata
RECORD
product
RECORD
summary
RECORD
top_positive
RECORD
top_critical
RECORD
reviews
RECORD
pagination
RECORD

products

The Product API returns details of a single product on Amazon when specified using either the asin and amazon_domain parameters or the url parameter containing a link to an Amazon product page.

Source API documentation:

  1. Parameters: Product Parameters | Rainforest API
  2. Results: Product Results | Rainforest API

Replication type: Full Load​

FIELDS

Field Name Data Type
title STRING
link STRING
sub_title RECORD
image STRING
asin STRING

seller_profile

The Seller Profile API returns seller profile details for a single seller on Amazon when specified using either the seller_id and amazon_domain parameters or the url parameter containing a link to an Amazon seller profile page.

Source API documentation:

  1. Parameters: Seller Profile Parameters | Rainforest API
  2. Results: Seller Profile Results | Rainforest API

Replication type: Full Load​

FIELDS

Field Name Data Type
request_info RECORD
request_parameters RECORD
request_metadata RECORD
seller_products RECORD
refinements RECORD
pagination RECORD

Questions

The Questions API returns customer Questions & Answers for a single product on Amazon when specified using either the asin and amazon_domain parameters or the url parameter containing a link to an Amazon product page.

Source API documentation:

  1. Parameters: Questions Parameters | Rainforest API 
  2. Results: Questions Results | Rainforest API

Replication type: Full Load​

FIELDS

Field Name Data Type
request_info RECORD
request_parameters RECORD
request_metadata RECORD
product RECORD
questions RECORD
pagination RECORD