Trying to return an integer, but keep getting a float.

[Kristoffer Mon1]

I am getting some strange behavior when trying to return an integer in a Scripted Rest API response. So given the sample the below, the field u_birth_month is set to an integer in the table sys_user.

(function process(/*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {

	var user_list = [];
	
	var gr = new GlideRecord("sys_user");
	gr.orderBy('employee_number');
	gr.addNotNullQuery('u_birth_month');
	gr.query();
	
	while (gr.next()) {
		
		//var int_value = Number(gr.getValue('u_birth_month'));
		//var int_value = Math.floor(parseFloat(gr.getValue('u_birth_month')));
		//var int_value = parseInt(gr.getValue('u_birth_month'));
		//var int_value = parseInt("6");
		//var int_value = 6;
		var int_value = parseInt(gr.getValue('u_birth_month'));
		
		var user_obj = {
			employee_number: gr.getValue("employee_number"),
			u_birth_month: int_value

		};

		user_list.push(user_obj);

	}

	return user_list;

})(request, response);

When testing the call in PostMan, u_birth_month is always returning a decimal. Nothing that i've tried (see the commented lines within the while loop) seems to work in removing the decimal.

I initially though that perhaps Postman was rendering all integers as decimals, but that is not the case as I can simply hardcode an integer and it renders correctly in Postman.

[Harsh Vardhan]

I tried to test on REST Api Explorer as well as "boomerangapi" chrome extension and its giving me integer. I created custom field as string and stored on integer value there .

Screenshot:

[Kristoffer Mon1]

I'll try creating another field and set it as a string; but as I understand it getValue() always returns a string?

If I can't find a solution, i'll tell the developers calling the endpoint to process the float for now.

[Harsh Vardhan]

yes . this seems like something need to be done at postman end. 

adding one link here. 

https://stackoverflow.com/questions/54474943/postman-returns-integer-value-whereas-jmeter-returns-do...

[-O-]

Try

u_birth_month: int_value.toFixed(0)

in place of

u_birth_month: int_value

[Kristoffer Mon1]

Hi there. Trying your recommendation resulted in a string:

I am currently in version Orlando. Going to spin up a PDI to see if this is a bug with this instance. The funny thing was, doing a parseInt(int_value.toFixed(0)) put me back to where I started.