Skip to content

Data Sources

We have the following data sources:

  • logic4
  • Channel Engine
  • BOL API

logic4

  • Logic4 is an ERP specialized for online merchants

  • It is a SaaS solution, but has a fat client.

  • prf uses it to manage product, orders, invoices, etc.

  • They have a REST API

Registration

This requires lots of secrets, passwords and keys. See planio for details.

There is also an encoding required, namely encoding _ with two __

See here for details: https://api.logic4server.nl/oauth2

Data

Technology

See Postman (powerpartnersswiss@gmail.com) for some examples.

API General Documentation

https://api.logic4server.nl/Home

Reference Information

https://api.logic4server.nl/swagger/index.html

(top right allows you to select the api version!)

Channel Engine

  • Channel Engine is a platform to bridge between a seller (or his ERP system) and different sales channels.

  • For example, #prf uses logic4, and sells via Bol, Amazon, and others.

    • They can then manage the product catalog in logic 4
    • Channel engine proposes optimal price, per channel
    • The user can then push to various channels, either automatically or at the click of a button
    • Channel engine collects sales data from the channels and pushes back to the ERP (as orders and invoices)

  • They have a REST API

  • Documentation:

Registration

Data

Technology

API General Documentation

Reference Information

Bol

  • Bol is an online store, similar to amazon

  • Link: bol.nl, bol.be

  • They have a REST API, it's actually pretty nice!

Registration

They have a simplified OAuth2. We get an access token from secrets, but no refresh token is required.

Data

Unfortunately, BOL does not provide line-item details on the invoice data. If we call the invoice details, we get the same level of detail as is on the PDF, but not the same as in the Excel.

See here for the API: https://api.bol.com/retailer/public/Retailer-API/v7/functional/retailer-api/invoices.html#_retrieve_an_invoice_by_invoice_id

But what we would really like is this:

bol-excel.png

So, for a start, we are downloading Excels manually.

API General Documentation

https://api.bol.com/retailer/public/Retailer-API/index.html

Reference Information

https://api.bol.com/retailer/public/redoc/v7/retailer.html#operation/get-invoice-specification