CData Python Connector for Pipedrive

Build 25.0.9540

ActivitiesParticipants

Get details of activities participants

Select

The 本製品 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 本製品.

  • ActivitiesId supports the '=' operator.
  • FilterId supports the '=' operator.
  • OwnerId supports the '=' operator.
  • DealId supports the '=' operator.
  • LeadId supports the '=' operator.
  • PersonId supports the '=' operator.
  • OrgId supports the '=' operator.
  • Done supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM ActivitiesParticipants WHERE ActivitiesId = 246

SELECT * FROM ActivitiesParticipants WHERE Done = true

SELECT * FROM ActivitiesParticipants WHERE PersonId = 1
 
SELECT * FROM ActivitiesParticipants WHERE DealId = 2

SELECT * FROM ActivitiesParticipants WHERE OrgId = 1                  

Columns

Name Type References Description
ParticipantPersonId [KEY] Integer ParticipantPersonId
ActivitiesId [KEY] Integer

Activities.Id

Activities ID.
PrimaryFlag Boolean PrimaryFlag

Pseudo-Columns

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

Name Type Description
FilterId Integer The ID of the Filter to use.
OwnerId Integer The id of the owner of the activity.
DealId Integer The id of the deal corresponding to the activity
LeadId String The Id of the lead corresponding to the activity.
PersonId Integer The id of the person corresponding to the activity.
OrgId Integer The id of the organisation corresponding to the activity.
Done Boolean Whether the Activity is done or not. If omitted, returns both Done and Not done activities.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9540