question Re: Scripted REST API Response returned as "Undefined" in Developer forum

Scripted REST API Response returned as "Undefined"

rohit121 — Wed, 12 Jun 2019 05:43:09 GMT

Hi Folks,

Have created a scripted rest API which takes in a company sys_id as input and is supposed to return all the assignment group names and member count (for the respective groups) tagged under the company. But currently I am getting back no responses once I test it through the API explorer.

Below is the Get resource code I have implemented.

Let me know if someone also faced something similar.

Re: Scripted REST API Response returned as "Undefined"

Ankur Bawiskar — Wed, 12 Jun 2019 05:59:10 GMT

Hi Rohit,

First of all few corrections and check

comp.addQuery('sys_id',clientID);

grp.addQuery('company',clientID);

are you getting cnt1 and cnt2 value ?

add log statement and debug 1 by 1

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Re: Scripted REST API Response returned as "Undefined"

Ashutosh Munot1 — Wed, 12 Jun 2019 05:59:29 GMT

HI,

Can you try using queryParms instead of this var clientID = request.pathParams.client_id;

Meaning use this: var clientID = request.queryParams.client_id;

Thanks,
Ashutosh Munot

Re: Scripted REST API Response returned as "Undefined"

rohit121 — Wed, 12 Jun 2019 13:03:47 GMT

Hi Ankur,

Thanks for the response. I am getting the expected values for cnt1 and cnt2 and without and with the corrections suggested. Though still don't see the response coming up.

Re: Scripted REST API Response returned as "Undefined"

Ankur Bawiskar — Wed, 12 Jun 2019 13:29:55 GMT

Hi Rohit,

Did you add log statements to check what value is printed for object groupObj just before pushing it into writer

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Re: Scripted REST API Response returned as "Undefined"

rohit121 — Wed, 12 Jun 2019 13:38:57 GMT

Thanks for the reply Ashutosh. Have configured my API to take in the client_id from the path param. So it has to be the

request.pathParams.client_id.

GET https://mydev.service-now.com/api/amspa/company_groups_and_memebers_count/{client_id}

Re: Scripted REST API Response returned as "Undefined"

rohit121 — Thu, 13 Jun 2019 11:32:11 GMT

Yes Ankur. All the counters are getting properly updated on the logs. Have added log statement for displaying the groupname as well before pushing it to the writer and am getting the group names. My guess that the issue has something to do the data passing to the writer

Re: Scripted REST API Response returned as "Undefined"

Ankur Bawiskar — Thu, 13 Jun 2019 14:38:59 GMT

Hi Rohit,

Why are you using writer object and not directly setting it into json object and then use response.setBody(jsonObj);

Regards

Ankur