# Filter Quote

**URL:** <https://community.hubspot.com/t/filter-quote/78397>\
**Category:** APIs & Integrations\
**Tags:** professional\
**Created:** [March 30, 2023, 12:59pm UTC](https://community.hubspot.com/t/filter-quote/78397 "2023-03-30T12:59:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NicolasM](https://avatars.discourse-cdn.com/v4/letter/n/ecccb3/32.png) [@NicolasM](https://community.hubspot.com/u/NicolasM)\
**Post date:** [March 30, 2023, 12:59pm UTC](https://community.hubspot.com/t/filter-quote/78397/1 "2023-03-30T12:59:40Z")

</div>

Hi,

I’m trying to get all the approved quotes from the actual day. I use Make. The filters parameters doesn’t works and I don’t understand why I get all the Quotes.

 ![NicolasM_0-1680181092365.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/c/cc3bfb6d2a456f2569700b3aeeeed19bb79b9d79.png)

Here is values in filters

[{“filters”:[{“propertyName”:“hs\_status”,“operator”:“EQ”,“value”:“APPROVED”},{“propertyName”:“hs\_lastmodifieddate”,“operator”:“GTE”,“value”:“2023-03-30T00:00:00.000Z”},{“propertyName”:“hs\_lastmodifieddate”,“operator”:“LTE”,“value”:“2023-03-30T23:59:59.999Z”}]}]

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [March 31, 2023, 7:46pm UTC](https://community.hubspot.com/t/filter-quote/78397/2 "2023-03-31T19:46:13Z")

</div>

Hey, @NicolasM 👋 It looks like you are using the [Quotes API](https://developers.hubspot.com/docs/api/crm/quotes) endpoint to GET _all_ Quotes. This endpoint doesn’t use a request body for specifying properties, it adds them as a query parameter (in the request URL) It also doesn’t offer the ability to use search operators.

Have you tried using the Search API instead? It allows for properties and filters in the request body.

- [Search API](https://developers.hubspot.com/docs/api/crm/search)
- [Search operators](https://developers.hubspot.com/docs/api/crm/search#:~:text=You%20can%20use%20operators%20in%20filters) for Search API

Have fun building! — Jaycee

---

<div class="post-metadata">

**Author:** ![NicolasM](https://avatars.discourse-cdn.com/v4/letter/n/ecccb3/32.png) [@NicolasM](https://community.hubspot.com/u/NicolasM)\
**Post date:** [March 31, 2023, 9:19pm UTC](https://community.hubspot.com/t/filter-quote/78397/3 "2023-03-31T21:19:11Z")

</div>

Thanks for reply [@Jaycee\_Lewis](https://community.hubspot.com/t5/user/viewprofilepage/user-id/127074) . Indeed I found that the issue was from the endpoint and I finaly use endpoint with search fonction.

I face a new issue with this endpoint. I want to get all the quote accepted, with last modified on today.

Here is the body of my request, and it doesn’t work (error 400)

Do you have an idea of what’s wrong?

\_\_\_\_

{  
“filterGroups”: [  
{  
“filters”: [  
{  
“propertyName”: “hs\_status”,  
“operator”: “EQ”,  
“value”: “APPROVED”  
},  
{  
“propertyName”: “hs\_lastmodifieddate”,  
“operator”: “GTE”,  
“value”: “2023-03-31T00:00:00.000Z”  
},  
{  
“propertyName”: “hs\_lastmodifieddate”,  
“operator”: “LTE”,  
“value”: “2023-03-31T23:59:59.999Z”  
}  
]  
}  
],  
“properties”: [  
“hs\_status”,  
“hs\_lastmodifieddate”  
],  
“limit”: 100  
}

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [March 31, 2023, 10:14pm UTC](https://community.hubspot.com/t/filter-quote/78397/4 "2023-03-31T22:14:03Z")

</div>

Hey, @NicolasM 👋 Have you tried using the BETWEEN operator for “hs\_lastmodifieddate”?

Similar to the example (but using your timestamps) —

```line-numbers
"propertyName":"hs_lastmodifieddate",
 "operator":"BETWEEN",
 "highValue": "1642672800000",
 "value":"1579514400000"

```

Best,

Jaycee