CRM Search failing for double quotes not returning correct result set

SOLVE
Highlighted
New Contributor

Hi Team,

 

When I am using double quotes in CRM Search it is not returning correct result. Please find my details below -

Scenario-1: "propertyName": "deal_unique_id" i have used double quotes, didn't return correct result
----------------------------------------------------------------------------------------------------
Deal Search Input
{
"filterGroups": [
{
"filters": [
{
"propertyName": "oracle_account_number",
"operator": "EQ",
"value": "110192"
},
{
"propertyName": "enterprise_site_id",
"operator": "EQ",
"value": "114795"
},
{
"propertyName": "deal_unique_id",
"operator": "EQ",
"value": "114795-226--Sof-Tray Classic Sheets (0.035\\\")"
}
]
}
]
}
Deal Search Output
{
"total": 0,
"results": []
}

Scenario-2: I haven't used double quotes, did return correct result
------------------------------------------------------------------
Deal Search Input
{
"filterGroups": [
{
"filters": [
{
"propertyName": "oracle_account_number",
"operator": "EQ",
"value": "110192"
},
{
"propertyName": "enterprise_site_id",
"operator": "EQ",
"value": "114795"
}
]
}
]
}
Deal Search Output
{
"total": 1,
"results": [
{
"id": "2741226816",
"properties": {
"amount": null,
"closedate": null,
"createdate": "2020-07-31T21:00:04.034Z",
"dealname": "Sku:114795-226--Sof-Tray Classic Sheets (0.035\")",
"dealstage": null,
"hs_lastmodifieddate": "2020-07-31T21:00:11.900Z",
"hs_object_id": "2741226816",
"pipeline": null
},
"createdAt": "2020-07-31T21:00:04.034Z",
"updatedAt": "2020-07-31T21:00:11.900Z",
"archived": false
}
]
}

0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Solution
HubSpot Moderator

Hey @tanmay,

 

It looks like you posted a similar thread here and I've responded on that forum thread.  Do check it out there! Thank you!

View solution in original post

0 Upvotes
1 Reply 1
Highlighted
Solution
HubSpot Moderator

Hey @tanmay,

 

It looks like you posted a similar thread here and I've responded on that forum thread.  Do check it out there! Thank you!

View solution in original post

0 Upvotes