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
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.
Example to add a company in Teamleader:
teamleader_api = pq.connect('Teamleader')
company = {
"name": "ACME",
"website": "http://example.com"
}
teamleader_api.add('company', company)
Custom fields
Example script to sync Teamleader custom fields (from Projects in this example):
teamleader_api = pq.connect('Teamleader')
dw = pq.dbconnect(dw_name)
projects = dw.fetch(PQ.DW_Name, 'teamleader', 'projectsv2')
custom_field_definitions = teamleader_api.list('customFieldDefinitions')
for project in projects:
project_details = teamleader_api.get('project', id = project["id"])
custom_fields = project_details["data"]["custom_fields"]
project_custom_fields = {}
for custom_field in custom_fields:
if custom_field["value"]:
project_custom_fields["project_id"] = project["id"]
project_custom_fields["project_name"] = project["title"]
for custom_field_definition in custom_field_definitions["detail"]:
if custom_field_definition["context"] == "project" and custom_field_definition["id"] == custom_field["definition"]["id"]:
project_custom_fields[custom_field_definition["label"]] = custom_field["value"]
if project_custom_fields:
dw.write('teamleader', 'project_customfields', project_custom_fields, pk='project_id')
Need further help
Please contact our support for any further assistance via support@peliqan.io.