Question
Colin Overton · Jan 19

How can I access cube metadata using the REST API?

Hi All,

I'm looking to write a 3rd party front end for BI cubes and have been directed towards the REST API here: https://docs.intersystems.com/iris20222/csp/docbook/DocBook.UI.Page.cls?...

I've had quick test using postman and can use those fine, the issue I have is that there are some areas of metadata not exposed by the api that are essential to write a front end tool. I can list the cubes and measures using the /INFO/ paths, but that seems to be the limit of what is available.

In particular I need to be able to get metadata for Dimensions, Hierarchies, Levels and Member Properties, and a way to list the Namesapces would be good to so that a user can browse those.

Is there any way to get this information?

Thanks

Colin

Product version: IRIS 2022.2
0
0 124
Discussion (6)3
Log in or sign up to continue

Thanks Evgeny, but that seems to support running MDX which is available through the existing api, it doesn't seem to allow querying the metadata, unless I missed something.

Hi Colin,

It's been a while since I used them, but I think POST /Info/Filters returns some information on dimensions/hierarchies/levels, and POST /Info/FilterMembers returns information on the members of a level. If you need metadata on properties specifically, I'm not sure if that is included. I don't think we have information on namespaces as part of the REST API for IRIS BI, but maybe someone has a suggestion of other ways to get that kind of information about an IRIS instance over REST. Anyway, I'd recommend taking a look at those two /Info services, and possibly opening a WRC issue if you find that they don't provide what you need.

Hi Sam,

Looks like there is some information about the levels and members in there so hopefully I can use that to derive the dimensions and hierarchies.

Thank you!

col

Hi Colin -- Looks like Sam got you all the info about what is available now.  Interested in chatting with you about the other things you need -- properties and namespaces and maybe some other things.  Can I set up a call with you?

That'd be great, thanks. I'll DM you my email address.