Re:amaze

Re:amaze ETL connector for data replication

##Snapshot

Features	Details
Release Status	Released
Source API Version	2.0
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Reamaze brand name Reamaze login email Reamaze api token
Replication Type	Key based replication
Replication Key	lastRunDate
Suggested Replication Frequency	24 hrs

Tables/APIs Supported | --- | --- Volume | Staff ResponseTime | Tags

##Integrate Reamaze with Daton

1. Signin to Daton

2. Select reamaze from Integrations page

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later.

4. Provide your brandName, loginEmail and api token.

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration.

##Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

##Reamaze Data ####Volume Purpose: Returns a daily volume count.

Source API Documentation : https://www.reamaze.com/api/get_reports_volume

Replication: Key-Based Replication

Replication Key: lastRunDate

#####Fields

Name	Target Datatype
date	DATE
value	INTEGER

####ResponseTime Purpose: Returns a daily response time metric and a response times summary object. Response times are reported in seconds.

Source API Documentation : https://www.reamaze.com/api/get_reports_response_time

Replication: Key-Based Replication

Replication Key: lastRunDate

#####Fields

Name	Target Datatype
response_times	RECORD
summary	RECORD
start_date	DATE
end_date	DATE

####Staff Purpose: Returns a staff report summarizing staff metrics.

Source API Documentation : https://www.reamaze.com/api/get_reports_staff

Replication: Key-Based Replication

Replication Key: lastRunDate

#####Fields

Name	Target Datatype
name	STRING
response_count	INTEGER
archived_count	INTEGER
satisfaction_average	STRING
appreciations_count	INTEGER
responses_trend	RECORD
response_time_seconds	NUMERIC
start_date	DATE
end_date	DATE

####Tags Purpose: Returns a tag report summarizing tag usage

Source API Documentation : https://www.reamaze.com/api/get_reports_tags

Replication: Key-Based Replication

Replication Key: lastRunDate

#####Fields

Name	Target Datatype
tags	RECORD
start_date	DATE
end_date	DATE