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 |
- 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.
- 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
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
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 |
Last modified 1mo ago