IJ34403: JSON MAPPING IS NOT BEING ABLE TO ESCAPE DOUBLE QUOTE

APAR status

• Closed as program error.

Error description

• JSON mapping is not being able to escape double quote.
  i.e: in the json mapping the description field contains a double
  quote like : "10" Ball Valve w/ Extension"
  when sending "10\" Ball Valve w/ Extension" the double quote is
  being stripped out and in the database it saves it like "10 Ball
  Valve w/ Extension"
  
  It happens for all object structures.
  
  Steps to reproduce:
  1. Create a new json mapping (in my test I used MXASSET),
  Inbound processing
  2. Json data:
  {    "assetnum":"11721",
     "status":"NOT READY",
     "description":"10\" Ball Valve w/ Extension",
     "siteid":"BEDFORD"
  }
  
  output:
  <?xml version="1.0" encoding="UTF-8"?>
  <SyncMXASSET xmlns="http://www.ibm.com/maximo"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  creationDateTime="2021-08-06T11:27:45-07:00" baseLanguage="EN"
  transLanguage="EN" event="0"
  maximoVersion="7620200715-0100V7612-284">
   <MXASSETSet>
     <ASSET>
       <ASSETNUM>11721</ASSETNUM>
       <DESCRIPTION>10 Ball Valve w/ Extension</DESCRIPTION>
       <SITEID>BEDFORD</SITEID>
       <STATUS>NOT READY</STATUS>
     </ASSET>
   </MXASSETSet>
  </SyncMXASSET>
  
  -> the double quote is being stripped out.
  
  This is also seen in 7612
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: | Release 7.6.1.3 of Base Services
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels