topic Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://<salesforce endpoint> in Talend Studio

tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

Anonymous — Thu, 16 Jan 2020 17:50:22 GMT

Hi I am using a Talend Studio 7.1 (license version). And I have this requirement to access data from Saleforce Object (SOQL). Based on my research I can use t_SalesforceInput component. so I've tried creating one with t_SalesforceInput and tLogRow (Main connected). I've also set-up the t_SalesforceInput with the necessary details and was able to connect whenever I try to open the "Module Name" field.

However, upon running the job, I am encountering this error.

"tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://<salesforce endpoint>"

I've already exhausted all the articles about that error and I had no luck finding out the caused of the error to fix it. Can anyone help/assist me on this? Thank you

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

TRF — Thu, 16 Jan 2020 18:08:31 GMT

The salesforce endpoint is probably wrong. Use login.salesforce.com for production only and test.salesforce.com for all other environments.
If you are aligned with this rule, can you share your component settings?

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

Anonymous — Thu, 16 Jan 2020 20:19:45 GMT

Hi TRF,

I was actually able to access the objects in "Module Name". Is it still possible that I got the endpoint wrong? Also, I am not sure what you meant on "test.salesforce.com for all other environments." Is it literally to access that URL? or just to append somewhere in my Salesforce's URL?

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

TRF — Thu, 16 Jan 2020 20:25:38 GMT

Well, if you're able to access the object liste, your connection should be ok. Does the error occurs from the Studio or when running the job from the command line?
Sharing your settings will help to solve your case.

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

Anonymous — Thu, 16 Jan 2020 20:41:44 GMT

I am getting the error right after I execute the job. I am afraid I cant share my settings since there are confidential items indicated in there.

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

TRF — Thu, 16 Jan 2020 21:18:48 GMT

Just make a screenshot and hide critical informations

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

Anonymous — Thu, 16 Jan 2020 21:50:49 GMT

Hi TRF,

See attached screenshots. By the way, do you thing SSO might be the caused? currently our setup is single-sign on.

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

TRF — Fri, 17 Jan 2020 10:02:01 GMT

What's after the API version number (46.0)?

You should not have anything here.

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

Anonymous — Fri, 17 Jan 2020 14:30:37 GMT

Hi TRF,

The whole URL indicated is from "Endpoint" information I got in the "session information" in workbench. I've actually tried removing that last part already but I am still getting the same error. By the way, my profile is set as single-sign on. Do you think this can be the cause of the issue?

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

Anonymous — Fri, 17 Jan 2020 22:18:37 GMT

I am still encountering the issue and it is so frustrating

Re: tSalesforceInput_1 IOException: com.sforce.ws.ConnectionException: Failed to send request to https://

Anonymous — Mon, 27 Jan 2020 19:50:31 GMT

Is there any talend support who can help me with this issue?