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

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 Skubana access token.

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

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

NAME	DATATYPE
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

NAME	DATATYPE
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