Question Re: JSON string to integer in groovy script removing lead... in Technology Q&A

JSON string to integer in groovy script removing leading zero's

mayank_g — Tue, 20 Feb 2024 12:09:54 GMT

Hi,

I have a requirement where in JSON value need to be send as integer instead of string.

Method in groovy script is:

def json = message.getBody(java.lang.String)
def jsonSlurper = new JsonSlurper()
def object = jsonSlurper.parseText(json)object.issuer.branchCode = object.issuer.branchCode.toDouble().intValue();

Value is branchCode: "0732340"

Output of above groovy is branchCode: 732340

Expected output is : branchCode: 0732340

Please help with changes that can be done in the code or any alternate code which can be used.

Thanks & Regards,

Mayank

Re: JSON string to integer in groovy script removing lead...

sachin_yadav3 — Tue, 20 Feb 2024 14:33:54 GMT

Hi ,

Try by defining object as integer i.e. int object =

Thanks

Re: JSON string to integer in groovy script removing lead...

Edrilan_Berisha — Thu, 29 Feb 2024 13:57:54 GMT

Hi,

what sachin_yadav3

proposed will not work. I think he is mixing it up. It's not about to remove leading zeros because that would then work already right now. It's about how to maintain the leading zeros. The answer is actually: it's impossible.

Mathematical, there are no leading zeros. The first integer number 1 is "1" it's not "01" because then it would mathematical not clear actually how many "leading zeros" you have. Is 1 maybe "00001" or is it "00000000000001" or .... etc. So integer numbers by definition do not have any leading zeros, ever.

If you want to keep using the leading zeros, you have to get rid of your code line where you convert it to double and parse it to integer:

object.issuer.branchCode.toDouble().intValue();

this line of coding will always remove the leading zeros. Get rid of the "toDouble().intValue()". And check if you make use of toString() or if leaving it just like it is isn't already fine enough for you.

Best,

Edrilan Berisha

SAP S/4HANA Cloud Financials Development