Planning Analytics

 View Only

 Pafe Automation via API on Cloud

Joseph White's profile image
Joseph White posted 12/27/24 01:17 AM

Hi,

Wondering if anyone managed to automate log on to PA cloud via the Pafe VBA API (or otherwise).  We still have some legacy Pafe Excel reports which we need to automate (open, run a macro, close). This worked ok on premise by automating the log on and refresh, but it seems that the Logon method can't be used with Cloud environments?

Joe

David Usherwood's profile image
David Usherwood posted 12/27/24 06:27 PM

Good to see you here.

I know that IBM require the use of a non-interactive user for (eg) TM1PY usage against PAoC - this may also be required for the PAfE API. Details of the non-interactive user come with the welcome kit but you have to activate it with a ticket. Worth a try.

Joseph White's profile image
Joseph White posted 12/29/24 09:55 PM

Hi David, Good to hear from you too!

I tired the Non Interactive user, and we are successfully using it for other integrations (via TM1Py), but it doesn't seem to work via the PAfE API though. I think PAfE requires a user session and the NI user is specifically prevented from interactively logging in. If I log in manually with my own user, then I can run further API macros, I just can't automate the actual log on part, which is fairly critical to the automation part of this solution! 

Related Content