Awtomic

Awtomic ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Awtomic API Key
Replication Type	Key based Replication Full Replication
Replication Key	DATE NA
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Subscriptions_Peel	Subscriptions_Billing_Attempts

Integrate Awtomic with Daton

1. Signin to Daton

2. Select Impact 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 Awtomic API Key.

5. After providing the details to authorize Daton to periodically extract data from Impact.

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

7. Then select all required fields for each table

8. 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

Awtomic Data

Subscriptions_Peel

Purpose: Returns a list of subscriptions contracts

Source API Documentation: https://docs.google.com/document/d/1E46PcMP4WcMNWbkQpxP5mzy8eLYdGJU_sHA3RbFLNM8/edit#heading=h.bpgx5l1d9fg7

Replication: Full-Based Replication

Replication Key: Date

Fields

FullName	DataType
__typename	STRING
gid	STRING
customer	RECORD
batchingconflict	BOOLEAN
billingintervalbillingcount	STRING
createdat	TIMESTAMP
currencycode	STRING
customattributes	RECORD
deliveryintervaldeliverycount	STRING
deliverypricecurrencycode	STRING
discounts	RECORD
hasprepaidlines	BOOLEAN
ignoreshopinventorysettings	BOOLEAN
isbilling	BOOLEAN
isbillingscheduled	BOOLEAN
isindunning	BOOLEAN
isupdating	BOOLEAN
originordergid	STRING
pausedates	RECORD
retryingmanually	BOOLEAN
status	STRING
updatedat	TIMESTAMP
updatingpaymentmethod	BOOLEAN
containsgift	BOOLEAN
customerpaymentmethod	RECORD
deliverymethod	RECORD
linescount	NUMERIC
billingattemptscount	NUMERIC
shopifyupdatedat	TIMESTAMP
canceldate	TIMESTAMP
cancelreason	STRING
originalcreatedat	TIMESTAMP
nextbillingdate	TIMESTAMP
nextbillingupcomingdate	TIMESTAMP
canceldetails	STRING
deliverypriceamount	NUMERIC
batchingconfiguration	RECORD
billingpolicymaxcycles	NUMERIC
customer.__typename	STRING
customer.gid	STRING
customer.email	STRING
customer.firstname	STRING
customer.lastname	STRING
customer.displayname	STRING
customattributes.key	STRING
customattributes.value	STRING
customattributes.__typename	STRING
discounts.id	STRING
discounts.type	STRING
discounts.title	STRING
discounts.value	RECORD
discounts.value.amount	RECORD
discounts.value.amount.amount	STRING
discounts.value.amount.__typename	STRING
discounts.value.amount.currencycode	STRING
discounts.value.__typename	STRING
discounts.value.appliesoneachitem	BOOLEAN
discounts.value.percentage	NUMERIC
discounts.__typename	STRING
discounts.targettype	STRING
discounts.usagecount	NUMERIC
discounts.entitledlines	RECORD
discounts.entitledlines.all	BOOLEAN
discounts.entitledlines.lines	RECORD
discounts.entitledlines.lines.__typename	STRING
discounts.entitledlines.lines.edges	RECORD
discounts.entitledlines.lines.edges.node	RECORD
discounts.entitledlines.lines.edges.node.id	STRING
discounts.entitledlines.lines.edges.node.__typename	STRING
discounts.entitledlines.lines.edges.__typename	STRING
discounts.entitledlines.__typename	STRING
discounts.recurringcyclelimit	NUMERIC
pausedates.date	TIMESTAMP
pausedates.info	STRING
customerpaymentmethod.id	STRING
customerpaymentmethod.revokedat	STRING
customerpaymentmethod.instrument	RECORD
customerpaymentmethod.instrument.brand	STRING
customerpaymentmethod.instrument.__typename	STRING
customerpaymentmethod.instrument.expiryyear	STRING
customerpaymentmethod.instrument.lastdigits	STRING
customerpaymentmethod.instrument.expirymonth	STRING
customerpaymentmethod.instrument.billingaddress	RECORD
customerpaymentmethod.instrument.billingaddress.zip	STRING
customerpaymentmethod.instrument.billingaddress.city	STRING
customerpaymentmethod.instrument.billingaddress.country	STRING
customerpaymentmethod.instrument.billingaddress.address1	STRING
customerpaymentmethod.instrument.billingaddress.province	STRING
customerpaymentmethod.instrument.billingaddress.countrycode	STRING
customerpaymentmethod.instrument.billingaddress.provincecode	STRING
deliverymethod.address	RECORD
deliverymethod.address.zip	STRING
deliverymethod.address.city	STRING
deliverymethod.address.name	STRING
deliverymethod.address.phone	STRING
deliverymethod.address.country	STRING
deliverymethod.address.address1	STRING
deliverymethod.address.address2	STRING
deliverymethod.address.province	STRING
deliverymethod.address.countrycode	STRING
deliverymethod.address.provincecode	STRING
deliverymethod.shippingoptions	RECORD
deliverymethod.shippingoptions.code	STRING
deliverymethod.shippingoptions.description	STRING
deliverymethod.shippingoptions.presentmenttitle	STRING
batchingconfiguration.anchormonth	RECORD
batchingconfiguration.anchormonth.values	STRING
batchingconfiguration.anchor	STRING
batchingconfiguration.minimumdaysbetweenorders	NUMERIC

Subscriptions_Billing_Attempts

Purpose: Returns a list of billing attempts

Source API Documentation: https://docs.google.com/document/d/1E46PcMP4WcMNWbkQpxP5mzy8eLYdGJU_sHA3RbFLNM8/edit#heading=h.bpgx5l1d9fg7

Replication: Full-Based Replication

Replication Key: Date

Fields

FullName	DataType
__typename	STRING
gid	STRING
amount	NUMERIC
completedat	TIMESTAMP
createdat	TIMESTAMP
currencycode	STRING
ordergid	STRING
ordername	STRING
ready	BOOLEAN
retry	BOOLEAN
status	STRING
subscriptioncontractgid	STRING
retriescount	NUMERIC
updatedat	TIMESTAMP
errorcode	STRING
errormessage	STRING