GetPipelineReport Function Definition
As the name suggests, the GetPipelineReport function is used to retrieve the data from a pipeline report. It will include the contact and pipeline data for any contacts/companies in the pipeline.
When calling this function, the Function parameter sent to the API should be set to GetPipelineReport.
If successful, this function will return an array with a list of contacts and their pipeline information (or an empty array if there are no results that match your parameters).
PipelineId - The unique identifier of the pipeline you want to retrieve. You can get a list of your PipelineIds here. *Note: PipelineId should be treated like a string, NOT an integer or any other number type.*
SortBy - The field you'd like to sort the results by. Can be Priority, DateNote (the date of the last pipeline update), ContactName, or Status.
NumRows (optional) - The number of records returned. The default is 100, but you can set it to any number between 1 and 500. Note that if a contact has more than one pipeline attached to them, they might appear more than once.
Page (optional) - Use this if your results are limited by the number of Rows. For example, if your first search is capped at NumRows, you can then run a second search with Page = 2, and then another with Page = 3 in order to retrieve even more results.
SortDirection (optional) - Can be ASC to sort from low to high or DESC to sort from high to low. Defaults to ASC.
UserFilter (optional) - Defaults to show all records the API user has access to, but you can pass in a specific UserId to only show contacts assigned to that user. Here are instructions for finding the UserId.
StatusFilter (optional) - Set which statuses to return. By default, only open statuses will be returned but you can set this to "all" to show all statuses (open and closed), "closed" to only show closed statuses, or pass a specific StatusId to only show that particular status. You can get a list of your StatusIds here.
This code shows how to retrieve the data from your pipeline report via the API.