Returns data about all organization fields.

Select

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

• Id supports the '=' operator.

For example, the following query is processed server-side:

SELECT * FROM OrganizationFields WHERE Id = 2             

INSERT

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

INSERT INTO OrganizationFields (Name, FieldType) VALUES ('Terex', 'text')

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 OrganizationFields SET Name = 'Terry' WHERE Id = 2

DELETE

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

DELETE FROM OrganizationFields WHERE Id = 2

Columns