Hi,
Is there a way to make an API request using multiple fields for AND filtering? (instead of the OR filtering that you describe in the API documentation).
In other words, if I want to create an HTTP-request for all records from only a certain customer (or maybe any of two customers, using the “&” to say customer A OR customer B)
AND only from certain weeks of the year (eg. week 1, 2, 3 and 4, using the again the “&”-sign multiple times to say I want a record if it is from either week 1 OR 2 OR 3 OR 4),
how do I specify the “AND” that is supposed to go between the customer filter and the week filter?
Thank you
Kind regards
Anders
The conditions for the API between different fields are always AND together. They are only OR together when the conditions are for the same field. In your case it looks like you can simply use & and append them all together and the conditions should work.
1 Like
Perfect 
Thank you so much, Jeff
What if an AND is needed in the same field?
Like (date1>‘2025-01-01’ and date1<‘2025-02-01’)
or something like that?
There are date and number greater, less than, greater than equals, less than equals operators you can use. You can just use them on the same field and they will be AND together. Please see our api page on filter conditions for detail:
You just said on the prior question that “where” in the same field is ORed.
How can you write (date>‘2025-01-01’ and date<‘2025-02-01’) with AND?
Unless there is a NOT operator, which I could not find.
Sorry I missed your followup. The where conditions for selection fields are combined by OR to filter multiple options. The where < > >= <= operators for date fields are AND together so that they can be used to filter out a date range.