Bol Retail v2
Bol Retail v2
Bol Retail ETL connector for data replication
Snapshot
| 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 |
Tables/APIs supported
| Inventory | Invoice |
| Orders | Replenishments |
| Returns | Shipments |
| Shipments Details | Invoice Line Items |
Integrate Bol Retail with Daton
- Sign in to Daton
- Select BolRetail v2 from the list of Integrations
- Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide Client ID and Client Secret in the next step. Follow this link to get client credentials
- 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
Bol Retail Data
Inventory
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 |
Invoice
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 |
Invoice Line Items
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 |
Orders
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
| Name | Data Type |
| orderId | STRING |
| pickupPoint | BOOLEAN |
| orderPlacedDateTime | TIMESTAMP |
| shipmentDetails | RECORD |
| billingDetails | RECORD |
| orderItems | RECORD |
Replenishments
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 |
Returns
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 |
Shipments
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 |
Shipments Details
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 |