Solved: Need groovy script for SAP CPI to loop through the...

8885676259 · 4 weeks ago

Hi Experts,

I am new to groovy and learning basics. But got little complex requirement which I tried but couldn't get the desired requirement. So asking your help to achieve my requirement. Please help me to achieve below requirment.

I need to read xml message and from that take value of /User/User/CustomField_BookingHours which is currently -2 and sort all /User/User/TimeAccount/timeAccountDetails/TimeAccountDetail/bookingDate, oldest date should the top one then take value of first /User/User/TimeAccount/timeAccountDetails/TimeAccountDetail/bookingAmount and add both like 0.5 + (-2) then the balance is -1.5 and then take 2nd /User/User/TimeAccount/timeAccountDetails/TimeAccountDetail/bookingAmount which is 0.5 and add reslted balance which is -1.5, so the result is 0.5 + (-1.5) now new balance is -1.0 and then take 2nd /User/User/TimeAccount/timeAccountDetails/TimeAccountDetail/bookingAmount whoch is 3.0 and add reslted balance which is -1.0, so the result is 3.0 + (-1.0) now new balance is 2.0 which is greater than or eauql to 0, add the new node after 3rd TimeAccountDetail node, after which balanc value becomes >= 0, with field /User/User/TimeAccount/timeAccountDetails/TimeAccountDetail/bookingAmount value of /User/User/CustomField_BookingHours.

Excepting adding this new node, remaining payload should be as-is. Only add new node with /User/User/CustomField_BookingHours where ever it becomes >= 0 after adding to each /User/User/TimeAccount/timeAccountDetails/TimeAccountDetail/bookingAmount.

Sample payload

The output should be

8885676259

Hi @naveen4796 ,

Thank for the quick groovy. Current groovy logic considering adding node where ever the CustomField_BookingHours becomes zero with single TimeAccountDetail/bookingAmount. My requirement is to minus(actually plus we need to use as we are getting - sign in the for the value)) the CustomField_BookingHours from each TimeAccountDetail/bookingAmount and with the balance hours, I need to minus from next TimeAccountDetail/bookingAmount and with the balance, I need to minus next TimeAccountDetail/bookingAmount. LIke this loop, where ever the value becomes >= 0, after that we need to add the node.

in SAP CPI, I need to read xml message and from that take value of /User/User/CustomField_BookingHours which is currently -0.75 and then take value of first /User/User/TimeAccount/timeAccountDetails/TimeAccountDetail/bookingAmount and add both like 0.5 + (-0.75) then the balance is -0.25 and then take 2nd /User/User/TimeAccount/timeAccountDetails/TimeAccountDetail/bookingAmount whoch is 0.5 and add reslted balance which is -0.25, so the result is 0.5 + (-0.25) now new balance is 0.25 which is greater than or eauql to 0, add the new node after 2rd TimeAccountDetail node, after which balanc value becomes >= 0, with field /User/User/TimeAccount/timeAccountDetails/TimeAccountDetail/bookingAmount value of /User/User/CustomField_BookingHours. So the output should be like below

Need groovy script for SAP CPI to loop through the nodes and add new node based on logic

deploy python code to btp

Dynamic parallel processing in SAP S/4HANA flexibl...

Dynamic parallel processing in SAP Build Process

Re: I can't call any new functions (RFC) -- but ol...

How to update input Control values through Script ...