IJ46530: MAXIMO REST API - _DROPNULLS PARAMETER IS IGNORED FOR NESTED OBJECTS

APAR status

• Closed as program error.

Error description

• According to Maximo REST API documentation "_dropnulls" request
  parameter set to 0 should result in response containing ALL
  attributes listed in "oslc.select" parameter, even if they are
  of NULL value. This is true to main Object Structure level
  objects but "dropnulls" parameter is ignored when serialising
  attributes of related objects.
  
  STEPS TO REPRODUCE:
  1. Log into Maximo and create new WO with not-empty Target Start
  and empty Schedule Start
  2. Approve WO
  3. Switch to Assignments tab and create new assignment to any
  valid labor (make note about LABORCODE used).
  4. Fetch data from REST API using example call:
  curl --location -g --request GET
  'http://maximo_host/maxrest/oslc/os/MXAPIASSIGNMENT?lean=1&oslc.
  select=laborcode,rel.workorder
  
  
  {description,schedstart,targstartdate}
  
  &_dropnulls=0&oslc.where=laborcode="[laborcode]"'\ --header
  'APIKEY: [user APIKEY value]'
  
  RESULT:
  
  { "member": [ \{ "_rowstamp": "[0 0 0 0 48 114 74 -108]",
  "labor_collectionref":
  "[http://maximo_host/maxrest/oslc/os/mxapiassignment/_MjQ3NDk3/u
  xavailablelabor]", "href":
  "[http://maximo_host/maxrest/oslc/os/mxapiassignment/_MjQ3NDk3]"
  , "workorder": [ \{ "targstartdate":
  "2022-04-06T14:00:00+02:00", "description": "Condensation on the
  glass, unclear image display" }
  
  ], "laborcode": "ABCDEF" } ], "href":
  "http://maximo_host/maxrest/oslc/os/MXAPIASSIGNMENT",
  "responseInfo": { "href":
  "[http://maximo_host/maxrest/oslc/os/MXAPIASSIGNMENT?lean=1&oslc
  .select=laborcode,rel.workorder
  
  {]description,schedstart,targstartdate}
  
  &_dropnulls=0&oslc.where=laborcode=%22ABCDEF%22" } }
  
  EXPECTED RESULT:
  { "member": [
  
  { "_rowstamp": "[0 0 0 0 48 114 74 -108]",
  "labor_collectionref":
  "http://maximo_host/maxrest/oslc/os/mxapiassignment/_MjQ3NDk3/ux
  availablelabor",  "href":
  "http://maximo_host/maxrest/oslc/os/mxapiassignment/_MjQ3NDk3",
  "workorder": [\{ "targstartdate": "2022-04-06T14:00:00+02:00",
  "schedstart": null, "description": "Condensation on the glass,
  unclear image display" }
  
  ], "laborcode": "ABCDEF" } ], "href":
  "http://maximo_host/maxrest/oslc/os/MXAPIASSIGNMENT","responseIn
  fo": { "href":
  "http://maximo_host/maxrest/oslc/os/MXAPIASSIGNMENT?lean=1&oslc.
  select=laborcode,rel.workorder
  
  {description,sche dstart,targstartdate}
  
  &_dropnulls=0&oslc.where=laborcode=%22ABCDEF%22"}}
  
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.3
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * During REST calls, null values are displayed for nested      *
  * objects.                                                     *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 8.x Product
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels