Pipedrive への接続を追加

1. アプリケーションコンソールで、接続ページに移動します。
2. 接続の追加パネルで、追加したい接続のアイコンを選択します。
3. Pipedrive アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからPipedrive コネクタをダウンロードおよびインストールします。

必須プロパティについては、設定タブを参照してください。

通常必須ではない接続プロパティについては、高度な設定タブを参照してください。

Pipedrive への接続

Basic 認証

1. API トークンを取得します。
   1. Pipedrive ポータルを開きます。
   2. ページ右上のアカウント名をクリックします。Pipedrive はドロップダウンリストを表示します。
   3. 会社設定 -> Personal Preferences -> API -> Generate Token に移動します。
   4. 生成されたAPI トークンの値を記録します。また、CompanyDomain を控えておきます。これは、PipeDrive ホームページのURL に表示されます。（これは会社の開発者用サンドボックスのURL です。）
2. 次の接続プロパティを設定します。
   • APIToken：取得したAPI トークンの値。
   • CompanyDomain：開発者サンドボックスURL のCompanyDomain。
   • AuthScheme：Basic。

3. 承認されたユーザー名とパスワードでログインします。

API トークンはPipedrive ポータルに保存されます。これを取得するには、会社名をクリックし、ドロップダウンリストを使用して会社設定 -> Personal Preferences -> API に移動します。

OAuth 認証

以下のサブセクションでは、3つの一般的な認証フローでのPipedrive への認証について詳しく説明します。 カスタムOAuth アプリケーションの作成については、カスタムOAuth アプリケーションの作成 を参照してください。 Pipedrive で利用可能な接続文字列プロパティの全リストは、Connection を参照してください。

OAuth アクセストークンの自動リフレッシュ：

Sync App がOAuth アクセストークンを自動的にリフレッシュするようにするには：

1. はじめてデータに接続する前に、次の接続パラメータを設定します。
   • InitiateOAuth：REFRESH。
   • OAuthClientId：カスタムOAuth アプリケーション設定のクライアントId。
   • OAuthClientSecret：カスタムOAuth アプリケーション設定のクライアントシークレット。
   • OAuthAccessToken：GetOAuthAccessToken によって返されたアクセストークン。
   • OAuthSettingsLocation：Sync App がOAuth 値を保存する場所のパス。これは接続間で維持されます。
2. その後のデータ接続では、以下を設定します。
   • InitiateOAuth
   • OAuthSettingsLocation

OAuth アクセストークンの手動リフレッシュ：

OAuth アクセストークンを手動でリフレッシュするために必要な唯一の値は、OAuth リフレッシュトークンです。

1. ExpiresIn 期間（GetOAuthAccessToken が返す）が経過した後にOAuthAccessToken を手動でリフレッシュするには、RefreshOAuthAccessToken ストアドプロシージャを呼び出します。
2. 次の接続プロパティを設定します。
   • OAuthClientId：カスタムOAuth アプリケーション設定のクライアントId。
   • OAuthClientSecret：カスタムOAuth アプリケーション設定のクライアントシークレット。

3. RefreshOAuthAccessToken を呼び出し、OAuthRefreshToken にGetOAuthAccessToken によって返されたOAuth リフレッシュトークンを設定します。
4. 新しいトークンが取得できたら、OAuthAccessToken プロパティにRefreshOAuthAccessToken によって返された値を設定します。これで新規接続が開かれます。

OAuth リフレッシュトークンを保存し、OAuth アクセストークンの有効期限が切れた後に手動でリフレッシュできるようにします。

Pipedrive V1 API の使用

Pipedrive データモデルで利用可能なエンティティについては、Pipedrive データモデル を参照してください。

Pipedrive V2 API の使用

PipedriveV2 データモデルで利用可能なエンティティについては、PipedriveV2 データモデル を参照してください。

Overview

This section shows the available API objects and provides more information on executing SQL to Pipedrive APIs.

Key Features

• The Sync App models Pipedrive entities like activities, leads, and products as relational tables, allowing you to write SQL to query and modify Pipedrive data.
• Stored procedures allow you to execute operations to Pipedrive
• Live connectivity to these objects means any changes to your Pipedrive account are immediately reflected when using the Sync App.

  Additionally, the Pipedrive API limits the number and combinations of columns that can be projected over the data or used to restrict the results returned.

Sync App はPipedrive のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

Pipedrive Connector for CData Sync テーブル

Get all Activities assigned to a particular User.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.
• Done supports the '=' operator.
• Type supports the '=, IN' operators.
• UserId supports the '=' operator.
• FilterId supports the '=' operator.
• StartDate supports the '=' operator.
• EndDate supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Activities WHERE Id = 246

SELECT * FROM Activities WHERE Done = 0

SELECT * FROM  Activities WHERE Type IN ('deadline', 'call')

SELECT * FROM  Activities WHERE EndDate = '2021-12-24'
 
SELECT * FROM  Activities WHERE UserId = 8230170

INSERT

The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO ActivitiesAttendees#TEMP (EmailAddress) VALUES ('[email protected]')
INSERT INTO Activities (DueDate, DueTime, Duration, Dealid, Attendees) VALUES ('1994-10-12', '10:20', '02:00', 1, 'ActivitiesAttendees#TEMP')

UPDATE

UPDATE can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Activities SET DealId = 2 WHERE Id = 245

DELETE

DELETE can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Activities WHERE Id = 246

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Get all ActivityTypes.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Activities WHERE Id = 9

INSERT

Insert can be executed by specifying the Name and IconKey columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO ActivityTypes (Color, IconKey, Name) VALUES ('black', 'sound', 'pvnactivity');

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE ActivityTypes SET IconKey = 'email' WHERE id = 7

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM ActivityTypes WHERE Id = 2

Columns

Returns all call logs assigned to a particular user.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM CallLogs WHERE Id = 'cf75de9e4cbcb4a33658ad40561e3230'                

INSERT

Insert can be executed by specifying the Outcome, ToPhoneNumber, StartTime and EndTime columns. The columns that are not required can be inserted optionally.

INSERT INTO CallLogs (Outcome, StartTime, EndTime, Duration, FromPhoneNumber, ToPhoneNumber, UserId, OrgId) VALUES ('connected', '2021-12-15', '2021-12-16', '140', '984656646', '9846566456', '8230170', '6')

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM CallLogs WHERE Id = '8381cea5da671fa16a1eb63af15e5ec4'

Columns

Returns data about all deal fields.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealFields WHERE Id = 12478                  

INSERT

Insert can be executed by specifying the Name and IconKey columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealFields (Name, AddVisibleFlag, FieldType) VALUES ('test43', 'false', 'address')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE DealFields SET Name = 'test44' WHERE Id = '12500'

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM DealFields WHERE Id = 12500

Columns

Get all deals.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.
• StageId supports the '=' operator.
• Status supports the '=' operator.
• FilterId supports the '=' operator.
• UserId supports the '=' operator.
• OwnedByYou supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Deals WHERE Id = 14

SELECT * FROM Deals WHERE StageId = 1

SELECT * FROM Deals WHERE  Status = 'Open'

SELECT * FROM Deals WHERE FilterId = 1       

SELECT * FROM Deals WHERE OwnedByYou = 1                

INSERT

Insert can be executed by specifying the Title columns.The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO Deals (title, PersonId) VALUES ('tetsptest', 6203)

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Deals SET Title = 'test' WHERE id = 15

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Deals WHERE id = 15

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Get details of deals followers.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.

For example, the following query is processed server side:

    SELECT * FROM DealsFollowers WHERE Id = 2                 

INSERT

Insert can be executed by specifying the Name and IconKey columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealsFollowers (userid, id) VALUES (8230170, 8)

DELETE

Delete can be executed by specifying the Id, DealId in the WHERE Clause. For example:

DELETE FROM DealsFollowers WHERE Id = 1 AND Dealid = 1

Columns

Get details of deals participants.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsParticipants WHERE Id = 9 

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealsParticipants (Id, Personid) VALUES (4, 6) 

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM DealsParticipants WHERE id = 14 AND ItemDealId = 17

Columns

Get details of deals products.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• DealId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsProducts WHERE DealId = 9 

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO DealsProducts (DealId, ProductId, ItemPrice, quantity) VALUES (2, 2, 20000, 1)

UPDATE

Update can be executed by specifying the Id and Dealid in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE DealsProducts SET quantity = 20 WHERE id = 15 AND Dealid = 2

DELETE

Delete can be executed by specifying the Id, DealId in the WHERE Clause. For example:

DELETE FROM DealsProducts WHERE id = 15 AND Dealid = 2

Columns

Returns data about all files.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Files WHERE Id = 400

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Files SET Name = 'Updating PipeDrive Pipelines1' WHERE Id = 405

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Files WHERE Id = 400

Columns

Returns data about all filters.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.
• Type supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Filters WHERE Id = 39

INSERT

Insert can be executed by specifying the Name, Conditions and Type columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Filters (Name, Conditions, Type) VALUES ('Indias Filter', '{"glue": "and","conditions": [{"glue": "and","conditions": [{"object": "organization","field_id": "4020"}]}]}', 'deals')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Filters SET Name = 'Updating Pipedrive filters', Conditions = '{"glue": "and","conditions": [{"glue": "or","conditions": [{"object": "organization123","field_id": "4021"}]}]}' WHERE Id = 39

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Filters WHERE Id = 10

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Goals help your team meet your sales targets.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.
• Title supports the '=' operator.
• Name supports the '=' operator.
• Type supports the '=' operator.
• Title supports the '=' operator.
• PipelineId supports the '=' operator.
• ActivityTypeId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Goals WHERE id = 'c924154b747f214228a906d3de079801' AND DurationEnd = '2022-02-03' AND DurationStart = '2022-01-01'

SELECT * FROM Goals WHERE Title = 'test'

SELECT * FROM Goals WHERE Type = 'test'

SELECT * FROM Goals WHERE TypeName = 'test'

INSERT

Insert can be executed by specifying the columns AssigneeId, AssigneeType, DurationStart, DurationEnd, Target, Interval, TypeName, CurrencyId, TrackingMetric, PipelineId and ActivityTypeId. The columns that are not required can be inserted optionally. For example:

INSERT INTO Goals (Title, AssigneeId, AssigneeType, DurationStart, DurationEnd, Target, [Interval], TypeName, CurrencyId,TrackingMetric,PipelineId,ActivityTypeId) VALUES ('QA Goal', 27952448, 'person', '2025-01-01', '2025-03-31', 50, 'monthly', 'deals_started', 148, 'sum', '[1]','[7]')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Goals SET title = 'test' WHERE id = 'c924154b747f214228a906d3de079801'

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Goals WHERE id = 'c924154b747f214228a906d3de079801'

Columns

Returns all lead labels used for organizing and categorizing leads.

Select

The Sync App 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 Sync App.

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

Returns lead data.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.
• SearchByEmail supports the '=' operator.
• OwnerId supports the '=' operator.
• PersonId supports the '=' operator.
• OrganizationId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Leads

SELECT * FROM Leads WHERE Id = 'a300ea00-5d6c-11ec-9270-93cbb0be1eed'

SELECT * FROM Leads WHERE SearchByEmail = 'all'

INSERT

Insert can be executed by specifying the Title column. The columns that are not required can be inserted optionally. For example:

INSERT INTO Leads (Title, Personid, Visibleto, ExpectedCloseDate) VALUES ('CData123', 1, 1, '2022-01-01')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Leads SET Title = 'CdataIndia' WHERE Id = 'bf1bb1e0-6e13-11ec-b981-a127469657bd'

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Leads WHERE Id = 'bf1bb1e0-6e13-11ec-b981-a127469657bd'

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Get, Update and Delete mail threads in a specified folder ordered by the most recent message within.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.
• Folder supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM MailThreads WHERE Folder = 'inbox'

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE MailThreads SET Subject = 'test' WHERE Id = 145

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM MailThreads WHERE Id = 145

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Create, Update, Delete and Get the comments associated with a note.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• NoteId supports the '=' operator.
• UUID supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM NoteComments WHERE NoteId = 14

INSERT

Insert can be executed by specifying the NoteId and Content columns.The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO NoteComments (NoteId,Content) VALUES (2, 'Test comment')

UPDATE

Update can be executed by specifying the NoteId and UUID in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE NoteComments SET Content='Test' where NoteId=1 and UUID = '53e0c79fdacf083d9fe1f799fdc0a206'

DELETE

Delete can be executed by specifying the NoteId and UUID in the WHERE Clause. For example:

DELETE FROM NoteComments WHERE NoteId=1 and UUID = '53e0c79fdacf083d9fe1f799fdc0a206'

Columns

Returns all notes.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.
• UserId supports the '=' operator.
• LeadId supports the '=' operator.
• DealId supports the '=' operator.
• PersonId supports the '=' operator.
• OrgId supports the '=' operator.
• PinnedToLeadFlag supports the '=' operator.
• PinnedToDealFlag supports the '=' operator.
• PinnedToOrganizationFlag supports the '=' operator.
• PinnedToPersonFlag supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Notes WHERE Id = 9                  

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Notes (ActiveFlag, Content, PersonId, AddTime) VALUES ('true', 'this is frist notes', '8', '2021-12-31')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Notes SET Content = 'I am updating content' WHERE id = 7

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Notes WHERE Id = 5

Columns

Returns data about all organization fields.

Select

The Sync App 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 Sync App.

• 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

Returns relationship records between organizations.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationRelationships WHERE Id = 9 

INSERT

Insert can be executed by specifying the Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO OrganizationRelationships (type, RelOwnerOrgId, RelLinkedOrgId) VALUES ('parent', 2, 3)

UPDATE

Update can be executed by specifying the Id and Dealid in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE OrganizationRelationships SET type = 'parent' WHERE Id = 10

DELETE

Delete can be executed by specifying the Id, DealId in the WHERE Clause. For example:

DELETE FROM OrganizationRelationships  WHERE Id = 10

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Get details of organizations.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.
• FirstChar supports the '=' operator.
• FilterId supports the '=' operator.
• UserId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Organizations WHERE Id = 14

SELECT * FROM Organizations WHERE FirstChar = 'c'

SELECT * FROM Organizations WHERE FilterId = 1
 
SELECT * FROM Organizations WHERE UserId = 1       

              

INSERT

Insert can be executed by specifying the Name columns.The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO Organizations (name) VALUES ('testpankaj')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Organizations SET Name = 'test123' WHERE Id = 2495

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Organizations WHERE id = 15

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Get details of organizations followers.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsFollowers WHERE OrgId = 6 

INSERT

Insert can be executed by specifying the UserId, OrgId columns.The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO OrganizationsFollowers (UserId, OrgId) VALUES (8230170, 1)

DELETE

Delete can be executed by specifying the Id, OrgId in the WHERE Clause. For example:

DELETE FROM OrganizationsFollowers WHERE OrgId = 1 AND id = 1

Columns

Returns data about all person fields.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM PersonFields WHERE Id = 9039                 

INSERT

Insert can be executed by specifying the Name and FieldType columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO PersonFields (Name, AddVisibleFlag, FieldType) VALUES ('NameCdataIndia', 'true', 'address')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE PersonFields SET Name = 'My name just started here' WHERE Id = '9062'

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM PersonFields WHERE Id = 9040

Columns

Get details of persons followers.

Columns

Get all details of persons.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.
• FirstChar supports the 'LIKE' operator.
• FilterId supports the '=' operator.
• UserId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Persons WHERE Id = 14

SELECT * FROM Persons WHERE FirstChar = 'c'

SELECT * FROM Persons WHERE FilterId = 1
 
SELECT * FROM Persons WHERE UserId = 1                 

INSERT

Insert can be executed by specifying the Name columns.The columns that are not read-only can be inserted. Following is an example of how to insert into this table.

INSERT INTO Persons (name) VALUES ('testpankaj')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Persons SET Name = 'test123' WHERE Id = 2495

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM Persons WHERE id = 15

Columns

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Get all Pipelines.

Select

The Sync App will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

• Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Pipelines WHERE Id = 4                 

INSERT

Insert can be executed by specifying the Name, Active, DealProbability, OrderNr and UrlTitle columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO PipeLines (Name, Active, DealProbability, OrderNr, UrlTitle) VALUES ('Indias PipeLines for Pipedrive', 'true', '0', 1, 'indiapipedrivepipeline@com')

UPDATE

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE PipeLines SET Name = 'Updating Pipedrive Pipelines1' WHERE Id = 4

DELETE

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM PipeLines WHERE Id = 5

Columns