Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Awtomic_v2 connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Awtomic_v2 connector and the associated fields and tables.
Tables/APIs
- Subscriptions_Peel
- Subscriptions_Billing_Attempts
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 |
