APIs & Integrations

Sylvain_T
Participant

Fetch Deals Custom Properties

Résolue

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 Votes
2 Solutions acceptées
dennisedson
Solution
Équipe de développement de HubSpot
Équipe de développement de HubSpot

Fetch Deals Custom Properties

Résolue

@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

Voir la solution dans l'envoi d'origine

Sylvain_T
Solution
Participant

Fetch Deals Custom Properties

Résolue

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 

Voir la solution dans l'envoi d'origine

3 Réponses
dennisedson
Solution
Équipe de développement de HubSpot
Équipe de développement de HubSpot

Fetch Deals Custom Properties

Résolue

@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

Résolue

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
Équipe de développement de HubSpot
Équipe de développement de HubSpot

Fetch Deals Custom Properties

Résolue

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