APIs & Integrations

Sylvain_T
Participant

Fetch Deals Custom Properties

SOLVE

Need to update date thru API but first I'm trying to LOCATE them !

I managed to find Contacts from his email.
Then use the associations.contact in Deals to find appropriate Deal, but I can only see/update the basic values : (Amount, name).
But I need to reach fields our Customer created either by the Group or Properties, but can't find the way...
I'm just turning round into Doc... 
Any help would be appreciated.
Here's a dump of what I can get, but theres dozens of other fields.

Capture d’écran, le 2022-03-08 à 15.47.10.png

0 Upvotes
2 Accepted solutions
dennisedson
Solution
HubSpot Product Team
HubSpot Product Team

Fetch Deals Custom Properties

SOLVE

@Sylvain_T 

Two methods that you can employ to get additional properties.

1.  use a query param to your request to specify properties to be returned &properties=customprop,customprop2

2.  use the search the crm api and add the properties to the json payload.  If you have many props that you need, option 2 is your best bet

View solution in original post

Sylvain_T
Solution
Participant

Fetch Deals Custom Properties

SOLVE

Dennis, 
Thank you for your input. It directed me it the right direction. Althought I wasn't able to test it in PostMan, I've managed to figure it out in my code. So foro the benefit of anyone with this issue:

/* Find related contact and custom fields related to a specific contact ID */
/* Using HubSpot PHP API */

public function findDeal($contactId){
 $hubSpot = \HubSpot\Factory::createWithApiKey(MY_API_KEY_HERE);
 $filter = new \HubSpot\Client\Crm\Deals\Model\Filter();
 $filter 
     ->setOperator('EQ')
     ->setPropertyName('associations.contact')
     ->setValue($contactId);

 $filterGroup = new \HubSpot\Client\Crm\Deals\Model\FilterGroup();
 $filterGroup->setFilters([$filter]);
 
 $searchRequest = new \HubSpot\Client\Crm\Deals\Model\PublicObjectSearchRequest();
  $searchRequest->setFilterGroups([$filterGroup]);
 $searchRequest->setProperties(["name", "amount_in_home_currency", "signature_date__c", "description", "pipeline", ]);
 $t = $searchRequest->getProperties();
 return $hubSpot->crm()->deals()->searchApi()->doSearch($searchRequest);
}

Hope this piece of code will help other as your input helped me, I'm just paying forward !

Have a great day.

Sylvain 

View solution in original post

3 Replies 3
dennisedson
Solution
HubSpot Product Team
HubSpot Product Team

Fetch Deals Custom Properties

SOLVE

@Sylvain_T 

Two methods that you can employ to get additional properties.

1.  use a query param to your request to specify properties to be returned &properties=customprop,customprop2

2.  use the search the crm api and add the properties to the json payload.  If you have many props that you need, option 2 is your best bet

Sylvain_T
Solution
Participant

Fetch Deals Custom Properties

SOLVE

Dennis, 
Thank you for your input. It directed me it the right direction. Althought I wasn't able to test it in PostMan, I've managed to figure it out in my code. So foro the benefit of anyone with this issue:

/* Find related contact and custom fields related to a specific contact ID */
/* Using HubSpot PHP API */

public function findDeal($contactId){
 $hubSpot = \HubSpot\Factory::createWithApiKey(MY_API_KEY_HERE);
 $filter = new \HubSpot\Client\Crm\Deals\Model\Filter();
 $filter 
     ->setOperator('EQ')
     ->setPropertyName('associations.contact')
     ->setValue($contactId);

 $filterGroup = new \HubSpot\Client\Crm\Deals\Model\FilterGroup();
 $filterGroup->setFilters([$filter]);
 
 $searchRequest = new \HubSpot\Client\Crm\Deals\Model\PublicObjectSearchRequest();
  $searchRequest->setFilterGroups([$filterGroup]);
 $searchRequest->setProperties(["name", "amount_in_home_currency", "signature_date__c", "description", "pipeline", ]);
 $t = $searchRequest->getProperties();
 return $hubSpot->crm()->deals()->searchApi()->doSearch($searchRequest);
}

Hope this piece of code will help other as your input helped me, I'm just paying forward !

Have a great day.

Sylvain 

dennisedson
HubSpot Product Team
HubSpot Product Team

Fetch Deals Custom Properties

SOLVE

Thanks you for adding your solution.  This is how we make the Community the wonderful place that it is!