We have a client that made a simple change to a datawindow. They changed a column in the select from CAST(col1 AS CHAR(10)) to TO_CHAR(col1). They then used the C# Conversion tool in SnapDevelop 2021 to import this change into the API which was successful. The backend database is Oracle.

In the client application, a restclient call to the API is used to return a decoded password for the login process. The decoded password is added to a packer object in the API and passed back to the client app in the response. Before the change described above was made, the response looked like this:

{"HashedPwd":"c21hcmtvc2U3"}

After importing the datawindow using the C# converter, which has nothing to do with the login process, the response changed to this:

{"count":1,"keys":["HashedPwd"],"raw":"{\"HashedPwd\":\"c21hcmtvc2U3\"}","dataFormat":1}

Our controller logic looks like this:

//initialize datapacker object
var packer = new DataPacker();

var newPwd = _adminService.Encode("somepassword");
packer.AddValue("HashedPwd", newPwd);

return packer

This is a problem because our parsing logic to get the password no longer works and the login fails. This is happening in both 2019 R3 and 2021. Did the packer object change after the R2 release? Could this be a bug?

Thanks, Tom