Hi guys,
So I’m creating a scenario to extract planning, project and account data from Odoo, calculate planning efforts and write them back to the planning object in Odoo. Currently I’m stuck fetching account.analytic.line data. I need to filter the results for data of last month (between first day of last month and last day of last month).
I have made a small step in between to calculate these and added them as a filter in my Search and Read step. It looks as follows:
[[["date",">=","{{4.first_day_last_month}}"],["date","<=","{{4.last_day_last_month}}"]]]
hardcoded:
[[["date",">=","2024-08-01"],["date","<=","2024-08-31"]]]
This throws an error in the logs:
The operation failed with an error. [1] Traceback (most recent call last): File “/opt/approot/build.20240829-161236-72fc1543/parts/odoo/odoo/addons/base/controllers/rpc.py”, line 88, in xmlrpc_2 response = self._xmlrpc(service) File “/opt/approot/build.20240829-161236-72fc1543/parts/odoo/odoo/addons/base/controllers/rpc.py”, line 67, in _xmlrpc params, method = loads(data) File “/usr/lib/python3.8/xmlrpc/client.py”, line 1016, in loads p.feed(data) File “/usr/lib/python3.8/xmlrpc/client.py”, line 438, in feed self._parser.Parse(data, 0) xml.parsers.expat.ExpatError: not well-formed (invalid token): line 32, column 280
I have already tried multiple different things, also to test the ‘<’ and ‘<=’ separatly in a single filter and these operators seem to throw the error. The operators ‘>’ and ‘>=’ work fine, also when combined. I validated the output and these work as intended.
I’ve tested all the possible scenario’s with the variables and the hard-coded values to be 100% sure the problem lies with the ‘<’ and ‘<=’ operators.
I already tried asking help of the AI (beta) but it doesn’t understand what is happening.
Can anyone help me with this please? 
Kind regards,
Alex