logo-darkPipe0

Salesforce opportunities

List opportunities from your Salesforce org: identity columns (id, name, amount) plus a JSON record with the standard field set (including IsClosed/IsWon). Filter by status, stage, amount, or field conditions — or run one of the org's own list views.

ProviderBilling ModeCredentials
Cost per page
Docs
P
Salesforce
Per Search
User
n/a

Output Fields

Enabled by defaultThese fields are returned without extra config.4
salesforce_record_id
string
deal_name
string
deal_amount
number
salesforce_opportunity_match
json

Code Example

const options = {
  method: 'POST',
  headers: {'content-type': 'application/json', authorization: 'Bearer <TOKEN>'},
  body: JSON.stringify({
    search: {
      search_id: 'opportunities:salesforce@1',
      connector: {
        strategy: 'first',
        connections: [{type: 'vault', connection: 'salesforce_org-00DKJ0000001abc2AE'}]
      },
      config: {
        filters: {
          logic: 'and',
          conditions: [
            {
              property: 'value',
              field_name: 'CloseDate',
              operator: 'lte',
              value: '2026-09-30'
            }
          ]
        },
        list_view: '',
        status: 'open',
        stage: '',
        amount: {min: 10000, max: null},
        owner: '',
        created_within: '',
        modified_within: 'l30d',
        limit: 100,
        cursor: ''
      }
    }
  })
};

fetch('https://api.pipe0.com/v1/search/run', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));
import requests

url = "https://api.pipe0.com/v1/search/run"

payload = { "search": {
        "search_id": "opportunities:salesforce@1",
        "connector": {
            "strategy": "first",
            "connections": [
                {
                    "type": "vault",
                    "connection": "salesforce_org-00DKJ0000001abc2AE"
                }
            ]
        },
        "config": {
            "filters": {
                "logic": "and",
                "conditions": [
                    {
                        "property": "value",
                        "field_name": "CloseDate",
                        "operator": "lte",
                        "value": "2026-09-30"
                    }
                ]
            },
            "list_view": "",
            "status": "open",
            "stage": "",
            "amount": {
                "min": 10000,
                "max": None
            },
            "owner": "",
            "created_within": "",
            "modified_within": "l30d",
            "limit": 100,
            "cursor": ""
        }
    } }
headers = {
    "content-type": "application/json",
    "authorization": "Bearer <TOKEN>"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)
curl --request POST \
     --url https://api.pipe0.com/v1/search/run \
     --header 'authorization: Bearer <TOKEN>' \
     --header 'content-type: application/json' \
     --data '
{
  "search": {
    "search_id": "opportunities:salesforce@1",
    "connector": {
      "strategy": "first",
      "connections": [
        {
          "type": "vault",
          "connection": "salesforce_org-00DKJ0000001abc2AE"
        }
      ]
    },
    "config": {
      "filters": {
        "logic": "and",
        "conditions": [
          {
            "property": "value",
            "field_name": "CloseDate",
            "operator": "lte",
            "value": "2026-09-30"
          }
        ]
      },
      "list_view": "",
      "status": "open",
      "stage": "",
      "amount": {
        "min": 10000,
        "max": null
      },
      "owner": "",
      "created_within": "",
      "modified_within": "l30d",
      "limit": 100,
      "cursor": ""
    }
  }
}
'
package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://api.pipe0.com/v1/search/run"

	payload := strings.NewReader("{\"search\":{\"search_id\":\"opportunities:salesforce@1\",\"connector\":{\"strategy\":\"first\",\"connections\":[{\"type\":\"vault\",\"connection\":\"salesforce_org-00DKJ0000001abc2AE\"}]},\"config\":{\"filters\":{\"logic\":\"and\",\"conditions\":[{\"property\":\"value\",\"field_name\":\"CloseDate\",\"operator\":\"lte\",\"value\":\"2026-09-30\"}]},\"list_view\":\"\",\"status\":\"open\",\"stage\":\"\",\"amount\":{\"min\":10000,\"max\":null},\"owner\":\"\",\"created_within\":\"\",\"modified_within\":\"l30d\",\"limit\":100,\"cursor\":\"\"}}}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("content-type", "application/json")
	req.Header.Add("authorization", "Bearer <TOKEN>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

$response = $client->request('POST', 'https://api.pipe0.com/v1/search/run', [
  'body' => '{"search":{"search_id":"opportunities:salesforce@1","connector":{"strategy":"first","connections":[{"type":"vault","connection":"salesforce_org-00DKJ0000001abc2AE"}]},"config":{"filters":{"logic":"and","conditions":[{"property":"value","field_name":"CloseDate","operator":"lte","value":"2026-09-30"}]},"list_view":"","status":"open","stage":"","amount":{"min":10000,"max":null},"owner":"","created_within":"","modified_within":"l30d","limit":100,"cursor":""}}}',
  'headers' => [
    'authorization' => 'Bearer <TOKEN>',
    'content-type' => 'application/json',
  ],
]);

echo $response->getBody();
POST /v1/search/run HTTP/1.1

Content-Type: application/json

Authorization: Bearer <TOKEN>

Host: api.pipe0.com

Content-Length: 460



{"search":{"search_id":"opportunities:salesforce@1","connector":{"strategy":"first","connections":[{"type":"vault","connection":"salesforce_org-00DKJ0000001abc2AE"}]},"config":{"filters":{"logic":"and","conditions":[{"property":"value","field_name":"CloseDate","operator":"lte","value":"2026-09-30"}]},"list_view":"","status":"open","stage":"","amount":{"min":10000,"max":null},"owner":"","created_within":"","modified_within":"l30d","limit":100,"cursor":""}}}