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
------------------------------
Wim Gielis
------------------------------