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 |
- 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.
- 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
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 |
Last modified 4mo ago