# Schema Information

## 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](https://www.amazon.com/product-reviews/B073JYC4XM) 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 |

<br>