Search code examples
pythonsalesforce

how to solve python code error (TooManyRedirects: Exceeded 30 redirects)


i've python coode retriving data from salesforce and it was working well, from a few days i was running the code but it didn't and show me an error message (TooManyRedirects: Exceeded 30 redirects), i tried to search the meaning of it but i didn't found any result

Python Code:-

start_time = datetime.now()

#Access to Salesforce
sf = Salesforce(username='-----',password='-----',security_token='-----')

# Salesforce Reports Paths
Accepted_Cases = '00O6N000000ZkQiUAK'
New_Case = '00O6N000000SkDaUAK'
WF_Case_Dispostions  = '00O6N000000SkDVUA0'
Total_Reply_by_Agent = '00O6N000000ZkQTUA0'
#Offered_Cases_T2 = '00O6N000000SqclUAC'

# Salesforce Reports
Accepted_Cases_df = pd.read_csv(StringIO(requests.get(f'https://altayyargroup.lightning.force.com/{Accepted_Cases}?isdtp=p1&export=1&enc=UTF-8&xf=csv', headers=sf.headers, cookies={'sid': sf.session_id}).content.decode('utf-8')))
New_Case_df = pd.read_csv(StringIO(requests.get(f'https://altayyargroup.lightning.force.com/{New_Case}?isdtp=p1&export=1&enc=UTF-8&xf=csv', headers=sf.headers, cookies={'sid': sf.session_id}).content.decode('utf-8')))
WF_Case_Dispostions_df = pd.read_csv(StringIO(requests.get(f'https://altayyargroup.lightning.force.com/{WF_Case_Dispostions}?isdtp=p1&export=1&enc=UTF-8&xf=csv', headers=sf.headers, cookies={'sid': sf.session_id}).content.decode('utf-8')))
Total_Reply_by_Agent_df = pd.read_csv(StringIO(requests.get(f'https://altayyargroup.lightning.force.com/{Total_Reply_by_Agent}?isdtp=p1&export=1&enc=UTF-8&xf=csv', headers=sf.headers, cookies={'sid': sf.session_id}).content.decode('utf-8')))
#Offered_Cases_T2_df = pd.read_csv(StringIO(requests.get(f'https://altayyargroup.lightning.force.com/{Offered_Cases_T2}?isdtp=p1&export=1&enc=UTF-8&xf=csv', headers=sf.headers, cookies={'sid': sf.session_id}).content.decode('utf-8')))

end_time = datetime.now()
print(f'Duration: {end_time - start_time}')

The Error Message:-

TooManyRedirects                          Traceback (most recent call last)
~\AppData\Local\Temp/ipykernel_13988/64063902.py in <module>
     13 # Salesforce Reports
     14 #Accepted_Cases_df = pd.read_csv(StringIO(requests.get(f'https://altayyargroup.lightning.force.com/{Accepted_Cases}?isdtp=p1&export=1&enc=UTF-8&xf=csv', headers=sf.headers, cookies={'sid': sf.session_id}).content.decode('utf-8')))
---> 15 New_Case_df = pd.read_csv(StringIO(requests.get(f'https://altayyargroup.lightning.force.com/{New_Case}?isdtp=p1&export=1&enc=UTF-8&xf=csv', headers=sf.headers, cookies={'sid': sf.session_id}).content.decode('utf-8')))
     16 #WF_Case_Dispostions_df = pd.read_csv(StringIO(requests.get(f'https://altayyargroup.lightning.force.com/{WF_Case_Dispostions}?isdtp=p1&export=1&enc=UTF-8&xf=csv', headers=sf.headers, cookies={'sid': sf.session_id}).content.decode('utf-8')))
     17 #Total_Reply_by_Agent_df = pd.read_csv(StringIO(requests.get(f'https://altayyargroup.lightning.force.com/{Total_Reply_by_Agent}?isdtp=p1&export=1&enc=UTF-8&xf=csv', headers=sf.headers, cookies={'sid': sf.session_id}).content.decode('utf-8')))

~\anaconda3\lib\site-packages\requests\api.py in get(url, params, **kwargs)
     73     """
     74 
---> 75     return request('get', url, params=params, **kwargs)
     76 
     77 

~\anaconda3\lib\site-packages\requests\api.py in request(method, url, **kwargs)
     59     # cases, and look like a memory leak in others.
     60     with sessions.Session() as session:
---> 61         return session.request(method=method, url=url, **kwargs)
     62 
     63 

~\anaconda3\lib\site-packages\requests\sessions.py in request(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)
    540         }
    541         send_kwargs.update(settings)
--> 542         resp = self.send(prep, **send_kwargs)
    543 
    544         return resp

~\anaconda3\lib\site-packages\requests\sessions.py in send(self, request, **kwargs)
    675             # Redirect resolving generator.
    676             gen = self.resolve_redirects(r, request, **kwargs)
--> 677             history = [resp for resp in gen]
    678         else:
    679             history = []

~\anaconda3\lib\site-packages\requests\sessions.py in <listcomp>(.0)
    675             # Redirect resolving generator.
    676             gen = self.resolve_redirects(r, request, **kwargs)
--> 677             history = [resp for resp in gen]
    678         else:
    679             history = []

~\anaconda3\lib\site-packages\requests\sessions.py in resolve_redirects(self, resp, req, stream, timeout, verify, cert, proxies, yield_requests, **adapter_kwargs)
    164 
    165             if len(resp.history) >= self.max_redirects:
--> 166                 raise TooManyRedirects('Exceeded {} redirects.'.format(self.max_redirects), response=resp)
    167 
    168             # Release the connection back into the pool.

TooManyRedirects: Exceeded 30 redirects.

Solution

  • With enhanced domains the domain name has changed Please change the domain name from https://altayyargroup.lightning.force.com

    to

    https://altayyargroup.my.salesforce.com