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

FullNameDataType

__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

FullNameDataType

__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 updated