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

必須プロパティは［設定］タブにリストされています。［Advanced］タブには、通常は必要ない接続プロパティが表示されます。

PipeDrive への接続

Pipedrive への接続に使用できる認証方法は、Basic およびOAuth です。

Basic

1. PipeDrive の右上にあるアカウント名をクリックします。
2. 会社設定をクリックし、続いてPersonal Preferences -> API -> Generate Token をクリックします。
3. API トークンを控えておきます。
4. CompanyDomain を控えておきます。これは、PipeDrive ホームページのURL に表示されます。

以下を設定してPipedrive へ認証します。

• APIToken：控えておいたAPI トークンに設定。
• CompanyDomain：控えておいた開発者サンドボックスURL の会社ドメインに設定。
• AuthScheme：Basic に設定。

OAuth

ユーザー名やパスワードへのアクセスを保有していない場合や、それらを使いたくない場合にはOAuth ユーザー同意フローを使用します。認証方法については、OAuth 認証の使用 を参照してください。

概要

このセクションでは、利用可能なAPI オブジェクトを示し、Pipedrive API へのSQL の実行について詳しく説明します。

主要機能

• Sync App はドキュメント、フォルダ、およびグループなどのPipedrive エンティティをリレーショナルビューとしてモデル化し、SQL を記述してPipedrive データをクエリできるようにします。
• ストアドプロシージャを使用するとPipedrive の操作を実行できます。
• これらのオブジェクトへのライブ接続により、Sync App を使用するとPipedrive アカウントへのあらゆる変更が即座に反映されます。

ビュー

ビュー では、利用可能なビューを説明します。ビューは、Currencies、DealsPersons、ProductsFiles などのPipedrive エンティティを静的にモデル化するように定義されています。

テーブル

テーブル では、利用可能なテーブルを説明します。テーブルは、Activities、Users、Leads などのPipedrive エンティティを静的にモデル化するように定義されています。

ストアドプロシージャ

ストアドプロシージャ は、Pipedrive のファンクションライクなインターフェースです。ストアドプロシージャを使用すると、オブジェクトのダウンロードやエンベロープの移動など、Pipedrive の操作を実行できます。

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

一般的には、Pipedrive テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

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 (Name,IconKey,color,IsCustomFlag,KeyString) VALUES ('test42','task','FFFFFF','true','call')

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.
• Title supports the 'LIKE' operator.
• FilterId supports the '=' operator.
• UserId supports the '=' operator.
• PersonId supports the '=' operator.
• OrgId 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  Title LIKE '%Cdata1%'

SELECT * FROM Deals WHERE FilterId = 1

SELECT * FROM Deals WHERE FilterId = 1
 
SELECT * FROM Deals WHERE OrgId = 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

Pseudo-Columns

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

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.

• Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsProducts 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 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.

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.

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 Content and PersonId columns. The columns that are not required can be inserted optionally. For example:

INSERT INTO Goals (Title, AssigneeId,AssigneeType,DurationStart,DurationEnd,Target,CurrencyId,TrackingMetric,Iterval,TypeName,PipelineId) VALUES ('test',13815887,'person' ,'2022-01-21','2022-02-03',50,1,'sum','monthly','deals_started','null')

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 details of all Lead Labels.

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 LeadLabels

INSERT

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

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

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 LeadLabels SET Name = 'I am updating content' WHERE id ='28093520-743a-11ec-96e6-031cfba07e9a'

DELETE

Delete can be executed by specifying 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.

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 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.

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 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.
• OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationRelationships WHERE id = 2
                 

INSERT

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

INSERT INTO OrganizationRelationships (Type,RelOwnerOrgId,RelLinkedOrgId) values('parent','8230170','8230170')

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 OrganizationRelationships SET Type = 'related' WHERE id = 2

DELETE

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

DELETE FROM OrganizationRelationships WHERE Id = 2

Columns

Gets all of the relationships.

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.
• Address supports the 'LIKE' operator.
• Name supports the 'LIKE' 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 Address LIKE '%Cdata%'

SELECT * FROM Organizations WHERE Name LIKE '%Cdata%'

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

Get details of organizations.

Columns

Pseudo-Columns

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

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.
• Email supports the 'LIKE' operator.
• Name supports the 'LIKE' operator.
• FirstChar supports the 'LIKE' operator.
• Phone 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 Name LIKE '%Cdata%'

SELECT * FROM Persons WHERE Phone LIKE '%9876%'

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 details of persons.

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

Returns data about all product 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 ProductFields WHERE Id = 28                 

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 ProductFields (Name,FieldType) VALUES ('BangaloreCdataIndia123','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 ProductFields SET Name = 'My name just started here' WHERE Id = 28

DELETE

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

DELETE FROM ProductFields WHERE Id = 9040

Columns

Get details of 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.

• Id supports the '=' operator.
• Code supports the 'LIKE' operator.
• Name supports the 'LIKE' operator.
• FirstChar supports the '=' operator.
• FilterId supports the '=' operator.
• UserId supports the '=' operator.
• GetSummary supports the '=' operator.
• Ids supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM Products WHERE Id = 14

SELECT * FROM Products WHERE Name LIKE '%Cdata%'

SELECT * FROM Products WHERE code LIKE '%123%'

SELECT * FROM Products WHERE FirstChar = 'c'

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

SELECT * FROM Products WHERE GetSummary = 1

SELECT * FROM Products WHERE Ids IN (1,2)

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 Products (name) VALUES ('tests')

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 Products SET Name = 'test123' WHERE Id = 2495

DELETE

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

DELETE FROM Products WHERE Id = 15

Columns