Hello all,

I have an Excel file filled with VBA-code to leverage the REST API on a number of TM1 models.

For V11, local and on prem, all good !

For V12, IBM hosted (not AWS), all good if I fully authenticate every REST call.

When I try to use the paSession cookie (as documented: https://www.ibm.com/support/pages/how-connect-planning-analytics-service-database-using-rest-api-pa-api-key) then Excel VBA does not include the paSession and 1 other cookie in the response from the authentication call.

But the REST call does work if I fully authenticate. However, that is not the idea.

Moreover, Postman does show me the same response as Excel VBA but includes the 2 cookies that are not part of the response to the same call in VBA. Strange!

Does this ring a bell ? Do some of you want to cooperate in a kind of an online mini-project/Teams call to get it up and running with cookies instead of fully authenticating ?

Some experience with Excel VBA would be good, certainly with using things like:

• MSXML2.XMLHTTP
• MSXML2.XMLHTTP60
• WinHttp.WinHttpRequest.5.1
• MSXML2.ServerXMLHTTP

? sRespHeaders
Connection: keep-alive
Date: Fri, 25 Oct 2024 14:07:50 GMT
Content-Length: 0
Server: cloudflare
WWW-Authenticate: Basic realm="apikey"
WWW-Authenticate: Bearer realm="siusermgr"
content-security-policy: frame-ancestors 'self'
referrer-policy: no-referrer
strict-transport-security: max-age=31536000; includeSubDomains
x-content-type-options: nosniff
x-frame-options: SAMEORIGIN
x-xss-protection: 0
x-transaction-id: fe68af4d00004fb109
x-envoy-upstream-service-time: 19
CF-Cache-Status: DYNAMIC
CF-RAY: 8d0f6b376d4cba58-BRU

While in Postman I also see:
paSession=s%3Ag7mUqf-hD..........m8IQzte7.kEGCtrMMk%2F.............rlYQ%2Bc8L8; Path=/; Secure; HttpOnly;

Thanks in advance !

Wim

Hi Wim,

I am just following up to see if you received a response to your question, if not I will follow-up on your behalf.

Nick