Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.



Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.



Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

Serve up WORKORDER table as JSON object?

  • 1.  Serve up WORKORDER table as JSON object?

    Posted Thu July 16, 2020 02:46 PM
    Edited by User1971 Fri July 17, 2020 02:25 PM

    As a proof-of-concept/experiment in Maximo

    I would like to serve up the WORKORDER table as a JSON object.

    Is it possible to do this? What would the high-level steps involve?

    Thank you.

  • 2.  RE: Serve up WORKORDER table as JSON object?

    Posted Fri July 17, 2020 08:04 AM

    The Maximo JSON REST API is how you should go about doing this. Documentation can be found here:

    One of the things I would recommend when creating the object structure is to use the newer "Exclude Attributes Mode". This is a checkbox on the object in the object structures application which makes it so only attributes that are explicitly included are available. Maximo has always had a way to exclude attributes, but as new attributes were added (during an upgrade or as part of a customization) someone needed to remember to go and exclude it on all the object structures that referenced that object. This helps avoid that problem entirely.

    You can also use (and should use) the in the REST API to restrict the attributes to what you want. That way you ensure you only pull attributes needed for your use case.

    To handle the row filter, you would either build a filter using oslc.where or referencing a saved query if you want to manage it inside of Maximo. That link above covers how to reference it and setup queries to be usable via the object structure. Note certain filters (such as site access restrictions) will be applied automatically since this is going through the MBO framework.

    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH