Create elastic cube via REST API

Comments

6 comments

  • Avatar
    Moti Granovsky

    Hi,

    This action (creating new Elasticubes) isn't available via a Web API yet, although it should become available in a future version of Sisense.

    Meanwhile, it is possible by using the Elasticube CLI, "psm.exe". You can find documentation for that here: https://developer.sisense.com/pages/viewpage.action?pageId=1409131

    1
    Comment actions Permalink
  • Avatar
    Nickolai Toropov

    Hi! Do you have any estimate about implementing such feature?

    0
    Comment actions Permalink
  • Avatar
    Moti Granovsky

    Hi Nickolai, could you specify what you meant by "estimate"? How long would it take to implement with currently available APIs (the PSM command line) or when the REST API will be out?

    0
    Comment actions Permalink
  • Avatar
    Nickolai Toropov (Edited )

    Sorry. I meant "when will such REST API be implemented?"

     

    I'm currently investigating possibility to create/update/build ElastiCube through REST API. Could you explain how it can be done? What APIs should I use?

    0
    Comment actions Permalink
  • Avatar
    Bastien Gerard

    This post is 1 year old, is there any update on this? I don't see any reference in the API doc for creating a cube

    0
    Comment actions Permalink
  • Avatar
    Moti Granovsky (Edited )

    Hi,

    The new API is in final development/QC stages and will be officially rolled out (with documentation and samples) in the upcoming Linux release. Some time later it will be rolled out to the Windows version as well, but which release exactly is TBD.

    This is a brand new API that was developed from scratch to meet the various use cases for automating Elasticube schema management, and will support both extracted and Live data models. It currently includes functionality to fully generate the schema programatically, edit it, export and import it, as well as to initiate and manage builds (or publishing for Live).

    The new API is fully RESTful and complies with a new set of standards and guidelines Sisense has adopted for REST API development, in line with industry best practices, which should help lower the learning curve. All object models are standard JSON (unlike the current schema which is XML based). Some additional capabilities that you might find in PSM.exe, such as stopping or starting Elasticubes, are already available via legacy REST APIs, but will also be upgraded to new API endpoints in the future.

    I know this has been discussed, teased, and a long time coming - but I believe it's definitely something worth waiting for! From my personal experience with it,  the new API allows schema management automation to be developed much faster than with the previous approach, as well as being more performant.

    In the meantime, for Windows users who cannot wait for these new APIs, the CLI is still supported and has been used to implement Elasticube automation many times before. It can be used to perform certain operations on Elasticube schemas, such as changing connections and adding entities, and when the CLI is insufficient it can also decode .ecube files to XML which can then be manipulated, encoded and built all using the CLI. You can find CLI documentation here: https://developer.sisense.com/pages/viewpage.action?pageId=1409131

    0
    Comment actions Permalink

Please sign in to leave a comment.