Visma Bouwsoft - Getting started in Peliqan

​

Contents

• Contents
• Visma Bouwsoft Data Pipeline
  • Before you connect
  • Approving Grant to Peliqan App
  • Connect Visma Bouwsoft
• Visma Bouwsoft data sync to a data warehouse
• Visma Bouwsoft writeback

​

Visma Bouwsoft Data Pipeline

​

Before you connect

• You need a Request ID
• Click the below link to get a Request ID and Request URL

​

Approving Grant to Peliqan App

• Once you receive the Request Url through the above link, Open the Request URL in browser.
• You will be redirected to Bouwsoft.
• On the Authentication window, Please provide your account Username and Password and login to your account.

• After successful authentication, please provide a unique device name (e.g. “Peliqan”). Click on Grant Access.

• Now the Grant has been accessed to our app to access your data on your behalf.

​

Connect Visma Bouwsoft

• Client Nr : Client Number present in Bouwsoft Username
• Request ID : Provided by Peliqan Support Team
• Start Date : Date to start sync from in YYYY-MM-DD fromat.

​

Visma Bouwsoft data sync to a data warehouse

​

Visma Bouwsoft writeback

visma_bouwsoft_api = pq.connect('Visma Bouwsoft')

# Add OrderLine to Order
OrderLine = {
    'orderid': 2483,
    'price_unit': 5.67,
    'quantity1': 15
}
result = visma_bouwsoft_api.add('OrderLine', OrderLine)
st.json(result)


# Create Order
Order = {
    'type': "FAKTUUR",
    'address_id': 0,
    'company_id': 2,
}
result = visma_bouwsoft_api.add('Order', Order)
st.json(result)