Bulk API request using python failing

It sounds like you have an issue with your SSL certificate chain on the machine where you're running the script.  (Check out this Stackoverflow thread.)

Are you by chance running the commands from an internal server/workstation behind your company's firewall?  Because I used to hit a similar SSO certification error with the Jive Data Export Service (api.jivesoftware.com) because of how our internal network traffic flowed.

If so then as a longer-term solution I would recommend engaging with your IT team to get the proper SSL cert files for your internal cert chain and get them installed on the machine.

But in the short-term, a quicker (but insecure) way to get around the error is to include the verify=False parameter in your requests.get() method call:

date_range = {
    'fromDate': '20210630',
    'toDate': '20210707'
}
headers = {
    'client-id': client_id,
    'Accept': 'application/json'
}
uri = 'https://api.lithium.com/lsi-data/v1/data/export/community/communityid'
response = requests.get(uri, params=date_range, auth=(access_token, ''), headers=headers, verify=False)

Hope this helps!

P.S. I'm planning to build some Bulk API query functionality into my open-source khoros Python library in the next month or two, which should make things even easier.