API to query specific column in pieplie

[Koomi]

Hello,

In our pipeline we would like to read all of the individual deals and their content but only of a specific column.

Is this possible with the API?

[Mike_Eastwood]

Hi @Koomi 

Yes, you can access the Deal Information from the API.

There's the Deals API and CRM Pipelines (seems to lack some functionality) replaces the Deals Pipelines API.

...BUT...

It would be much easier to create a Filter (on your Deals page set to Table View) to show only the deals in Closed Won and set the columns to show exactly the information you want.

Does this do want you want or did I over simplify?

Mike

[Koomi]

Thank you for the prompt reply Mike!

What we want to do is read that specific numerical field and tally up the number and display it in another application we have.

So is that possible with the APIs you suggested?

[Mike_Eastwood]

Thank you for the extra detail - yes, the API is the way to go.

We do the same for one of our clients. We built a custom dashboard that pulls all the information from HubSpot and displays it in a table with totals, sort by region, total by region, etc.

Have fun

Mike

[Koomi]

But we only want to pull from one column. So that is possible correct?

[Mike_Eastwood]

Ummm... not that easy.

With the Deals API you can specifiy the Property (Column) you want.

But...

You're still going to have to process the Deals to filter out what you want, handle pagination (if you're dealing with more than 100 deals), filtering date ranges, etc.

So, you've got some fun and games ahead of you.

Mike

[Koomi · Accepted solution]

Thank you!