Maximo Open Forum

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

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

Original Message:
Sent: 01-21-2021 01:09
From: KAUSHIK KUMAR SAMADDAR
Subject: JSON Mapping - Does not interface multiple records

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

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

Original Message:
Sent: 01-21-2021 08:46
From: Nhat Nguyen
Subject: JSON Mapping - Does not interface multiple records

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

Original Message:
Sent: 01-21-2021 01:09
From: KAUSHIK KUMAR SAMADDAR
Subject: JSON Mapping - Does not interface multiple records

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

Hi KAUSHIK ,

Thanks for sharing the resolution.




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

Original Message:
Sent: 02-06-2021 10:23
From: KAUSHIK KUMAR SAMADDAR
Subject: JSON Mapping - Does not interface multiple records

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.

Original Message:
Sent: 01-21-2021 08:46
From: Nhat Nguyen
Subject: JSON Mapping - Does not interface multiple records

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

Original Message:
Sent: 01-21-2021 01:09
From: KAUSHIK KUMAR SAMADDAR
Subject: JSON Mapping - Does not interface multiple records

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

What version of Maximo you are using it? I am currently using 7.6.1.2 and when i try to import multiple records in array, i am getting below error. 

https://www.ibm.com/support/pages/apar/IJ34804

------------------------------
Hardik PAtel
------------------------------

Original Message:
Sent: 02-06-2021 10:23
From: KAUSHIK KUMAR SAMADDAR
Subject: JSON Mapping - Does not interface multiple records

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.

Original Message:
Sent: 01-21-2021 08:46
From: Nhat Nguyen
Subject: JSON Mapping - Does not interface multiple records

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

Original Message:
Sent: 01-21-2021 01:09
From: KAUSHIK KUMAR SAMADDAR
Subject: JSON Mapping - Does not interface multiple records

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