We use cookies to make HubSpot's community a better place. Cookies help to provide a more personalized experience and relevant advertising for you, and web analytics for us. To learn more, and to see a full list of cookies we use, check out our Cookie Policy (baked goods not included).
Mar 8, 2022 3:48 PM
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.
Solved! Go to Solution.
Mar 9, 2022 11:40 AM
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
Mar 10, 2022 8:34 AM
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
Mar 9, 2022 11:40 AM
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
Mar 10, 2022 8:34 AM
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
Mar 10, 2022 4:03 PM
Thanks you for adding your solution. This is how we make the Community the wonderful place that it is!