Salesforce Input Tool error when using CreateDate Date Literals or CreateDate > Date

[calloni]

Hello all

I am getting the below error whenever I use a Custom Query that contains CreatedDate > 'Date' or CreatedDate = LAST_N_DAYS:2 

But when I ran it as CreatedDate = YESTERDAY it runs fine.

When I click "Validate" in any of these queries, Alteryx is able to return the total of rows retrieved without problems.

Does anyone see this too?

I read in other treads that this can be related to v4.1. I downloaded and installed V4.0 but how can I make Alteryx use the older version when 4.1 is installed?

Thanks in advance

Rodrigo

Error: Salesforce Input (85): Traceback (most recent call last):
File "main.py", line 163, in pi_push_all_records
File "C:\Users\rcalloni\AppData\Roaming\Alteryx\Engine\../Tools\SalesforceInput_v4.1.0\engine\sf_queries.py", line 76, in process_query
loop.run_until_complete(retrieve_query_json(self, query_endpoint, header))
File "C:\Users\rcalloni\AppData\Local\Alteryx\bin\Miniconda3\Lib\asyncio\base_events.py", line 484, in run_until_complete
return future.result()
File "C:\Users\rcalloni\AppData\Roaming\Alteryx\Engine\../Tools\SalesforceInput_v4.1.0\engine\sf_queries.py", line 43, in retrieve_query_json
if self.json_parse == 'True' and self.query_type == 'customQuery' and self.parse_query_flag == 'output_json':
AttributeError: 'AyxPlugin' object has no attribute 'parse_query_flag'

[BrandonB · Accepted solution]

If you right click on the salesforce tool in the toolbar you can select "show deprecated tools" which will show the previous version of the tool as well. 

[calloni]

Oh, one more trick 🙂 Thanks Brandon!