TM1 Forum

Hello,

I would like some help on Postman configuring. I aim testing MDX requests through Postman as I prefer avoiding PAWS.

The TM1 server works fine. Its version is IBM Cognos TM1 Server Application 11.0.6.71-0. Integrity mode is set to 5. My account is correctly set as I permanently use it with Architect.

I receive correct answer when using this URL : http://isd-tm1:12355/api/v1/$metadata

I would like to configure Postman to send MDX to TM1 server (isd-tm1). But I'm facing some trouble. I don't know why the server is always answering an http 401 error (unauthorized). Here are the header settings :

Authorization : CAMNamespace ("account":"password":"namespace")
Accept : application/json
Content-type : application/x-www-form-urlencoded

In body, I put the MDX request.

I'm sure account & password are correct.

I call this URL : http://isd-tm1:12355/api/v1/ExecuteMDX?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Attributes))),Cells($select=Ordinal,Value,FormattedValue,Consolidated)

So, any idea what's wrong ? Did I forget a parameter in header ?

Thanks in advance.

I will give any additionnal piece of information if needed.

The link below might be a good resource


https://code.cubewise.com/blog/masterin ... th-postman


EDIT:
Sorry, was re-reading your post and the link I provided and I'm not sure now how much help that'd be for you. Have you tried setting the content type to application/json and passing the mdx as json payload via POST method?

Hello, thanks for your help.

I think I should use POST method instead of GET. I'm testing it. I will be back soon to tell you.