Excel OData: Request failed: Could not establish trust relationship for the SSL/TLS secure channel

Hello,

I am trying to do a excel odata BAq call and I am getting an error

Details: “OData: Request failed: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.”

What should i do to get it fixed?

To get it REST oData to work with Excel, you need a proper cert on your Epicor server. (Not a self signed)

1 Like

More broadly, you need a cert that your computer trusts. By default, a self-signed cert is not trusted because the CA (you) is not a trusted authority. So you have two choices: do what Carson suggests and buy a cert from a trusted authority or use Microsoft’s certificate server to create a cert and then use group policy to push the cert into the trusted state within your domain.