Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

issue with JOLT Transformation-NIFI

avatar
Contributor

I have an issue with my JOLT transformation in NIFI:

My INPUT:

{
"customerNumber": "40890036",
"customerOrderNumber": "TPACSAY4",
"orderType": "ES",
"orderEntryFlag": "createOrder",
"parts": [
{
"partNumberOrdered": "A0029864271",
"quantityOrdered": "2.00",
"customerInfo": "Cust information",
"chassisNo": "WDB45678901234567",
"additionalEntry": "ADDITIONAL ENTRY"
},
{
"partNumberOrdered": "N000000001388",
"quantityOrdered": "10.00",
"customerInfo": "Cust information",
"chassisNo": "WDB45678901234567",
"additionalEntry": "ADDITIONAL ENTRY"
}
]
}

 

My current JOLT is below:

[
{
"operation": "modify-default-beta",
"spec": {
"CustNo1": "${CustNO}",
"Customer": "${CustNO}",
"ShippingSiteId": "0",
"SalesOrderOriginCode": "CFE",
"ShippingWarehouseId": "5559",
"LineDiscount": "${MCRHoldCode}",
"SALESORDERNUMBER": "",
"customerReqNo": "",
"OrderType": "${MCRHoldCode}",
"DELIVERYTERMSCODE": "${DELIVERYTERMSCODE}",
"ShippingDate_VO_Header": "=substring((${ShippingDate_VO}), 0, 20)",
"ShippingDate_EM_Header": "=substring((${ShippingDate_EM}), 0, 20)",
"ShippingDate_ES_Header": "=substring((${ShippingDate_ES}), 0, 20)",
"parts": {
"*": {
"DMLRCreationDateTime": "=concat(${currentDate},'+00:00')",
"Position number": "",
"Manual_or_Auto": "",
"QtyProPosed": "",
"INVENTORYLOTID": "",
"chassisNo": "",
"customerInfo": "",
"additionalEntry": "",
"ShippingDate_VO": "=substring((${ShippingDate_VO}), 0, 20)",
"ShippingDate_EM": "=substring((${ShippingDate_EM}), 0, 20)",
"ShippingDate_ES": "=substring((${ShippingDate_ES}), 0, 20)"
}
}
}
},
{
"operation": "modify-default-beta",
"spec": {
"parts": {
"*": {
"REQUESTEDSHIPPINGDATE_New": "=concat(@(1,ShippingDate_VO), @(1,ShippingDate_EM),@(1,ShippingDate_ES))"
}
}
}
},
{
"operation": "modify-default-beta",
"spec": {
"parts": {
"*": {
"REQUESTEDSHIPPINGDATE_Final": "=substring(@(1,REQUESTEDSHIPPINGDATE_New), 1, 20)"
}
}
}
},


{
"operation": "shift",
"spec": {
"SALESORDERNUMBER": "SALESORDERHEADERV2ENTITY.SALESORDERNUMBER",
"customerOrderNumber": "SALESORDERHEADERV2ENTITY.CUSTOMERSORDERREFERENCE",
"Customer": "SALESORDERHEADERV2ENTITY.ORDERINGCUSTOMERACCOUNTNUMBER",
"customerReqNo": "SALESORDERHEADERV2ENTITY.CUSTOMERREQUISITIONNUMBER",
"ShippingSiteId": "SALESORDERHEADERV2ENTITY.DEFAULTSHIPPINGSITEID",
"ShippingWarehouseId": "SALESORDERHEADERV2ENTITY.DEFAULTSHIPPINGWAREHOUSEID",
"orderType": "SALESORDERHEADERV2ENTITY.SALESORDERPOOLID",
"OrderType": {
"CH": {
"#SD": "SALESORDERHEADERV2ENTITY.SMS_MCRHOLDCODE"
},
"ZZ": {
"#SD": "SALESORDERHEADERV2ENTITY.SMS_MCRHOLDCODE"
},

"*": {
"# ": "SALESORDERHEADERV2ENTITY.SMS_MCRHOLDCODE"
}
},
"DELIVERYTERMSCODE": {
"ES": {
"#CIF": "SALESORDERHEADERV2ENTITY.DELIVERYTERMSCODE"
},
"EM": {
"#CIF": "SALESORDERHEADERV2ENTITY.DELIVERYTERMSCODE"
},
"*": {
"# ": "SALESORDERHEADERV2ENTITY.DELIVERYTERMSCODE"
}
},
"LineDiscount": "SALESORDERHEADERV2ENTITY.LINEDISCOUNTCUSTOMERGROUPCODE",
"parts": {
"0": {
"partNumberOrdered": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].ITEMNUMBER",
"quantityOrdered": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].ORDEREDSALESQUANTITY",
"additionalEntry": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_ADDITIONALINFORMATION",
"chassisNo": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_VINNUMBER",
"INVENTORYLOTID": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].INVENTORYLOTID",
"Position number": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].CUSTOMERSLINENUMBER",
"DMLRCreationDateTime": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_CREATEDDATEANDTIME",
"Manual_or_Auto": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_MANUALORADDITIONAL",
"QtyProPosed": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_QUANTITYPROPOSED",
"customerInfo": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].CUSTOMERREQUISITIONNUMBER",
"REQUESTEDSHIPPINGDATE_Final": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].REQUESTEDSHIPPINGDATE"
},
"*": {
"partNumberOrdered": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].ITEMNUMBER",
"quantityOrdered": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].ORDEREDSALESQUANTITY",
"additionalEntry": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_ADDITIONALINFORMATION",
"chassisNo": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_VINNUMBER",
"INVENTORYLOTID": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].INVENTORYLOTID",
"Position number": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].CUSTOMERSLINENUMBER",
"DMLRCreationDateTime": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_CREATEDDATEANDTIME",
"Manual_or_Auto": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_MANUALORADDITIONAL",
"QtyProPosed": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].SMS_QUANTITYPROPOSED",
"customerInfo": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].CUSTOMERREQUISITIONNUMBER",
"REQUESTEDSHIPPINGDATE_Final": "SALESORDERHEADERV2ENTITY.SALESORDERLINEV2ENTITY[&1].REQUESTEDSHIPPINGDATE"
}
}
}
}
]

 

The output is:

{
"SALESORDERHEADERV2ENTITY" : {
"SALESORDERNUMBER" : "",
"CUSTOMERSORDERREFERENCE" : "TPACSAY4",
"ORDERINGCUSTOMERACCOUNTNUMBER" : "${CustNO}",
"CUSTOMERREQUISITIONNUMBER" : "",
"DEFAULTSHIPPINGSITEID" : "0",
"DEFAULTSHIPPINGWAREHOUSEID" : "5559",
"SALESORDERPOOLID" : "ES",
"SMS_MCRHOLDCODE" : " ",
"DELIVERYTERMSCODE" : " ",
"LINEDISCOUNTCUSTOMERGROUPCODE" : "${MCRHoldCode}",

 


"SALESORDERLINEV2ENTITY" : [ {


"ITEMNUMBER" : "A0029864271",
"ORDEREDSALESQUANTITY" : "2.00",
"SMS_ADDITIONALINFORMATION" : "ADDITIONAL ENTRY",
"SMS_VINNUMBER" : "WDB45678901234567",
"INVENTORYLOTID" : "",
"CUSTOMERSLINENUMBER" : "",
"SMS_CREATEDDATEANDTIME" : "${currentDate}+00:00",
"SMS_MANUALORADDITIONAL" : "",
"SMS_QUANTITYPROPOSED" : "",
"CUSTOMERREQUISITIONNUMBER" : "Cust information",
"REQUESTEDSHIPPINGDATE" : "2022-03-25T15:26:55"
}, {
"ITEMNUMBER" : "N000000001388",
"ORDEREDSALESQUANTITY" : "10.00",
"SMS_ADDITIONALINFORMATION" : "ADDITIONAL ENTRY",
"SMS_VINNUMBER" : "WDB45678901234567",
"INVENTORYLOTID" : "",
"CUSTOMERSLINENUMBER" : "",
"SMS_CREATEDDATEANDTIME" : "${currentDate}+00:00",
"SMS_MANUALORADDITIONAL" : "",
"SMS_QUANTITYPROPOSED" : "",
"CUSTOMERREQUISITIONNUMBER" : "Cust information",
"REQUESTEDSHIPPINGDATE" : "2022-03-25T15:26:55"
} ]
}
}

 

My requirement:

I need to add the the field "REQUESTEDSHIPPINGDATE" : "2022-03-25T15:26:55", in the header also(just after the line marked in red). 

 

Please help :

1 ACCEPTED SOLUTION

avatar
Contributor

Hi,

Got it. The below modification done and it is working fine. Thank you all

{
"operation": "modify-default-beta",
"spec": {
"REQUESTEDSHIPPINGDATE_H1": "=concat(@(1,ShippingDate_VO_Header), @(1,ShippingDate_EM_Header),@(1,ShippingDate_ES_Header))"
}
},

{
"operation": "modify-default-beta",
"spec": {
"REQUESTEDSHIPPINGDATE_Header": "=substring(@(1,REQUESTEDSHIPPINGDATE_H1), 1, 20)"
}
},

 

{
"operation": "shift",
"spec": {
"REQUESTEDSHIPPINGDATE_Header": "SALESORDERHEADERV2ENTITY.REQUESTEDSHIPPINGDATE_Header"

}

]

View solution in original post

2 REPLIES 2

avatar
Contributor

Hi,

Got it. The below modification done and it is working fine. Thank you all

{
"operation": "modify-default-beta",
"spec": {
"REQUESTEDSHIPPINGDATE_H1": "=concat(@(1,ShippingDate_VO_Header), @(1,ShippingDate_EM_Header),@(1,ShippingDate_ES_Header))"
}
},

{
"operation": "modify-default-beta",
"spec": {
"REQUESTEDSHIPPINGDATE_Header": "=substring(@(1,REQUESTEDSHIPPINGDATE_H1), 1, 20)"
}
},

 

{
"operation": "shift",
"spec": {
"REQUESTEDSHIPPINGDATE_Header": "SALESORDERHEADERV2ENTITY.REQUESTEDSHIPPINGDATE_Header"

}

]

avatar
Community Manager

@kumsath 

I'm happy to see you resolved your issue. Please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 

 

Screen Shot 2019-08-06 at 1.54.47 PM.png


Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.