Maximo Open Forum

 View Only

  • 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)

    docx
    JSON Mapping Application-Bug.docx   188 KB 1 version


  • 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
    ------------------------------

    Original Message


  • 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
    ------------------------------

    Original Message


  • 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/
    ------------------------------

    Original Message


  • 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
    ------------------------------

    Original Message


Related Content