Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

calloni
9 - Comet

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'

 

2 REPLIES 2
BrandonB
Alteryx
Alteryx

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
9 - Comet

Oh, one more trick 🙂 Thanks Brandon!

Labels
Top Solution Authors