Maximo Open Forum

Expand all | Collapse all

JSON Mapping - Does not interface multiple records

  • 1.  JSON Mapping - Does not interface multiple records

    Maximo Certified
    Posted 01-21-2021 01:09
    Hi,

    I have created an Object Structure that contains WORKORDER as the primary and MATUSETRANS as the child.

    I have created a JSON Mapping record based on the Object Structure. The JSON Message is of the form:

    {
        "WONUM":"",
        "MATUSETRANS":
         {
            "MATUSETRANSID":"",
            "LOCATION":""
         }
    }

    When I save multiple line items against an Approved Work Order under the Actuals, the Interface does fire. However, it always shows 1 Line Item and not the rest. 

    I have confirmed from the logs that Maximo does process all the Line Items. However, when I try to see the message in the Message Tracking, I see only 1 Line Item.

    Has anybody experienced this before? Please assist.
    #Integrations

    ------------------------------
    KAUSHIK KUMAR SAMADDAR
    Compunnel Software Group Inc.
    ------------------------------


  • 2.  RE: JSON Mapping - Does not interface multiple records

    Posted 01-21-2021 08:47
    How did you create your OS? Which relationship did you use or did you create a new relationship? The actual item will link to either parent WO (the one the you used to save the WO) if Task field is null, or to task number which is actually child WO. So please consider that too, try again by not entering this Task field.



    ------------------------------
    Nhat Nguyen
    BienDong POC
    ------------------------------



  • 3.  RE: JSON Mapping - Does not interface multiple records

    Maximo Certified
    Posted 20 days ago
    Thanks Nhat. I have been able to figure it out. In the JSON Mapping, I would need to mark the MATUSETRANS as an array or I need to enclose it in [].

    {
        "WONUM":"",
        "MATUSETRANS":[
         {
            "MATUSETRANSID":"",
            "LOCATION":""
         } ]
    }

    I am able to receive all the Line Items now. Since it was not enclosed in the array, hence it was publishing only the first line.

    Thank you.

    ------------------------------
    KAUSHIK KUMAR SAMADDAR
    Compunnel Software Group Inc.
    ------------------------------



  • 4.  RE: JSON Mapping - Does not interface multiple records

    Maximo Certified
    Posted 17 days ago
    Hi KAUSHIK ,

    Thanks for sharing the resolution.




    ------------------------------
    Biplab Choudhury
    Tata Consultancy Services
    ------------------------------