Smartrr
Smartrr 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 | Smartrr api key |
Replication Type | Key based replication |
Replication Key | lastRunDate |
Suggested Replication Frequency | 24 hrs |
Tables/APIs Supported | --- | --- Orders | Customers Subscriptions |
##Integrate Smartrr with Daton
- 1.Sign in to Daton
- 2.Select Smartrr 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 Smartrr apikey
- 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
##Smartrr Data ####Orders Purpose: To get all the Orders.
Source API Documentation
Replication: Key-Based Replication
Replication Key: lastRunDate
#####Fields
Name | Target Datatype |
---|---|
createdDate | TIMESTAMP |
updatedDate | TIMESTAMP |
deletedAt | STRING |
id | STRING |
shopifyId | STRING |
receivedFromShopifyDate | TIMESTAMP |
shopifyUpdateDate | TIMESTAMP |
shopifyOrderLabel | STRING |
orderProcessedDate | TIMESTAMP |
shippingLineItems | RECORD |
taxLineItems | RECORD |
discountApplications | RECORD |
refundLineItems | RECORD |
refundOrderAdjustments | RECORD |
totalFromLineItems | STRING |
totalLineItemsDiscount | STRING |
totalLineItemsAfterDiscount | STRING |
totalShipping | STRING |
totalTax | STRING |
totalDiscount | STRING |
totalTip | STRING |
totalRefund | STRING |
totalBeforeDiscountsAndRefunds | STRING |
totalNetBeforeRefunds | STRING |
shopIncome | STRING |
totalNet | STRING |
totalOneTimeShopIncome | STRING |
totalSubscriptionShopIncome | STRING |
totalAddonShopIncome | STRING |
orderCurrency | STRING |
orderSource | STRING |
orderStatus | STRING |
financialStatus | STRING |
fulfillmentStatus | STRING |
trackingInfo | STRING |
deliveryLatitude | NUMERIC |
deliveryLongitude | NUMERIC |
deliveryProvinceCode | STRING |
deliveryCountryCode | STRING |
deliveryAddress | RECORD |
pmtMthJson | RECORD |
cancelReason | STRING |
cancelledAt | STRING |
items | RECORD |
custRel | RECORD |
sts | STRING |
####Customers Purpose: To get all the customers
Source API Documentation
Replication: Key-Based Replication
Replication Key: lastRunDate
#####Fields
Name | Target Datatype |
---|---|
createdDate | TIMESTAMP |
updatedDate | TIMESTAMP |
deletedAt | STRING |
id | STRING |
shopifyId | STRING |
receivedFromShopifyDate | TIMESTAMP |
shopifyUpdateDate | TIMESTAMP |
email | STRING |
phone | STRING |
inferredPhone | STRING |
firstName | STRING |
lastName | STRING |
role | STRING |
customerCurrency | STRING |
hasLoggedIn | BOOLEAN |
orderCount | INTEGER |
totalSpent | STRING |
####Subscriptions Purpose: To get all the subscriptions.
Source API Documentation
Replication: Key-Based Replication
Replication Key: lastRunDate
#####Fields
Name | Target Datatype |
---|---|
createdDate | TIMESTAMP |
updatedDate | TIMESTAMP |
deletedAt | STRING |
id | STRING |
shopifyId | STRING |
receivedFromShopifyDate | TIMESTAMP |
shopifyUpdateDate | TIMESTAMP |
nextBillingDate | TIMESTAMP |
cancelledAt | STRING |
purchaseStateStatus | STRING |
initialSubmissionDate | TIMESTAMP |
createdViaCustomerPortal | BOOLEAN |
isRepeatCustomer | BOOLEAN |
sellingPlanId | STRING |
discounts | STRING |
totalEstimatedTax | STRING |
totalFromLineItems | STRING |
totalLineItemsDiscount | STRING |
totalLineItemsAfterDiscount | STRING |
totalShipping | STRING |
totalShippingDiscount | STRING |
totalDiscount | STRING |
totalEstimatedNet | STRING |
currency | STRING |
shippingAddress | RECORD |
externalSubscriptionId | STRING |
externalSubscriptionType | STRING |
externalSubscriptionStatus | STRING |
originalExternalSubscriptionStatus | STRING |
custRel | RECORD |
schedule | RECORD |
stLineItems | RECORD |
Last modified 6mo ago