TM1 Forum

Hello,

I recently tried to update 1 cell within a cube using the TM1 REST API. I am using a MDX Statement to get the cellset ID. Here is the mdx

{"MDX":"SELECT {[ADDiN_DIMS].[DIM1]} on 0 from C_ADDIN2 where ([}Clients].[Admin],[REPORTS_FEBR].[GEN],[ADDIN_PARA].[DIM_LABEL] )"}

This statement always gives me the correct cell and cell value.

Here is the server response:

{"@odata.context":"$metadata#Cellsets(Cells)/$entity","ID":"XDMZY28CAIBwAAAg","Cells":[{"Ordinal":0,"Value":"SZENARIEN","FormattedValue":"SZENARIEN"}]}

Now. If i try to do a PATCH statement on this cellset, i get the error: {"error":{"code":"","message":"SystemValueInvalid"}}

This is my PATCH request:

PATCH /api/v1/Cellsets('XDMZY28CAIBwAAAg')/Cells

{
"Ordinal":0,
"Value":"Test"
}

Can anyone explain why i get this error, or what could cause this problem.

Thanks in advance.

Best regards
Alexander Jell

At a quick glance I'd assume it's because you are sending a single value and not an array containing a single value in the request body.

http://www.ibm.com/support/knowledgecen ... ll?lang=en