How to update TM1 Cube data using Rest API call

Question

I am trying to find a way to make a Rest API call to TM1 that sends it an array of data to be updated in the Cube. The data to be updated will be identifiable by the Cube's key but it wont be all the records to be update (e.g. update row 3 and 5 with new values).

I am having issue finding an example. I did see from documentation "Cube.UpdateCells" But didnt see example on how to use it. I also saw https://www.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_rest_api.10.2.2.doc/t_tm1_rest_api_cellsets.html#dg_tm1_odata_update_many_cell_values where it mentions updating many cells but no example..

I didn't find anything here about it so any help would be appreciated!

Answer 1

You should try the tm1.Update function and write the exact crossing in the cube. the URL will look like this one ; https://myserver:myportnumber/api/v1/Cubes('mycube')/tm1.Update and in the body of your POST Request you'll puch the exact crossing of your cube with the value. it will look like this one:

{
    "Cells":[
        {"[email protected]": [
            "Dimensions('Version')/Hierarchies('Version')/Elements('BUDGET')",
            "Dimensions('Societe')/Hierarchies('Societe')/Elements('S01')",
            "Dimensions('Compte')/Hierarchies('Compte')/Elements('C7090')",
            "Dimensions('Annee')/Hierarchies('Annee')/Elements('2019')",
            "Dimensions('Mois')/Hierarchies('Mois')/Elements('M01')",
            "Dimensions('m_Couts')/Hierarchies('m_Couts')/Elements('MONTANT')"
            ]
        }
    ],
    "Value":"1234"
}

You can learn more about the TM1 REST API here : https://code.cubewise.com/tm1-rest-api

You'll have a lot of explanation. Try their Postman Collection for the TM1 REST API you'll learn a lot. You just have to install POSTMAN on your laptop and try it on the IBM samples servers.

In general Cubewise as a lot of good tools. To go further if you know Python or you want to learn it you have the TM1Py library wich is good to work with the TM1 REST API