Hi!

I have created a VBA-project in Excel that interact with PA using the TM1 REST API.

It works fine, except that I receive this security alert when I run the first GET-request:

and when I click 'Yes', The data is retrieves and all following requests work fine.

I have tried to install the certificate, but the message comes back regardless.

Does anyone have any ideas how I can make this alert go away?

Regards,

Willem

This feels like a hack but traditionally we have always edited c:\windows\system32\drivers\etc\hosts on the TM1 server and added an alias on the loopback address i.e.

# localhost name resolution is handled within DNS itself.
#       127.0.0.1       localhost
#       ::1             localhost
127.0.0.1       localhost TM1Server

May work for you as a temporary fix.

Would be interested to hear what others have done besides self-signed certs.

Thanks George!

That seems to do the trick!

# localhost name resolution is handled within DNS itself.#       127.0.0.1       localhost#       ::1             localhost127.0.0.1       localhost TM1Server