CERTIFICATE_VERIFY_FAILED error for snow_record module

Dear all,

I am trying to upload an attachment to a ServiceNow record, but I am stuck with the error shown below.

fatal: [localhost]: FAILED! => {“attachment”: “***/abc.txt”, “changed”: false, “display_value”: false, “exclude_reference_link”: false, “host”: " dxxxxxx.service-now.com ", “instance”: null, “lookup_field”: “number”, “msg”: “Failed to update record: HTTPSConnectionPool(host=‘dxxxxxx.service-now.com’, port=443): Max retries exceeded with url: /api/now/table/incident?sysparm_query=number%3DINC0010002&sysparm_limit=10000&sysparm_offset=0&sysparm_display_value=False&sysparm_suppress_pagination_header=False&sysparm_exclude_reference_link=False&sysparm_view=&sysparm_fields= (Caused by SSLError(SSLError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:877)’),))”, “number”: “INC0010002”, “suppress_pagination_header”: false, “table”: “incident”}

Additional details:
ansible 2.9.15
config file = /etc/ansible/ansible.cfg
ansible python module location = /usr/lib/python2.7/site-packages/ansible
executable location = /usr/bin/ansible
python version = 2.7.5 (default, Nov 16 2020, 22:23:17) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)]

Environment variable set:
REQUESTS_CA_BUNDLE=/etc/pki/tls/certs/ca-bundle.crt

I have added all CA certs for ServiceNow URL in above ca-bundle.crt.

I would like to know if I missed anything. I saw someone faced similar issue from Ansible-Project community but no fix was provided. Appreciate if anyone can help or direct me on this issue.
Code i used is given below.