# Reviewmonitoring

## **Locating the API Key**

1. Login to Reviewmonitoring.
2. Click the API button located at the top of your screen.

![To generate new api key click the generate button](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FndqtTYo9j0nduIh1Bz3B%2Fimage.png?alt=media\&token=56a2b7fe-7d7d-4b64-ab44-581e78d0832c)

## **Snapshot**

| **Features**                    | **Details** |
| ------------------------------- | ----------- |
| Release Status                  | Released    |
| Source API Version              | v1          |
| Table Selection                 | Yes         |
| Column Selection                | Yes         |
| Edit Integrations               | Yes         |
| Replication Type Selection      | No          |
| Authentication Parameters       | API Key     |
| Replication Type                | Full Load   |
| Replication Key                 | N/A         |
| Suggested Replication Frequency | 12 hr       |

## **Reviewmonitoring Tables**

Source documentation: <https://help.reviewmonitoring.com/en/articles/5448444-api>

1. **Products**\
   \&#xNAN;*Purpose:* To get data for all the listed products.\
   *Replication:* Full Load\
   \
   **Fields**

   | **Field name** | **Datatype** |
   | -------------- | ------------ |
   | id             | STRING       |
   | title          | STRING       |

   \\

2. **Reviews** \
   \&#xNAN;*Purpose:* To get all the reviews.\
   *Replication:* Full Load\
   *Replication Key:* After historical sync (loading all the available data), it'll only load data for the last 1 month to save you rows.\
   \
   **Fields**\
   Load more

   | **Field name**                           | **Datatype** |
   | ---------------------------------------- | ------------ |
   | Product                                  | STRING       |
   | Rating                                   | STRING       |
   | Source                                   | STRING       |
   | Review\_Status                           | STRING       |
   | Review\_Status\_Date                     | DATE         |
   | Review\_Posted\_Date                     | DATE         |
   | Reviewer\_Name                           | STRING       |
   | Reviewer\_ID                             | STRING       |
   | Review                                   | STRING       |
   | Review\_ID                               | STRING       |
   | ReviewTranslated                         | STRING       |
   | Title                                    | STRING       |
   | Syndicated                               | STRING       |
   | Incentive\_Program                       | STRING       |
   | Price                                    | STRING       |
   | Verified\_Review                         | STRING       |
   | Size                                     | STRING       |
   | Color                                    | STRING       |
   | Edition                                  | STRING       |
   | Style                                    | STRING       |
   | Other\_Attributes                        | STRING       |
   | Helpful\_Votes                           | INTEGER      |
   | Top\_Contributor                         | STRING       |
   | MediaBrace\_Picture\_slash\_Video\_Brace | STRING       |
   | Displayed\_Rating                        | STRING       |
   | Model                                    | STRING       |
   | ASIN                                     | STRING       |
   | ASIN\_Reviews\_Link                      | STRING       |
   | SKU                                      | STRING       |
   | Category                                 | STRING       |
   | Tag                                      | STRING       |
   | NPS                                      | STRING       |
   | Competitor                               | STRING       |
   | Sentiment\_Score                         | STRING       |
   | Sentiment\_Magnitude                     | STRING       |
   | Status                                   | STRING       |
   | Replied\_To                              | STRING       |
   | Internal\_Comments                       | STRING       |
   | Keyword\_Tagging                         | STRING       |
   | Replied\_User                            | STRING       |
   | Replied\_Date                            | STRING       |
   | Permalink                                | STRING       |
   | System\_ID                               | STRING       |
   | Negative\_Sentiment\_Keywords            | STRING       |
   | Positive\_Sentiment\_Keywords            | STRING       |
