Bol Retail V2
Bol Retail ETL connector for data replication
Features | Details |
---|---|
Release Status | Released |
Source API Version | V8 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Client ID
Client Secret |
Replication Type | Full Replication
Key Based Incremental |
Replication Key | Date |
Suggested Replication Frequency | 1 hour |
Inventory | Invoice |
Orders | Replenishments |
Returns | Shipments |
Shipments Details | Invoice Line Items |
- 1.Sign in to Daton
- 2.Select BolRetail V2 from the list of Integrations
- 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.
- 5.Post successful authentication, you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.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
Purpose: This API is used to fetch a list of all inventories
Source API Documentation https://api.bol.com/retailer/public/redoc/v8/retailer.html#operation/get-inventory
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
ean | STRING |
bsku | STRING |
gradedStock | NUMERIC |
regularStock | NUMERIC |
title | STRING |
Purpose: This API is used to fetch a list of invoices
Source API Documentation https://api.bol.com/retailer/public/redoc/v8/retailer.html#operation/get-invoices
Replication: Key Based Incremental
Replication Key: period-start-date, period-end-date
Fields
Name | Data Type |
---|---|
invoiceId | STRING |
issueDate | NUMERIC |
invoicePeriod | RECORD |
invoiceType | STRING |
legalMonetaryTotal | RECORD |
invoiceMediaTypes | RECORD |
specificationMediaTypes | RECORD |
openAmount | NUMERIC |
Purpose: This API is used to fetch a list of all invoice line items
Source API Documentation https://api.bol.com/retailer/public/redoc/v8/retailer.html#operation/get-invoice-specification
Replication: Key Based Incremental
Replication Key: period-start-date, period-end-date
Name | Data Type |
---|---|
invoiceId | STRING |
id | STRING |
invoiceLineRef | STRING |
invoicedQuantity | RECORD |
item | RECORD |
lineExtensionAmount | RECORD |
price | RECORD |
taxTotal | RECORD |
Purpose: This API is used to fetch details of all orders for a retailer
Source API Documentation https://api.bol.com/retailer/public/redoc/v8/retailer.html#operation/get-orders
Replication: Key Based Incremental
Replication Key: latest-change-date
Fields
Name | Data Type |
---|---|
orderId | STRING |
pickupPoint | BOOLEAN |
orderPlacedDateTime | TIMESTAMP |
shipmentDetails | RECORD |
billingDetails | RECORD |
orderItems | RECORD |
Purpose: This API is used to fetch a list of replenishments
Source API Documentation https://api.bol.com/retailer/public/redoc/v8/retailer.html#operation/get-replenishments
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
replenishmentId | STRING |
reference | STRING |
creationDateTime | TIMESTAMP |
lines | RECORD |
Purpose: This API is used to fetch details of all returns
Source API Documentation https://api.bol.com/retailer/public/redoc/v8/retailer.html#operation/get-returns
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
returnId | STRING |
registrationDateTime | TIMESTAMP |
fulfilmentMethod | STRING |
returnItems | RECORD |
Purpose: This API is used to all the shipments
Source API Documentation https://api.bol.com/retailer/public/redoc/v8/retailer.html#operation/get-shipments
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
shipmentId | STRING |
shipmentDateTime | TIMESTAMP |
shipmentReference | STRING |
order | RECORD |
shipmentItems | RECORD |
transport | RECORD |
Purpose: This API is used to fetch all shipment details
Source API Documentation https://api.bol.com/retailer/public/redoc/v8/retailer.html#operation/get-shipment
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
shipmentId | STRING |
shipmentDateTime | TIMESTAMP |
shipmentReference | STRING |
pickupPoint | BOOLEAN |
order | RECORD |
shipmentDetails | RECORD |
billingDetails | RECORD |
shipmentItems | RECORD |
transport | RECORD |
Last modified 6mo ago