This bug was discovered by me a month ago. Responsive developers from the ataccama confirmed this bug and now the bug is in fixing stage. Shadow columns throws excaptions in 11.1 version. So it is unable to put data from response or put data from input source in the shadow columns.
I see that you have to fill the shadow column from response data. You can add the Column Assigner and fill your column within any column data from JSON Response output.
In my case I need to put the packetID column from input data to response output data of JSON component (In a special table I create packages for further sending for handling the requests of each packet, so I need to have the packageID in response message), because REST don’t return the same data from input source like packageID.
Personally, I was able to solve this problem in the following way:
- I have shadow column difinition within empty expression and filled data type. In my case it was packageID.
- In General Tab I was fill the Parent ID Column (in.packageID) and fill the Record Discriptor using the shadow column name defined as packageID.
- After JSON Component add the Column Assigner component to JSON Response output and apply the expression for this column
trim(substr(packageID,0,iif(indexOF(packageID,’:’) IS NULL,length(packageID),indexOF(packageID,’:’))))
I hope that my solution will help anyone who have encountered this problem