Get records from a Team Pipeline
Retrieve the pipeline records from a specific Team Pipeline.
Endpoints
Request URL
Bigin APIs are available across eight different domains, and you must choose the one relevant to your data center (DC):
- US
- EU
- AU
- IN
- CN
- JP
- SA
- CA
Authorization
For this endpoint, pass the access token as an authorization header. See OAuth Authentication for more information about access tokens.
Authorization: Zoho-oauthtoken <ACCESS_TOKEN>
You must authenticate using an access token that is associated with the following scope:
- ZohoBigin.modules.Pipelines.ALL
Request parameters
The available request parameters are given below:
Query parameters
pipeline_id stringRequired
The unique identification (pipeline_id) of a Team Pipeline. You can get the pipeline ID from the Layouts Metadata API by accessing the id value of a Team Pipeline.
fields stringRequired
Specify the fields you want to retrieve in the API response. It accepts multiple field API names separated by commas. You can get the field API names from the Fields Metadata API by accessing the api_name value for each field. For example, if you want to fetch pipeline records and include fields like Deal_Name and Stage, you can pass them as fields=Deal_Name,Stage.
You can pass up to 50 fields.
page integerOptional
Represents the page index. This parameter lists the records from the given page index. The default value is 1.
per_page integerOptional
Represents the number of records per page index. The default value is 200, which means up to 200 records can be retrieved per page index.
sort_order stringOptional
Specify the sorting order for list of records. It can be asc for ascending order or desc for descending order.
sort_by stringOptional
Specify the field API name based on which the records will be sorted. The supported fields are id, Created_Time, and Modified_Time.
Notes: The page and per_page parameters are utilized when you want to fetch more than 200 records. Since the maximum number of records per API call is 200, fetching records beyond the 200th position is not possible in a single call. However, by making two API calls with page values of 1 and 2 and a per_page value of 200, all 400 records can be retrieved.
Sample request
Copiedcurl "https://www.zohoapis.com/bigin/v2/Pipelines?pipeline_id=2034020000000095023&fields=Deal_Name,Sub_Pipeline,Stage,Closing_Date&page=1&per_page=10" \
-X GET \
-H "Authorization: Zoho-oauthtoken 1000.8cb99dxxxxxxxxxxxxx9be93.9b8xxxxxxxxxxxxxxxf"Copiedresponse = invokeurl
[
url: "https://www.zohoapis.com/bigin/v2/Pipelines?pipeline_id=2034020000000095023&fields=Deal_Name,Sub_Pipeline,Stage,Closing_Date&page=1&per_page=10"
type: GET
connection:"connection_link_name"
];
info response;Response object
The response object contains a list of pipeline records belonging to a particular Team Pipeline, filtered based on the query parameters provided.
Possible error codes
The response of this resource includes HTTP status and error codes.
Sample response
Copied{
"data": [
{
"Deal_Name": "City Tour Package",
"Stage": "Qualification",
"id": "2034020000000478136",
"Closing_Date": "2023-05-31",
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
},
{
"Deal_Name": "Cruise Package",
"Stage": "Proposal/Price Quote",
"id": "2034020000000478164",
"Closing_Date": "2023-06-20",
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
},
{
"Deal_Name": "Ski Vacation Package",
"Stage": "Negotiation/Review",
"id": "2034020000000478192",
"Closing_Date": "2023-07-05",
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
},
{
"Deal_Name": "Luxury Getaway Package",
"Stage": "Needs Analysis",
"id": "2034020000000478220",
"Closing_Date": "2023-07-31",
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
},
{
"Deal_Name": "Cultural Tour Package",
"Stage": "Closed Won",
"id": "2034020000000478248",
"Closing_Date": "2023-08-15",
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
},
{
"Deal_Name": "Wildlife Safari Package",
"Stage": "Proposal/Price Quote",
"id": "2034020000000478276",
"Closing_Date": "2023-08-31",
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
},
{
"Deal_Name": "Food and Wine Tour Package",
"Stage": "Closed Lost",
"id": "2034020000000478304",
"Closing_Date": "2023-09-15",
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
},
{
"Deal_Name": "Wellness Retreat Package",
"Stage": "Negotiation/Review",
"id": "2034020000000478332",
"Closing_Date": "2023-09-30",
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
},
{
"Deal_Name": "Beach Vacation Package Research",
"Stage": "Market Research",
"id": "2034020000000478382",
"Closing_Date": null,
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
},
{
"Deal_Name": "Adventure Tour Campaign Planning",
"Stage": "Campaign Planning",
"id": "2034020000000478392",
"Closing_Date": null,
"Pipeline": {
"name": "Sales - Marketing",
"id": "2034020000000095023"
}
}
],
"info": {
"per_page": 10,
"next_page_token": "7e735c394ae76c6eae4a74b2700dfbbd6e11b64a3b86f3aabb17486c5cf92e96036a423fbc13307e953f04ba4bec79615f6df14fd9307c8dd312f31832529082cad036afbbeeef53113d65e438257862e589271700296d817153bdd649239a156e3b1a204dc86c53fa1b17ec7aac5cd11b872eaafb414f08a1f2fc77d5a51f92b8b7bb7fef9ddc6694e7fce8c610d854",
"count": 10,
"sort_by": "id",
"page": 1,
"previous_page_token": null,
"page_token_expiry": "2023-07-17T12:19:35+05:30",
"sort_order": "asc",
"more_records": true
}
}