Pipedrive

Outros · Disponível

Consultar via API

GET https://askaner.askan.com.br/api/v1/data/pipedrive?fields=date,account_id&date_preset=last_30d
Authorization: Bearer ik_...

Campos (41 métricas, 184 dimensões)

ID	Tipo	Natureza	Descrição
`activity_add_time`	TIMESTAMP	Dimensão	Time when the activity was added.
`activity_deal_id`	TEXT	Dimensão	The ID of the deal linked to the activity.
`activity_deal_title`	TEXT	Dimensão	The title of the deal linked to the activity.
`activity_done`	BOOLEAN	Dimensão	Whether the activity is marked as done.
`activity_due_date`	DATE	Dimensão	The due date of the activity.
`activity_due_time`	TIMESTAMP	Dimensão	The due time of the activity.
`activity_id`	TEXT	Dimensão	The ID of the activity.
`activity_marked_as_done_time`	TIMESTAMP	Dimensão	Time when the activity was marked as done.
`activity_org_id`	TEXT	Dimensão	The ID of the organization linked to the activity.
`activity_org_name`	TEXT	Dimensão	The name of the organization linked to the activity.
`activity_owner_name`	TEXT	Dimensão	The name of the user who owns the activity.
`activity_person_id`	TEXT	Dimensão	The ID of the person linked to the activity.
`activity_person_name`	TEXT	Dimensão	The name of the person linked to the activity.
`activity_subject`	TEXT	Dimensão	The subject of the activity.
`activity_type`	TEXT	Dimensão	The type of the activity (e.g. call, meeting).
`activity_update_time`	TIMESTAMP	Dimensão	Time when the activity was last updated.
`activity_user_id`	TEXT	Dimensão	The ID of the user assigned to the activity.
`deal_product_currency`	TEXT	Dimensão	Deal product currency
`deal_product_discount`	NUMERIC	Métrica	Deal product discount
`deal_product_id`	TEXT	Dimensão	Deal product ID
`deal_product_item_price`	NUMERIC	Métrica	Deal product item price
`deal_product_name`	TEXT	Dimensão	Deal product name
`deal_product_quantity`	NUMERIC	Métrica	Deal product quantity
`deal_product_sum`	NUMERIC	Métrica	Deal product sum
`deal_product_tax`	NUMERIC	Métrica	Deal product tax
`deal_product_variation_id`	TEXT	Dimensão	Deal product variation ID
`deal_active`	BOOLEAN	Dimensão	Indicates whether the deal is active.
`deal_activities_count`	NUMERIC	Métrica	The count of activities associated with the deal
`deal_acv`	NUMERIC	Métrica	Deal ACV
`deal_acv_currency`	TEXT	Dimensão	Deal ACV Currency
`deal_add_time`	TIMESTAMP	Dimensão	Time when the deal was added.
`deal_additional_data`	OBJECT	Dimensão	Additional data related to the deal
`deal_arr`	NUMERIC	Métrica	Deal ARR
`deal_arr_currency`	TEXT	Dimensão	Deal ARR Currency
`deal_cc_email`	TEXT	Dimensão	Deal CC Email
`deal_channel`	TEXT	Dimensão	Deal Channel
`deal_channel_id`	TEXT	Dimensão	Deal Channel ID
`deal_close_time`	TIMESTAMP	Dimensão	The time when the deal was closed
`deal_creator_user_id_active_flag`	BOOLEAN	Dimensão	Deal Creator User Active Flag
`deal_creator_user_id_email`	TEXT	Dimensão	Deal Creator User Email
`deal_creator_user_id_has_pic`	BOOLEAN	Dimensão	Deal Creator User Has Pic
`deal_creator_user_id_id`	TEXT	Dimensão	Deal Creator User ID
`deal_creator_user_id_name`	TEXT	Dimensão	Deal Creator User Name
`deal_creator_user_id_pic_hash`	TEXT	Dimensão	Deal Creator User Pic Hash
`deal_creator_user_id_value`	NUMERIC	Métrica	Deal Creator User Value
`deal_currency`	TEXT	Dimensão	The currency of the deal.
`deal_deleted`	BOOLEAN	Dimensão	Indicates whether the deal is deleted.
`deal_done_activities_count`	NUMERIC	Métrica	The count of completed activities associated with the deal
`deal_email_messages_count`	NUMERIC	Métrica	The count of email messages associated with the deal
`deal_expected_close_date`	DATE	Dimensão	The expected close date of the deal. In ISO 8601 format: YYYY-MM-DD.
`deal_files_count`	NUMERIC	Métrica	The count of files associated with the deal
`deal_first_won_time`	TIMESTAMP	Dimensão	The time when the deal was first won
`deal_followers_count`	NUMERIC	Métrica	The count of followers of the deal
`deal_formatted_value`	TEXT	Dimensão	The formatted value of the deal
`deal_formatted_weighted_value`	TEXT	Dimensão	The formatted weighted value of the deal
`deal_id`	TEXT	Dimensão	The ID of the deal
`deal_label`	TEXT	Dimensão	Deal Label
`deal_last_activity_date`	DATE	Dimensão	Date of the last activity of the deal
`deal_last_activity_id`	NUMERIC	Métrica	The ID of the last activity of the deal
`deal_last_incoming_mail_time`	TIMESTAMP	Dimensão	Deal Last Incoming Mail Time
`deal_last_outgoing_mail_time`	TIMESTAMP	Dimensão	Deal Last Outgoing Mail Time
`deal_lost_reason`	TEXT	Dimensão	The reason for losing the deal
`deal_lost_time`	TIMESTAMP	Dimensão	The time when the deal was lost
`deal_mrr`	NUMERIC	Métrica	Deal MRR
`deal_mrr_currency`	TEXT	Dimensão	Deal MRR Currency
`deal_next_activity_date`	DATE	Dimensão	Date of the next activity of the deal
`deal_next_activity_duration`	TEXT	Dimensão	Duration of the next activity of the deal
`deal_next_activity_id`	NUMERIC	Métrica	The ID of the next activity of the deal
`deal_next_activity_note`	TEXT	Dimensão	Note content of the next activity of the deal
`deal_next_activity_subject`	TEXT	Dimensão	The subject of the next activity of the deal
`deal_next_activity_time`	TIMESTAMP	Dimensão	Time of the next activity of the deal
`deal_next_activity_type`	TEXT	Dimensão	The type of the next activity of the deal
`deal_notes_count`	NUMERIC	Métrica	The count of notes associated with the deal
`deal_org_hidden`	BOOLEAN	Dimensão	Indicates whether the organization is hidden
`deal_org_id_active_flag`	BOOLEAN	Dimensão	Deal Organization Active Flag
`deal_org_id_address`	TEXT	Dimensão	Deal Organization Address
`deal_org_id_cc_email`	TEXT	Dimensão	Deal Organization CC Email
`deal_org_id_owner_id`	TEXT	Dimensão	Deal Organization Owner ID
`deal_org_id_people_count`	NUMERIC	Métrica	Deal Organization People Count
`deal_org_id_value`	NUMERIC	Métrica	Deal Organization Value
`deal_org_name`	TEXT	Dimensão	Deal Organization Name
`deal_origin`	TEXT	Dimensão	Deal Origin
`deal_origin_id`	TEXT	Dimensão	Deal Origin ID
`deal_owner_name`	TEXT	Dimensão	The name of the deal owner
`deal_participants_count`	NUMERIC	Métrica	The count of participants in the deal
`deal_person_hidden`	BOOLEAN	Dimensão	Indicates whether the person is hidden
`deal_person_id_active_flag`	BOOLEAN	Dimensão	Deal Person Active Flag
`deal_person_id_email`	TEXT	Dimensão	Deal Person Email
`deal_person_id_phone`	TEXT	Dimensão	Deal Person Phone
`deal_person_id_value`	NUMERIC	Métrica	Deal Person Value
`deal_person_name`	TEXT	Dimensão	Deal Person Name
`deal_pipeline_id`	NUMERIC	Métrica	The ID of the pipeline of the deal
`deal_probability`	PERCENT	Métrica	The probability of the deal closing in percent.
`deal_products_count`	NUMERIC	Métrica	The count of products associated with the deal
`deal_related_objects`	OBJECT	Dimensão	Related objects associated with the deal
`deal_rotten_time`	TIMESTAMP	Dimensão	Time when the deal turned rotten
`deal_stage_change_time`	TIMESTAMP	Dimensão	Time when the deal stage changed.
`deal_stage_id`	TEXT	Dimensão	Deal Stage ID
`deal_stage_order_nr`	TEXT	Dimensão	Deal Stage Order Number
`deal_status`	TEXT	Dimensão	The status of the deal
`deal_title`	TEXT	Dimensão	The deal title
`deal_undone_activities_count`	NUMERIC	Métrica	The count of incomplete activities associated with the deal
`deal_update_time`	TIMESTAMP	Dimensão	Time when the deal was updated.
`deal_user_id`	TEXT	Dimensão	The ID of the user associated with the deal
`deal_user_id_active_flag`	BOOLEAN	Dimensão	Deal User Active Flag
`deal_user_id_email`	TEXT	Dimensão	Deal User Email
`deal_user_id_has_pic`	BOOLEAN	Dimensão	Deal User Has Pic
`deal_user_id_name`	TEXT	Dimensão	Deal User Name
`deal_user_id_pic_hash`	TEXT	Dimensão	Deal User Pic Hash
`deal_user_id_value`	NUMERIC	Métrica	Deal User Value
`deal_value`	NUMERIC	Métrica	The value of the deal.
`deal_visible_to`	TEXT	Dimensão	The visibility of the deal
`deal_weighted_value`	NUMERIC	Métrica	The weighted value of the deal
`deal_weighted_value_currency`	TEXT	Dimensão	The currency of the weighted value of the deal
`deal_won_time`	TIMESTAMP	Dimensão	The time when the deal was won
`account_id`	TEXT	Dimensão	The Pipedrive account identifier
`account_name`	TEXT	Dimensão	The Pipedrive account name
`add_time`	TIMESTAMP	Dimensão	Time when the object was added.
`date`	DATE	Dimensão	Time when the object was updated
`update_time`	TIMESTAMP	Dimensão	Time when the object was updated.
`label_ids`	OBJECT	Dimensão	The IDs of the lead labels which will be associated with the lead
`lead_add_time`	TIMESTAMP	Dimensão	Time when the lead was added.
`lead_cc_email`	TEXT	Dimensão	The lead company email
`lead_creator_id`	TEXT	Dimensão	The ID of the creator of the lead
`lead_expected_close_date`	DATE	Dimensão	The date of when the deal which will be created from the lead is expected to be closed.
`lead_id`	TEXT	Dimensão	The ID of the lead.
`lead_is_archived`	BOOLEAN	Dimensão	A flag indicating if the lead is archived or not.
`lead_next_activity_id`	NUMERIC	Métrica	The next activity ID of the lead.
`lead_owner_id`	TEXT	Dimensão	The ID of the owner of the lead
`lead_person_id`	TEXT	Dimensão	The ID of a person which this lead will be linked to. If the person does not exist yet, it needs to be created first. This property is required unless organization_id is specified.
`lead_pipedrive_organization_id`	NUMERIC	Métrica	The ID of an organization which this lead will be linked to. If the organization does not exist yet, it needs to be created first.
`lead_source_name`	TEXT	Dimensão	The source name of the lead (e.g. API)
`lead_title`	TEXT	Dimensão	The name of the lead
`lead_update_time`	TIMESTAMP	Dimensão	Time when the lead was updated.
`lead_value_amount`	NUMERIC	Métrica	The amount of the deal which will be created from the lead
`lead_value_currency`	TEXT	Dimensão	The currency of the deal which will be created from the lead
`lead_visible_to`	TEXT	Dimensão	Visible to
`lead_was_seen`	BOOLEAN	Dimensão	A flag indicating whether the lead was seen by someone in the Pipedrive UI
`person_activities_count`	NUMERIC	Métrica	The number of activities linked to the person.
`person_add_time`	TIMESTAMP	Dimensão	Time when the person was added.
`person_closed_deals_count`	NUMERIC	Métrica	The number of closed deals linked to the person.
`person_done_activities_count`	NUMERIC	Métrica	The number of completed activities linked to the person.
`person_email`	TEXT	Dimensão	The email addresses of the person.
`person_first_name`	TEXT	Dimensão	The first name of the person.
`person_id`	TEXT	Dimensão	The ID of the person.
`person_label`	TEXT	Dimensão	The label assigned to the person.
`person_last_name`	TEXT	Dimensão	The last name of the person.
`person_name`	TEXT	Dimensão	The full name of the person.
`person_open_deals_count`	NUMERIC	Métrica	The number of open deals linked to the person.
`person_org_id`	TEXT	Dimensão	The ID of the organization linked to the person.
`person_org_name`	TEXT	Dimensão	The name of the organization linked to the person.
`person_owner_id`	TEXT	Dimensão	The ID of the user who owns the person.
`person_owner_name`	TEXT	Dimensão	The name of the user who owns the person.
`person_phone`	TEXT	Dimensão	The phone numbers of the person.
`person_update_time`	TIMESTAMP	Dimensão	Time when the person was last updated.
`person_visible_to`	TEXT	Dimensão	The visibility level of the person.
`person_won_deals_count`	NUMERIC	Métrica	The number of won deals linked to the person.
`project_add_time`	TIMESTAMP	Dimensão	Time when the project was created.
`project_archive_time`	TIMESTAMP	Dimensão	Time when the project was archived, if it was archived.
`project_board_id`	TEXT	Dimensão	The ID of the board this project is associated with.
`project_deal_ids`	OBJECT	Dimensão	The IDs of the deals this project is associated with.
`project_description`	TEXT	Dimensão	The description of the project.
`project_end_date`	DATE	Dimensão	The end date of the project.
`project_health_status`	NUMERIC	Métrica	The health status of the project.
`project_id`	TEXT	Dimensão	The ID of the project.
`project_labels`	OBJECT	Dimensão	The IDs of the labels this project has.
`project_org_id`	TEXT	Dimensão	The ID of the organization this project is associated with.
`project_owner_id`	TEXT	Dimensão	The ID of the user who owns the project.
`project_person_id`	TEXT	Dimensão	The ID of the person this project is associated with.
`project_phase_id`	TEXT	Dimensão	The ID of the phase this project is placed in.
`project_start_date`	DATE	Dimensão	The start date of the project.
`project_status`	TEXT	Dimensão	The status of the project (open, completed or canceled).
`project_status_change_time`	TIMESTAMP	Dimensão	Time when the project status was last changed.
`project_title`	TEXT	Dimensão	The title of the project.
`project_update_time`	TIMESTAMP	Dimensão	Time when the project was last updated.
`stage_active_flag`	BOOLEAN	Dimensão	Flag whether the stage is active or not
`stage_add_time`	TIMESTAMP	Dimensão	Time when the stage was added.
`stage_deal_probability`	PERCENT	Métrica	The stage probability in percent
`stage_id`	TEXT	Dimensão	The stage ID
`stage_name`	TEXT	Dimensão	The stage name
`stage_order_nr`	NUMERIC	Métrica	The stage order number
`stage_pipedrive_pipeline_id`	NUMERIC	Métrica	The pipeline ID
`stage_pipeline_deal_probability`	BOOLEAN	Dimensão	The pipeline deal probability
`stage_pipeline_name`	TEXT	Dimensão	The name of the pipeline
`stage_pipeline_rotten_days`	NUMERIC	Métrica	The number of days the deals not updated in this stage would become rotten. Applies only if the is_deal_rot_enabled is set.
`stage_pipeline_rotten_flag`	BOOLEAN	Dimensão	Whether deals in this stage can become rotten.
`stage_update_time`	TIMESTAMP	Dimensão	Time when the stage was updated.
`users_access`	TEXT	Dimensão	User Access
`users_active_flag`	BOOLEAN	Dimensão	User Active Flag
`users_created`	TEXT	Dimensão	User Created
`users_default_currency`	TEXT	Dimensão	User Default Currency
`users_email`	TEXT	Dimensão	User Email
`users_has_created_company`	BOOLEAN	Dimensão	User Has Created Company
`users_icon_url`	IMAGE	Dimensão	User Icon Url
`users_id`	TEXT	Dimensão	User ID
`users_is_admin`	TEXT	Dimensão	User Is admin
`users_is_deleted`	BOOLEAN	Dimensão	User Is Deleted
`users_is_you`	BOOLEAN	Dimensão	User Is You
`users_lang`	TEXT	Dimensão	User Lang
`users_last_login`	TIMESTAMP	Dimensão	User Last Login
`users_locale`	TEXT	Dimensão	User Locale
`users_modified`	TIMESTAMP	Dimensão	User Modified Date
`users_name`	TEXT	Dimensão	User Name
`users_phone`	TEXT	Dimensão	User Phone
`users_role_id`	TEXT	Dimensão	User Role ID
`users_timezone_name`	TEXT	Dimensão	User Timezone name
`users_timezone_offset`	TEXT	Dimensão	User Timezone offset
`data_fetched_at`	TIMESTAMP	Dimensão	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
`datasource`	TEXT	Dimensão	The name of the Windsor connector returning the row
`day_of_month`	TEXT	Dimensão	Day of the month
`month`	TEXT	Dimensão	Number of the month
`now`	TIMESTAMP	Dimensão	Current timestamp
`source`	TEXT	Dimensão	The name of the Windsor connector returning the row
`today`	DATE	Dimensão	Today's date
`week`	TEXT	Dimensão	Week (Sun-Sat).
`week_day`	TEXT	Dimensão	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
`week_day_iso`	TEXT	Dimensão	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
`week_iso`	TEXT	Dimensão	Week, ISO format (Mon-Sun).
`year`	TEXT	Dimensão	Year
`year_month`	TEXT	Dimensão	Year and month, e.g. 2024\|3
`year_month_name`	TEXT	Dimensão	Year and month with the month name written out, e.g. "Jan 2025".
`year_of_week`	TEXT	Dimensão	The year that contains first day of the week (Sun-Sat).
`year_of_week_iso`	TEXT	Dimensão	The year that contains first day of the ISO week (Mon-Sun).
`year_week`	TEXT	Dimensão	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
`year_week_iso`	TEXT	Dimensão	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20