Skubana
Skubana ETL connector for data replication
Snapshot
Features
Details
Release Status
Released
Source API Version
v1.1
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Skubana access token
Replication Type
Key based Replication
Replication Key
DATE NA
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
Orders
Returns
Integrate Impact with Daton
Signin to Daton
Select Impact 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 Skubana access token.
After providing the details to authorize Daton to periodically extract data from Impact.
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.
Workflow
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
Skubana Data
Orders
Purpose: Retrieve a list of all orders
Source API Documentation: https://developer.extensiv.com/pages/order-manager.html#tag/Order/operation/getOrdersUsingGET_1
Replication: Key-Based Replication
Replication Key: LastRunTime
Fields
orderId
NUMERIC
orderNumber
STRING
billDutiesToPayor
BOOLEAN
confirmationCost
RECORD
containsAlcohol
BOOLEAN
containsDryIce
BOOLEAN
createdDate
TIMESTAMP
currency
STRING
customer
RECORD
customField1
STRING
customsDeclarationType
STRING
deliveryConfirmation
STRING
discount
RECORD
doNotPrepayPostage
BOOLEAN
dryIceWeight
NUMERIC
external
BOOLEAN
fulfillmentSource
RECORD
gift
BOOLEAN
height
NUMERIC
holdUntilDate
TIMESTAMP
includeReturnLabel
BOOLEAN
insuranceCost
RECORD
insuranceProvider
STRING
insuredValue
RECORD
labels
RECORD
length
NUMERIC
modifiedDate
TIMESTAMP
nonMachinable
BOOLEAN
orderDate
TIMESTAMP
orderItems
RECORD
orderStatus
STRING
orderTotal
RECORD
releaseWithoutSignature
BOOLEAN
requestedShippingService
STRING
salesChannel
RECORD
saturdayDelivery
BOOLEAN
shipEmail
STRING
shipMethod
RECORD
shipName
STRING
shippingCost
RECORD
shipAddress1
STRING
shipCity
STRING
shipState
STRING
shipZipCode
STRING
shipCountry
STRING
shipPhone
STRING
showPostage
BOOLEAN
unresolvedStatus
STRING
weight
NUMERIC
width
NUMERIC
orderType
STRING
orderItemTotal
RECORD
suppressChannelUpdate
BOOLEAN
fraudAnalysis
STRING
addressType
STRING
internationalNonDeliveryAction
STRING
subscription
BOOLEAN
pos
BOOLEAN
customShipBillingOption
STRING
amountPaid
RECORD
notesFromBuyer
STRING
paymentDate
TIMESTAMP
shipAddress2
STRING
shipment
RECORD
shipDate
TIMESTAMP
shipCompany
STRING
giftMessage
STRING
relatedOrderIds
STRING
cancelReason
RECORD
shipments
RECORD
internalNotes
STRING
customField2
STRING
customField3
STRING
notesToBuyer
STRING
shipAddress3
STRING
Returns
Purpose: Retrieve a list of all RMAs
Source API Documentation: https://documentation.skubana.com/pages/order-manager.html#tag/Purchase-Order/operation/removePurchaseOrderMilestoneUsingDELETE
Replication: Key-Based Replication
Replication Key: LastRunTime
rmaid
NUMERIC
shipmentid
NUMERIC
rmanumber
STRING
weight
NUMERIC
height
NUMERIC
width
NUMERIC
length
NUMERIC
insuranceprovider
STRING
insuredvalue
RECORD
insurancecost
RECORD
deliveryconfirmation
STRING
confirmationcost
RECORD
forwardtoemail
STRING
notes
STRING
items
RECORD
returnslocation
RECORD
issuedate
NUMERIC
instorereturn
BOOLEAN
items.losstoseller
RECORD
items.rmaorderitem
RECORD
items.rmaorderitem.product
RECORD
returnslocation.address
RECORD
Last updated