Smartrr

Smartrr ETL connector for data replication

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 |

Sign in to Daton
Select Smartrr from Integrations page
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your Smartrr apikey
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration

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
Users would be able to edit/pause/re-activate/delete integration anytime
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

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

Table of Contents

Snapshot Integrate Smartrr with Daton Workflow