topic Re: Salesforce Input Tool - Existing reports error in Alteryx Designer Desktop Discussions

Salesforce Input Tool - Existing reports error

fredrikw — Thu, 29 Aug 2019 13:12:55 GMT

When running the flow, trying to connect to a Salesforce report, I get the following error message.

Anyone that knows how to fix this?

Error: Salesforce Input (1): Traceback (most recent call last):
File "main.py", line 160, in pi_push_all_records
File "C:\Users\b34434\AppData\Roaming\Alteryx\Engine\../Tools\SalesforceInput_v4.1.0\engine\sf_reports.py", line 13, in process_report execute_report_run(self=self)

File "C:\Users\b34434\AppData\Roaming\Alteryx\Engine\../Tools\SalesforceInput_v4.1.0\engine\sf_reports.py", line 26,
in execute_report_run pull_report_data(self=self, report_results_id=report_results_id)
File "C:\Users\b34434\AppData\Roaming\Alteryx\Engine\../Tools\SalesforceInput_v4.1.0\engine\sf_reports.py", line 38, in pull_report_data with sf_proxy.manual_proxy_context_for_url(self.session, report_endpoint): NameError: name 'report_endpoint' is not defined

Re: Salesforce Input Tool - Existing reports error

geraldo — Thu, 29 Aug 2019 18:01:37 GMT

Hi,

Does this message appear even if you have not selected the report?

[]

Re: Salesforce Input Tool - Existing reports error

55dhr — Thu, 29 Aug 2019 19:39:33 GMT

I have the exact issue as stated above. This would save us a lot of time if we could figure this one out! Would love to do a resolution video if we do.

Geraldo - the answer in our case would be "No".

Re: Salesforce Input Tool - Existing reports error

geraldo — Thu, 29 Aug 2019 19:51:51 GMT

hi @55dhr

I don't have any reports on my salesforce to test.

I have version 4.0 and 4.1 installed.
I am testing the tool for possible errors.

When I run I am selecting the version. As picture below.

[]

Re: Salesforce Input Tool - Existing reports error

55dhr — Thu, 29 Aug 2019 19:59:46 GMT

Thanks for all your help.

I don't have the option to choose a version probably because I have only one.

Re: Salesforce Input Tool - Existing reports error

geraldo — Thu, 29 Aug 2019 20:07:11 GMT

Hi,

But the mistake is that you didn't have access to the report. You can use the salesforce input tool normally for other activities.

[]

Re: Salesforce Input Tool - Existing reports error

55dhr — Thu, 29 Aug 2019 20:40:22 GMT

Geraldo, I'm not sure what you mean by "...didn't have access to the report."

There was the option to pick the report as shown below...

Again, I really appreciate you looking into this. As already stated, this would save a lot of time.

Re: Salesforce Input Tool - Existing reports error

fredrikw — Fri, 30 Aug 2019 09:34:22 GMT

Hi,

Same answers as 55dhr.

I am choosing a report that I made myself in Salesforce.

I am using Alteryx version 2019.2, and Salesforce input tool version 4.1.0.

Re: Salesforce Input Tool - Existing reports error

55dhr — Fri, 30 Aug 2019 13:15:21 GMT

Has anyone had success in using the Query Type / Existing Report that may be able to give advice?

Re: Salesforce Input Tool - Existing reports error

fredrikw — Tue, 03 Sep 2019 09:53:53 GMT

Hi,

Just tried with Salesforce Input Tool version 4.0, instead of 4.1.0.

It worked as it should! 🙂

So I guess there is something wrong in the code of version 4.1.0.

Re: Salesforce Input Tool - Existing reports error

geraldo — Tue, 03 Sep 2019 10:58:30 GMT

Hi,

In version 4.1 the python code has been changed to work with proxy. As I put the 2 codes above version 4.0 without proxy and 4.1 with proxy. I already advised to install both versions and select the desired one at the time of execution.

In version 4.0 this error does not occur

[]

Re: Salesforce Input Tool - Existing reports error

Josh394856345 — Wed, 04 Sep 2019 20:40:53 GMT

I'm getting the same error in 4.0

and the download page says:

Salesforce Input Tool Install v4.1 - compatible with Alteryx version 2019.2 and up

Salesforce Input Tool Install v4.0 - compatible with Alteryx version 2018.3 - 2019.1

indicating you should not have them both installed.

All that said, I am more interested in HOW this is done. What is the query to pull an existing report?

Re: Salesforce Input Tool - Existing reports error

geraldo — Wed, 04 Sep 2019 20:50:07 GMT

I have both installed smoothly in version 2019.2 and 2019.3. To extract reports the salesforce input version 4.1 tool is bugged I advised him to install 4.0. I work this way on the designer.

I do not know why it has not tested in version 4.0 I passed it to him how to switch from one version to another and still didn't respond.

[]

Re: Salesforce Input Tool - Existing reports error

calebdugger — Wed, 30 Oct 2019 19:57:44 GMT

So even if we have 2019.3 or more recent you suggest we should download v4.0? How do we uninstall 4.1? Just deleting it in the Tools folder?

Re: Salesforce Input Tool - Existing reports error

JakeS — Thu, 31 Oct 2019 22:09:08 GMT

Hello,

There is a defect created for this issue (DE20556). There is a workaround that can be provided if you reach out to Alteryx Support. Thanks!

Jake

Re: Salesforce Input Tool - Existing reports error

daveheadrick — Wed, 11 Mar 2020 21:24:32 GMT

Had this same issue with 4.1, and below is the fix that worked for me:

Re: Salesforce Input Tool - Existing reports error

gpdimartino — Tue, 15 Dec 2020 13:41:11 GMT

Thank you! That did the trick for me!

Re: Salesforce Input Tool - Existing reports error

esar — Tue, 02 Feb 2021 08:38:24 GMT

@JakeS, @SabrinaCB Any update on when this issue will be fixed and a new version released?

Is there any page where we can follow the status of known issues i.e. DE20556?

Re: Salesforce Input Tool - Existing reports error

Marc_Ponick — Thu, 23 Feb 2023 20:56:51 GMT

Thank you!!!!