Returns all lead labels used for organizing and categorizing leads.

Select

The connector uses the Pipedrive API to process WHERE clause conditions built with the server-side supported columns and operators. It processes all other filters client-side within the connector.

For example, since no columns or operators are supported server-side, only the following query runs on the server:

SELECT * FROM LeadLabels

INSERT

To insert data, specify values for the Name and Color columns. You can include additional, optional columns as needed. For example:

INSERT INTO LeadLabels (Name, Color) VALUES ('BangaloreCdataIndia123', 'blue')

UPDATE

To update a record, include the Id in the WHERE clause and set new values for any editable (non-read-only) columns. For example:

UPDATE LeadLabels SET Name = 'I am updating content' WHERE id = '28093520-743a-11ec-96e6-031cfba07e9a'

DELETE

To delete a record, specify the Id in the WHERE clause. For example:

DELETE FROM LeadLabels WHERE Id = '28093520-743a-11ec-96e6-031cfba07e9a'

Columns