Write to multiple DSE returning empty CDT instead of null.

I am not sure I understand. In your screenshot the returned entityData seems OK.

Hi Stefan, 

Thank you for your response.

As you rightly pointed out that entityData output is correct. However, when we try to store that output back to Pv using ac!StoredValues[1] it is storing as empty CDT instead of null.

Using "ac!StoredValues[1]" is not correct. Use "ac!StoredValues[1].data".

Some documentation: docs.appian.com/.../Write_to_Multiple_Data_Store_Entities_Smart_Service.html

Yes correct,

If we use ac!StoredValues[1].data, it will work.

But, As there are too many PVs we are writing in one Write to multiple DSE smart service, we are using reduce function (Please refer code below.) to get data back to respective PV after writing to DB in output instead of ac!StoredValues[1].data format.

Issue is, As PV is null initially, after writing to DB we should get as null into PV. However we are receiving as empty [Please refer Screenshot]

Usually we get as (No Value ) if any variable is null, however after writing to DB and getting result back using reduce function we are getting blank value.

Impact: Because of user input task is getting it as empty CDT and grid is throwing error.

reduce(
  rule!ACO_getDataFromEntityDataForEntity,
  {},
  ac!StoredValues,
  cons!CLO_DSE_GRID_GUARANTOR_INFO
)

rule!ACO_getDataFromEntityDataForEntity reads as below
append(
  ri!data,
  if(
    ri!EntityData.entity = ri!Entity,
    ri!EntityData.data,
    {}
  )
)

As you already use an expression to extract the values, why not add a NULL/Empty check and return the values as needed.

As you already use an expression to extract the values, why not add a NULL/Empty check and return the values as needed.