community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

SalesForce V4 Proxy connections issue and solution

Highlighted
Asteroid

Issue : Salesforce V4 python code fails when the calls goes to salesforce through post with firewall

 

Short Term solution : Add proxy to the calls 

 

async def retrieve_query_json_chunk_parse_response(self, session, endpoint, header):
async with session.get(endpoint, headers = header, proxy="http://yourproxy:port") as response:
....

async def retrieve_query_json_chunk_parse_json(self, session, endpoint, header):
async with session.get(endpoint, headers = header, proxy="http://yourproxy:port") as response:

 

Long Term solution :  Add proxy field in the HTML , JS and python 

 

 

Meteor

Providing additional feedback:

It looks like the configuration GUI for the SalesforceInput_V4.0.0 connector uses HTML and Javascript which is able to navigate our proxy so it looks like things are working (i.e., authentication succeeds and a row count is provided).

 

However, the engine uses Python which, as noted, has some challenges with the proxy. It would be nice if the engine were able to use the proxy information configured into Designer (i.e., URL detected from the system, credentials entered in Designer, etc.). Additionally, our proxy requires certificates so this is yet another challenge. I was able to hack the sf_authorization.py file to provide the proxy info and certificates (similar to what @sathiya did) to get through the authorization but the rest of the call stack (e.g., sf_queries.py) would need to modified to use the proxy configuration info also.

Labels