Teamleader is a cloud-based software platform designed to streamline project management, CRM, and invoicing for small to medium-sized businesses. By integrating various business processes into a single interface, Teamleader enhances productivity and simplifies workflow management.

This article provides an overview to get started with the Teamleader connector in Peliqan. Please contact support if you have any additional questions or remarks.

Contents

• Contents
• Connect
• Explore & Combine
• Activate
• Get custom fields for invoices, tasks etc.
• Custom pipeline to fetch all details (e.g. for subscriptions)
• Custom pipeline to fetch contact-company relations
• Need further help

Connect

In peliqan, go to Connections, click on Add new. Find Teamleader in the list and select it. Click on the Connect button. This will open Teamleader and allow you to authorize access for Peliqan. Once that is done, you will return to Peliqan.

Explore & Combine

Wait a few minutes for the data to start syncing. Now you can view your Teamleader data in tables in Peliqan’s built-in data warehouse (or in your own DWH if you connected e.g. SQL Server, Snowflake, Redshift or BigQuery).

Select “Explore” in the left navigation pane, expand “Data warehouse” in the left tree and click on Teamleader. All tables from Teamleader will now be shown.

You can explore the data in the gridview, and you can write SQL queries to transform the data and to combine the data from Teamleader with data from other sources.

Activate

You can use Peliqan’s low-code Python scripts to interact with Teamleader using the Teamleader API. With a single line of code, you can for example add or update a contact, company or invoice in Teamleader.

In Peliqan, click on “Build” in the left navigation pane. Now add a new “App” or Python script.

In the right pane, expand the “Connected SaaS APIs”, and expand Teamleader. You will now see the available functions to interact with Teamleader. Click on a function to insert it into your script.

Basic example to add a company in Teamleader:

teamleader_api = pq.connect('Teamleader')
company = {
    "name": "ACME",
    "website": "http://example.com"
}
teamleader_api.add('company', company)

Extended example to fetch a subscription, add a line item and update the subscription:

Get custom fields for invoices, tasks etc.

Example script to sync Teamleader custom fields:

Custom pipeline to fetch all details (e.g. for subscriptions)

Below is an example custom pipeline that stores subscription details in the data warehouse. This is useful if you want details such as “direct debit” etc. as well as line items from subscriptions.

Custom pipeline to fetch contact-company relations

Below is a custom pipeline that syncs the contact-company relations to the data warehouse.

Need further help

Please contact our support for any further assistance via support@peliqan.io.