Schema Information

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

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: Key based replication

Replication Key: asin

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