Outcode User Guide
Developers GuideSales Contacts
English
English
  • WHAT IS OUTCODE?
    • Introduction
    • Getting Start
    • FAQ (3 Minutes)
    • Differences
  • Apps
    • API
      • Actions
        • HTTP Request
      • Trouble Shootings
    • JavaScript
      • Actions
        • Function Execution
      • Trouble Shootings
    • Data Source
      • MySQL
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • PostgreSQL
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • MongoDB
        • Connection
        • Actions
          • Find Documents
          • Aggregation
          • Insert Single Document
          • Update Single Document
          • Delete Single Document
        • Trouble Shootings
      • Airtable
        • Connection
        • Actions
          • Webhook trigger
          • Insert a row
          • Get rows
          • Update a row
        • Trouble Shootings
      • Firebase Realtime Database
        • Connection
        • Actions
          • Insert a document
          • Get documents
          • Update a document
          • Delete a document
      • Google Sheets
        • Connection
        • Actions
          • Insert a row
          • Get rows
          • Delete a row
      • SQL Server (MS-SQL)
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • MariaDB
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • Amazon Redshift
        • Connection
        • Actions
          • Query Execution
          • Get Query Status
          • Get Query Results
        • Trouble Shootings
      • Oracle Database
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • Redash
        • Connection
        • Actions
          • Create a query
          • Update a query
          • Delete a query
          • Get query result
          • Create a query job
          • Get a job result
          • Get query result by query result ID
        • Trouble Shootings
      • Microsoft Office365 Excel
        • Connection
        • Actions
          • Get rows
        • Trouble Shootings
      • CockroachDB
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • Redis
        • Connection
        • Actions
          • Get all keys
          • Get value by key
          • Search a key
          • Save the key
          • Save the key with set expiration
          • Append
          • Get exists key result
          • Get expiration count of key
          • Decrease the value
          • Increase the value
          • Delete a key
          • Flush all
    • Mail
      • SendGrid
        • Connection
        • Actions
          • Sends an Email
      • Amazon SES (Simple Email Service)
        • Connection
        • Actions
          • Sends an Email
        • Trouble Shootings
      • Gmail
        • Connection
        • Actions
          • Sends an Email
      • Stibee
        • Connection
        • Actions
          • Send Email by Trigger
          • Add a Subscriber
          • Remove a Subscriber
          • Unsubscribe a Subscriber
          • Assign the Subscriber to a Group
          • Release the Subscriber from a Group
      • Mailchimp
        • Connection
        • Actions
          • Campaign Delivery
          • Adds or Updates a Subscriber
          • Deletes a Subscriber
      • Mandrill (Mailchimp Transactional)
        • Connection
        • Actions
          • Sends an Email
          • Template Delivery
      • Mailgun
        • Connection
        • Actions
          • Sends an Email
      • Microsoft Office365 Outlook
        • Connection
        • Actions
          • Retrieves Messages from Mailfolder
          • Sends an Email
    • Message
      • Slack
        • Connection
        • Actions
          • Send a Message to Channel
          • Send a Direct Message to User
      • Microsoft Teams
        • Connection
        • Actions
          • Post a Message
      • Jandi
        • Connection
        • Actions
          • Send a Message
      • Twilio
        • Connection
        • Actions
          • Sends a SMS
      • OneSignal
        • Connection
        • Actions
          • Send message by segment
      • Solapi
        • Connection
        • Actions
          • Sends a SMS
          • Sends a LMS
          • Sends a MMS
          • Sends a Kakao Alimtalk
          • Sends a Kakao FriendTalk
          • Sends a Kakao FriendTalk (Button Type)
          • Retrieve Sending History
          • Retrieve Blacklist
        • Trouble Shootings
      • Lark
        • Connection
        • Actions
          • Send a text message via Custom Bot
          • Send a interactive message via Custom Bot
      • Discord
        • Connection
        • Actions
          • Guild (Server)
            • Get Bot Guilds
            • Get Guild Channels
            • List Guild Members
            • Search Guild Members
            • Get Guild Roles
            • Add Guild Member Role
            • Remove Guild Member Role
            • Get Guild Bans
            • Create Guild Ban
            • Remove Guild Ban
          • Message
            • Create Channel Message
            • Create Direct Message
          • Guild Scheduled Event
            • List Scheduled Events for Guild
            • Create Guild Scheduled Event
            • Get Guild Scheduled Event Users
    • Productivity
      • Google Calendar
        • Connection
        • Actions
          • Get Events
          • Insert a Event
      • Naver Open API
        • Connection
        • Actions
          • Retrieves News
          • Retrieves Trend Index
          • Retrieves Blog Posts
      • Typeform
        • Connection
        • Actions
          • Webhook Trigger
          • Retrieve Responses
      • Calendly
        • Connection
        • Actions
          • Webhook Trigger
          • Create a Single Link
      • Octoparse
        • Connection
        • Actions
          • Get Data by Offset
      • Microsoft Excel (.xlsx File)
        • Connection
        • Actions
          • Get Rows
      • Naver works
        • Connection
        • Actions
          • Retrieves Mails
          • Sends Email
          • Send a Message To Channel
          • Send a Direct Message To User
      • Notion
        • Connection
        • Actions
          • Retrieves Rows
          • Retrieves Rows with Filter
          • Create a Row
          • Update a Row
      • Korea Data API Center
        • Connection
        • Actions
          • FSC API
          • Others API
      • Microsoft OneDrive
        • Connection
        • Actions
          • Retrieves Files
      • Jira Cloud
        • Connection
        • Actions
          • Get Issues by Project
          • Get Issues by Board
          • Get Issues by Sprint
          • Create Issue
          • Create Issue Comment
          • Edit Issue
          • Delete Issue
      • Webflow
        • Connection
        • Actions
          • Get Form Responses
      • Modusign
        • Connection
        • Actions
          • Get Documents
          • Get Templates
          • Request Sign Using a Template
          • Request Send a Reminder
          • Cancel a Sign Request
          • Change Signing Due
        • Trouble Shootings
      • Google Analytics 4
        • Connection
        • Actions
          • Run Report
          • Realtime Report
      • Google Tasks
        • Connection
        • Actions
          • Get Tasklists
          • Create a Tasklist
          • Update a Tasklist
          • Delete a Tasklist
          • Get Tasks
          • Create a Task
      • Google Forms
        • Connection
        • Actions
          • Get Form Responses
      • Microsoft To Do
        • Connection
        • Actions
          • Tasklist
            • Create a Tasklist
            • Get Tasklists
            • Update a Tasklist
            • Delete a Tasklist
          • Task
            • Get Tasks
            • Create a Task
            • Update a Task
            • Delete a Task
          • Checklist
            • Get Checklist
            • Create a Checklist Item
            • Update a Checklist Item
            • Delete a Checklist Item
      • RSS
        • Connection
        • Actions
          • Get RSS Feed
    • SNS
      • LinkedIn
        • Connection
        • Actions
          • Post a Text Article
          • Post a Share Article
    • Advertisement
      • Meta(Facebook) Business Center
        • Connection
        • Actions
          • Get Leads
          • Ad Account Insights
          • Campaign Insights
          • Adset Insights
          • Ad Insights
        • Trouble Shootings
      • NAVER Search Ads
        • Connection
        • Actions
          • Campaign Stats
          • Adgroup Stats
          • Keyword Stats
          • Criterion Stats
          • Keyword Tool
      • Kakao Keyword Ads
        • Connection
        • Actions
          • View report on ad accounts
          • View reports on campaigns
          • View reports on ad groups
          • View reports on keywords
          • View reports on creatives
        • Trouble Shootings
      • Kakao Moment
        • Connection
        • Actions
          • View report on ad account
          • View reports on campaigns
          • View reports on ad groups
          • View reports on creatives
        • Trouble Shootings
      • Google Ads
        • Connection
        • Actions
          • Campaign Insights
          • Ad Group Insights
          • Ad Group Ad Insights
          • GAQL Execution
    • ERP
      • ECOUNT ERP
        • Connection
        • Actions
          • New Customer/Vendor
          • New Item
          • New Purchase
          • New Quotation
          • New Sales
          • New Sales Order
          • Invoice II Auto Journal (Sales)
          • Invoice II Auto Journal (Purchase)
      • Pipedrive CRM
        • Connection
        • Actions
          • Activity
            • Get all activities assigned to a particular user
            • Add an activity
            • Delete an activity
          • Deals
            • Get all deals
            • List participants of a deal
            • List products attached to a deal
            • Add a deal
            • Duplicate deal
            • Add a participant to a deal
            • Add a Product To a Deal
            • Update a deal
            • Delete a deal
            • Delete a participant from a deal
            • Delete an attached product from a deal
          • Leads
            • Get all leads
            • Add a lead
            • Update a lead
          • Organizations
            • Get all organizations
            • Add an organization
            • Delete an organization
            • List mail messages associated with an organization
            • List followers of an organization
          • Persons
            • Get all persons
            • List products associated with a person
            • Add a person
            • Delete a person
          • Products
            • Get all products
            • Get deals where a product is attached to
            • List followers of a product
            • Add a product
            • Update a product
            • Delete a product
    • Commerce
      • Woo Commerce
        • Connection
        • Actions
          • Create a Coupon
          • List All Coupons
          • Update a Coupon
          • Delete a Coupon
          • Create a Customer
          • List All Customers
          • Update a Customer
          • Delete an User
          • List All Orders
          • Create a Product
          • List All Products
          • Update a Product
          • Duplicate Product
          • Delete a Product
          • Retrieve Sales Report
      • Imweb
        • Connection
        • Actions
          • Get All Coupons
          • Get All Inquires
          • Post a Inquiry Answer
          • Get All User
          • Get All Orders
          • Get All Products
          • Get All Reviews
    • AI
      • OpenAI API (ChatGPT)
        • Connection
        • Actions
          • Chat
            • Create Chat Completion
            • Get Chat Completion
            • Get Chat Messages
            • Get List Chat Completions
            • Update a Chat Completion
            • Delete a Chat Completion
          • Embedding
            • Create Embeddings
          • Moderation
            • Create Moderation
      • Anthropic (Claude)
        • Connection
        • Actions
          • Messages
          • Count Message Token
      • Google Gemini
        • Connection
        • Actions
          • Text Generation
          • Text Generation (Extended)
          • Counting Tokens
          • Embeddings
      • Perplexity
        • Connection
        • Actions
          • Chat Completions
      • xAI (Grok)
        • Connection
        • Actions
          • Chat completions
          • Get deferred chat completions
          • Tokenize text
  • Automation
    • Getting Start
    • Tips
      • Reference value assignment
      • How to use references
    • Running the app
      • Manual Execution Button
      • Schedule
    • Add Filters
      • Text, URL Filter
      • Number, Percentage, Currency Filter
      • Datetime Filter
    • Transform Type (Optional)
      • Text
      • Number
      • Percentage
      • Datetime
      • Currency
      • URL
  • Dataflow
    • Getting Start
    • Quickstart Guide
    • Reference value assignment
    • How to use
      • Manual Execution
      • Schedule
      • Webhook
  • Settings
    • Organization & Team
    • Run Count & Run History
    • Schedule Management
  • FAQ & Policy
    • Email Change Request
    • Pricing & Subscription Cancellation
    • Roles & Management
    • Secure Policies
      • Access Controls
      • Privacy Policy
      • Security Methods
Powered by GitBook
On this page
  • User Interface
  • Response Datas

Was this helpful?

  1. Apps
  2. ERP
  3. Pipedrive CRM
  4. Actions
  5. Deals

Get all deals

Last updated 22 days ago

Was this helpful?

User Interface

Field
Description
Comment

Order By

  • ID

  • Update time

  • Add time

Order Direction

  • Ascending (Default)

  • Descending

Status

  • All not deleted

  • Open

  • Won

  • Loat

  • Deleted


Response Datas

Key
Description

id

Deal ID

creator_user_id

Creator User ID

user_id

User ID

person_id

Person ID

org_id

Organization ID

stage_id

Stage ID

title

Title

value

Value

currency

Currency

add_time

Add time

update_time

Update time

stage_change_time

Stage Change Time

active

Active

deleted

Deleted

status

Status

probability

Probability

next_activity_date

Next activity date

next_activity_time

Next activity time

next_activity_id

Next activity ID

last_activity_id

Last activity ID

last_activity_date

Last activity date

lost_reason

Lost reason

visible_to

Visible to

close_time

Close time

pipeline_id

Pipeline ID

won_time

Won time

first_won_time

First won time

lost_time

Lost time

products_count

Products count

files_count

Files count

notes_count

Notes count

followers_count

Followers count

email_messages_count

Email messages count

activities_count

Activities count

done_activities_count

Done activities count

undone_activities_count

Undone activities count

participants_count

Participants count

expected_close_date

Expected close date

last_incoming_mail_time

Last incoming mail time

last_outgoing_mail_time

Last outgoing mail time

label

Label

local_won_date

Local won date

local_lost_date

Local lost date

local_close_date

Local close date

origin

Origin

origin_id

Origin ID

channel

Channel

channel_id

Channel ID

stage_order_nr

Stage order number

person_name

Person name

org_name

Organization name

next_activity_subject

Next activity subject

next_activity_type

Next activity type

next_activity_duration

Next activity duration

next_activity_note

Next activity note

formatted_value

Formatted value

weighted_value

Weighted value

formatted_weighted_value

Formatted weighted value

weighted_value_currency

Weighted value currency

rotten_time

Rotten time

owner_name

Owner name

cc_email

Email CC

org_hidden

Orgnization hidden

person_hidden

Person hidden

The value of visible_to varies depending on your subscription plan. This field defines the visibility scope of an item within your organization:

Essential / Advanced Plans

  • 1: Owner & Followers

  • 3: Entire Company

Professional / Enterprise Plans

  • 1: Owner

  • 3: Owner’s Visibility Group

  • 5: Owner’s Visibility Group & Subgroups

  • 7: Entire Company

All displayed dates and times are retrieved in UTC (Coordinated Universal Time).