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

Last updated