kumsath
Explorer
My Accepted Solutions
Show All

Re: SENDING HTTP RESPONSE PART BY PART(PAGINATION...

by Explorer in Support Questions
‎03-28-2023 10:30 PM
‎03-28-2023 10:30 PM
That is fine. But how to send this part by part output in the HTTP response? ... View more

SENDING HTTP RESPONSE PART BY PART(PAGINATION) IN...

by Explorer in Support Questions
‎03-28-2023 06:57 AM
‎03-28-2023 06:57 AM
Hi, I am receiving and HTTP call in NIFI. Which does the below job: Execute the sql and fetch result Convert the result in to JSON(there are 100 or more number of records) Send back the result as HTTPRESPONSE. Now the issue is that if i want to sent the data part by part( Using pagination mode) . For an example: Receiving the HTTP call . In the call we will be receiving page number. Say it is 5 pages. So if the total record is 100 then first response will be 20 records(100/5).   First response will have 20 records, second response will have another 20. Like that 5 times How can i handle this in NIFI ? Please provide your thoughts on the same. Your help will be much appreciated ... View more
Labels:

Re: issue with JOLT Transformation-NIFI

by Explorer in Support Questions
‎03-24-2022 05:57 AM
2 Kudos
‎03-24-2022 05:57 AM
2 Kudos
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 more

issue with JOLT Transformation-NIFI

by Explorer in Support Questions
‎03-24-2022 04:33 AM
‎03-24-2022 04:33 AM
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 : ... View more
Labels:

Re: removing scientific notation after divison

by Explorer in Support Questions
‎03-10-2022 04:01 PM
‎03-10-2022 04:01 PM
Thanks for the update Steven. I had gone through those article before.  Here I am using and update attribute which contains number for variables.  update attribute with multiple attributes After this flow i am receiving the output as  GROSSDEPTH =1.0E-4   So the question is execute script will work in this scenario? Please suggest. ... View more

removing scientific notation after divison

by Explorer in Support Questions
‎03-10-2022 12:57 AM
‎03-10-2022 12:57 AM
I am using the below NIFI EXPRESSION in the update attribute   This works fine, but after division getting scientific notation, say for an example if the  GROSSDEPTH = 0.010000, then  the expression output is coming as :  GROSSDEPTH 1.0E-4 how to remove this scientific notation. Please help ... View more
Labels:

Site to Site Bulletin reporting task -Error NIFI

by Explorer in Support Questions
‎03-01-2022 10:44 PM
‎03-01-2022 10:44 PM
Hi, I am trying to configure the S2S Bulletin reporting task. S2S Confgration StandardRestrictedSSL configuration The below error receiving after running the S2S task:   error from NIFI Is this some related with the Policy setting or permission. Kindly provide guidance on this . ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎03-30-2023 07:53 AM
Public Statistics
Date Registered ‎03-01-2022 07:47 PM
Last Visited ‎03-30-2023 07:53 AM
Total Messages Posted 8
Total Kudos Received 2