Maximo Open Forum

  • 1.  JSON Mapping application for outbound processing is not recognizing array element in json message

    Posted 02-06-2025 18:24
      |   view attached

    JSON Mapping application for outbound processing, it is not showing array element in target property selection window. See attachment for screenshots.

    This is happening in Maximo 7.6.1.3  


    #Integrations

    ------------------------------
    Chandra Karumuri
    Oncor
    ------------------------------

    Attachment(s)



  • 2.  RE: JSON Mapping application for outbound processing is not recognizing array element in json message

    Posted 02-07-2025 21:52
    Edited by Prashant Sharma 02-07-2025 22:10

    Hi Chandra

    Your format is incorrect. Here ix example format that you need to use-

    {
    "BFASSETID":"JMP15",
    "BFSITEID":"BEDFORD",
    "BARRY":[
        {
        "BTEST1":"TEST1",
        "BTEST2":"TEST2",
        "BTEST3":"TEST3"
        }
    ]
    }

    And you will be able to see Array elements as well which should be mapped with Child Object.



    ------------------------------
    Prashant Sharma
    Sedin Technologies
    Connect with me @ https://www.linkedin.com/in/psharmamaximo/
    Learn Maximo with me @https://www.youtube.com/@reliabilityodyssey/

    #IBM Champion 2022
    #IBM Champion 2023
    #IBM Champion 2024
    ------------------------------



  • 3.  RE: JSON Mapping application for outbound processing is not recognizing array element in json message

    Posted 02-08-2025 12:14

    Hi Prashant,

    Thanks for your response. No issues with object type arrays like below, in the example BARRY is a structure(object). 

    {
    "BFASSETID":"JMP15",
    "BFSITEID":"BEDFORD",
    "BARRY":[
        {
        "BTEST1":"TEST1",
        "BTEST2":"TEST2",
        "BTEST3":"TEST3"
        }
    ]
    }

    In my case BARRY is a array of element and it is valid json message.

    {
    "BFASSETID":"JMP15",
    "BFSITEID":"BEDFORD",
    "BARRY":["BTEST1","BTEST2"]
    }



    ------------------------------
    Chandra Karumuri
    Oncor
    ------------------------------



  • 4.  RE: JSON Mapping application for outbound processing is not recognizing array element in json message

    Posted 02-09-2025 10:37
    Edited by Prashant Sharma 02-09-2025 10:43

    Not a valid format for showing attribute lookup.



    ------------------------------
    Regards,
    Prashant Sharma
    IBM Champion 2022|2023|2024|2025
    Connect with me @ https://www.linkedin.com/in/psharmamaximo/
    Lets learn MAS @ https://www.youtube.com/@reliabilityodyssey/
    ------------------------------



  • 5.  RE: JSON Mapping application for outbound processing is not recognizing array element in json message

    Posted 02-10-2025 11:36

    Oh okay, so Maximo doesn't support JSON mapping for Array elements.



    ------------------------------
    Chandra Karumuri
    Oncor
    ------------------------------



Newest Episode
Ep. 4 | System Properties in IBM Maximo

Watch Steven Shull walk through practical IBM Maximo system properties that can improve usability, query behavior, attachment handling, and the overall Maximo user experience.

MORE by Naviam Episode 4 cover
Watch Episode 4
Also available: Ep. 3 | Work Order Role-Based Application