REST message JSON

[Michal_S]

sorry for bringing this up again and again
basically what I did is
I did successfully import big chunk of json via rest http connector but not stringified
in case I try to stringify I immediately get some kind of errors like

var mySpin = S(JSON.stringify(response));
connector.setVariable(‘var1’, mySpin)
gives
java.util.TreeMap cannot be cast to java.lang.String
or
SPIN-01004 No matching data format detected

change of json array to just plain json {}
var mySpin = JSON.stringify(response);
connector.setVariable('holidays3 ', mySpin)

ENGINE-03083 Exception while executing Batch Database Operations with message ’

Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException:

org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance
(batch index #1) failed.
Cause: java.sql.BatchUpdateException: Data truncation: Data too long for column ‘TEXT_’

what do I aim is to do some jsonpath very similiary like

Is it possible to manipulate a Json object with the Spin API?

I have a script task which creates a Json object. var data = [ { "value": 1 } ] S(JSON.stringify(data)) Now I’ll try to change a property of this object. var json = execution.getVariable("dataSource"); json.jsonPath("$[0]").element().prop("value", 2) json But this doesn’t work. The value is still 1. Is there another possibility to change the value of an existing Json object, and then use this manipulated Json in the rest of the definition?

but it seems it wouldnt be possible without stringify… then elements…

Can you please confirm ?

MANY thanks