Elastic cube build options (REST API)

Follow

Matej Podstrelenec

October 09, 2020 09:22

Hi,

is there a way how to build elastic cube through REST API by using different build options?

 

Example:

Every midnight I would like to trigger "Replace all" build. During the day, I would like to trigger only "By table" mode. After doing some research I haven't found a way how to do that. 

Any idea please?

Best regards,

Matej Podstrelenec

Vendavo

1

• 

  Moti Granovsky October 11, 2020 09:39

  Hi Matej, which version of Sisense are you using? (Windows/Linux and version number)

  0

  Comment actions Permalink
• 

  Matej Podstrelenec October 11, 2020 09:41

  Hi Moti,

  it is Sisense Version: 8.2.4.10095 (Windows).

  0

  Comment actions Permalink
• 

  Denis Pesa October 14, 2020 14:49 (Edited October 14, 2020 14:50)

  Hello,

   

  Any updates on that? I need to run a build with replace all through REST API, but only schema changes is supported.

  I am using API v2.0 on Linux.

  0

  Comment actions Permalink
• 

  Nathan Giusti October 14, 2020 18:00 (Edited October 14, 2020 18:02)

  Matej Podstrelenec

  In windows the start cube build end point accepts schema_changes or full for build type. I am not sure what the parameter would be for building by table. This may need more direct outreach from Sisense. 

   

  Denis Pesa

  In Linux it's pretty clear. There is an endpoint that takes by_table. See a python implementation of the endpoint here

  https://github.com/nathangiusti/PySense/blob/27680c6785e066e257cf73d10785f76c0fd7a8b3/PySense/PySenseDataModel.py#L56

   

  Here is a sample script for building datamodels in linux: https://github.com/nathangiusti/PySense/blob/master/Scripts/BuildDatamodels/BuildDatamodels.py

  0

  Comment actions Permalink
• 

  Moti Granovsky October 18, 2020 14:30

  As Nathan mentioned, you can use this endpoint to start a build:

  POST /api/elasticubes/{server}/{cube_title}/startBuild

  You can find it in the v0.9 API reference.

  It accepts a "type" parameter, which as far as I know can be one of the following values:

  • "Entire" = Replace all
  • "Accumulate" = By Table
  • "SchemaChanges" = Changes Only

  Please try this out, and if you run into any issues report them here and/or via a support ticket (depending on the urgency of the issue)

  1

  Comment actions Permalink
• 

  Matej Podstrelenec October 19, 2020 11:22

  Thank you Moti Granovsky, your answer has solved my issue. 

  It would be very helpful if these options are listed in your REST API reference documentation. 

  0

  Comment actions Permalink

Please sign in to leave a comment.