# Exact Online: Could not execute the specified command: This $filter parameter is not supported for this resource…

**URL:** <https://community.cdata.com/t/exact-online-could-not-execute-the-specified-command-this-filter-parameter-is-not-supported-for-this-resource/497>\
**Category:** Data Sources\
**Tags:** sql, exact-online, article, driver, cdata-connect-cloud, odata, complex, query, filter\
**Created:** [October 31, 2023, 6:50pm UTC](https://community.cdata.com/t/exact-online-could-not-execute-the-specified-command-this-filter-parameter-is-not-supported-for-this-resource/497 "2023-10-31T18:50:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Skerdian\_Shehaj](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/skerdian_shehaj/32/1243_2.png) [@Skerdian\_Shehaj](https://community.cdata.com/u/Skerdian_Shehaj)\
**Post date:** [October 31, 2023, 6:50pm UTC](https://community.cdata.com/t/exact-online-could-not-execute-the-specified-command-this-filter-parameter-is-not-supported-for-this-resource/497/1 "2023-10-31T18:50:32Z")

</div>

In case you are encountering the following error when running a query that includes a _‘complex’_ filter in Exact Online:

_Could not execute the specified command: This $filter parameter is not supported for this resource. This error may be caused by the following: usage of OData functions such as ‘substringof(…)’, usage of the ‘not’ operator, syntax errors in the $filter parameter, the $filter parameter is too complex._

A straightforward solution to resolve this issue is to toggle the _‘UseBulkAPI’_ property to _‘False’_ in the Connection Editor (connection string), which is typically set to _‘True’_ by default.

E.g.

 ![798fee46-6a41-41a5-9478-50e3bee46c8e.png](https://us1.discourse-cdn.com/cdata/original/1X/58270ecc94b583af2bbe7b62fa8a44a34f3e635b.png)  
Cloud  
 ![0adb0f46-c520-4190-8b1e-3520f91c940d.png](https://us1.discourse-cdn.com/cdata/original/2X/b/bc44cd4617fc88d17c717115a68abcdddcee175d.png)  
ODBC

Please reach out to [support@cdata.com](mailto:support@cdata.com) if this does not resolve the problem for you.
