Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Bol Retail v2

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        Need help with something?

        Talk to data expert

        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

        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. Provide Client ID and Client Secret in the next step. Follow this link to get client credentials
        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

        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

        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
        e-commerce online shopping

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • SugarCRM

        Table of Contents

        Snapshot Tables/APIs supported Integrate Bol Retail with Daton Workflow Bol Retail Data

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand