Brightpearl

Version 0.0.0

πŸ“˜

Check out the Brightpearl API docs for more information.

Set up


  1. Before setting up a Brightpearl connector, please forward us your account code (e.g. mycompany), as we will need to add it to our Brightpearl application, for access to be granted.
  2. Once we have added your account code to our app, you can go to the App Store in Brightpearl and you can make sure the kleene-connector app is installed

To then set up the Brightpearl connector Source in Kleene, you will need

  • your sign in credentials for Brightpearl (email & password)
  • the data centre you are on (e.g. euw1)
  • your account code (e.g. mycompany)

It is important to fill in the data centre and account code before clicking "Sign in with Brightpearl" on the Source setup page in Kleene.

In case you are unsure of the values, please reach out to your Brightpearl representative for assistance.

Features


FeatureSupportNotes
Backfillβœ…All time
Incrementalβœ…Supported on: Contact; Order; Sales order; Brightpearl Category; Product
API reliability🟠Some unexpected behaviour between endpoints for same entities (e.g. instance of null value for updatedOn in SEARCH endpoint, but existing updatedOn value on GET endpoint for the same Contact)

Reports detail


⬇️ ReportπŸ”‘ Incremental keyπŸ”‘ Primary keyπŸ“„ Link to API endpoint
Payment MethodN/AIDPayment Method
Postal Address (Billing address)N/AADDRESS_IDPostal Address
Postal Address (Default Address)N/AADDRESS_IDPostal Address
Postal Address (Delivery Address)N/AADDRESS_IDPostal Address
CompanyN/AIDCompany
ContactUPDATED_ONCONTACT_IDContact
OrderUPDATED_ONIDOrder
Custom FieldN/AN/ACustom Field
Order Shipping StatusN/AIDOrder Shipping Status
Order StatusN/ASTATUS_IDOrder Status
Sales OrderUPDATED_ONIDSales Order
BrandN/AIDBrand
Brightpearl CategoryUPDATED_ONIDBrightpearl Category
ProductUPDATED_ONIDProduct
ChannelN/AIDChannel
Price ListN/AIDPrice List
Product Custom FieldN/AN/AProduct Custom Field
Product PriceN/AN/AProduct Price
Product TypeN/AIDProduct Type
Goods-In NoteN/AGOODS_NOTE_IDGoods-In Note
Goods-Out NoteN/AGOODS_NOTE_IDGoods-Out Note
Product AvailabilityN/APRODUCT_IDProduct Availability
Shipping MethodN/AIDShipping Method
Stock CorrectionN/AWAREHOUSE_ID,GOODS_NOTE_IDStock Correction

Limitations


🚧

Failure for reports with no data

The connector will fail for extract runs where no data is returned (showing a similar log):

You can identify these expected failures by the mentioning of no results in the log message

πŸ“˜

Duplicates

The connector is expected to create duplicates for incremental runs on the reports that support incremental. You will need to de-duplicate in a Transform layer.