question Re: How to write external JSON code ServiceNow REST API in Developer forum

How to write external JSON code ServiceNow REST API

Hemalatha1 — Thu, 08 Dec 2022 16:38:40 GMT

Hi There

Can anyone please help on how we need to write the below json code into REST Messages in ServiceNow under HTTP Methods-->Variable substitutions. When I run the below code in POSTMAN with the required headers we re getting the success response , but we are not sure how do we test this code in ServiceNow under REST Messages using HTTP Methods.

{

"subject": "test",

"expireTime": "2023-9-9 12:12:12",

"send": false,

"category": {

"name": "snCategory"

"signatories": [

{

"tenantName": TEST",

"tenantType": "XXX",

"receiver": {

"contact": "xxxxx@yy.com",

"contactType": "EMAIL"

}

]

}

Re: How to write external JSON code ServiceNow REST API

SuhasPSalunkhe — Wed, 14 Dec 2022 04:10:38 GMT

Following things needs to be consider -

1. In rest api script - print request ( what is receiving )

2. In rest api script - try to decompose the request object and based on the structure of request object you have to write code accordingly.

3. Based on your code you will get object properties and their values.

Hope this can help you to get the request data.

You will find many articles to read JSON formatted data

Re: How to write external JSON code ServiceNow REST API

jaheerhattiwale — Wed, 14 Dec 2022 05:39:09 GMT

@Hemalatha1 Follow below steps

Update the request body in HTTP methods as follows:

{

"subject": "test",

"expireTime": "2023-9-9 12:12:12",

"send": false,

"category": {

"name": ${category}

"signatories": [

{

"tenantName": TEST",

"tenantType": "XXX",

"receiver": {

"contact": "xxxxx@yy.com",

"contactType": "EMAIL"

}

]

}

2. Click on auto generate variables related link

3. Update the Test value field to just snCategory from "name":"snCategory" as in image below:

4. Click on Test related link

Please mark as correct answer if this solves your issue.

Re: How to write external JSON code ServiceNow REST API

PavanK960672992 — Wed, 14 Dec 2022 06:42:49 GMT

Hi @Hemalatha1 ,

ServiceNow provided the documentation for this refer below. Let us know if you face any difficulty/doubt.

https://docs.servicenow.com/bundle/tokyo-application-development/page/integrate/outbound-rest/task/t_GenerateMessageVariables.html

https://docs.servicenow.com/en-US/bundle/tokyo-application-development/page/integrate/outbound-rest/concept/c_TestingMethods.html

Re: How to write external JSON code ServiceNow REST API

PavanK960672992 — Thu, 15 Dec 2022 05:22:45 GMT

Hi @Hemalatha1 ,

If your issue got resolved close the question by Accepting solution and hit thumb icon then others will get benefited from this.
If not reply and share details.

Re: How to write external JSON code ServiceNow REST API

jaheerhattiwale — Thu, 15 Dec 2022 05:26:28 GMT

@Hemalatha1 Did you try this? Please try if not already done.

Re: How to write external JSON code ServiceNow REST API

reshmapatil — Thu, 15 Dec 2022 06:45:02 GMT

Hi @Hemalatha1 ,

Do the following steps:

1. In Content paste your JSON as shown in the screenshot.

2. Save the record and then click on the 'Auto-generate Variables' related link.

3. Can see all variables in the 'Variables Substitutions' Related List.

4. If want to use the script in other server side-scripts, click on the 'Preview script usage' related link and can see the script.

If you want to generate JSON entirely through the script, you can use the following script:

var jsonREST = {};
jsonREST.subject = 'test';
jsonREST.expireTime = '2023-9-9 12:12:12';
jsonREST.send = false;

var cat = {};
cat.name = 'snCategory';
jsonREST.category = cat;

var signatoriesArr = [], obj = {}, receiverObj = {};
obj.tenantName = 'TEST';
obj.tenantType = 'XXX';

receiverObj.contact = 'xxxxx@yy.com';
receiverObj.contactType = 'EMAIL';

obj.receiver = receiverObj;
signatoriesArr.push(obj);
jsonREST.signatories = signatoriesArr;

gs.info(JSON.stringify(jsonREST));

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**

Re: How to write external JSON code ServiceNow REST API

PavanK960672992 — Fri, 23 Dec 2022 06:25:00 GMT

Hi @Hemalatha1 ,

If my response helps you to resolve the issue close the question by Accepting solution and hit thumb icon. From Correct answers others will get benefited in future.
If not reply and share details.

Re: How to write external JSON code ServiceNow REST API

PavanK960672992 — Mon, 02 Jan 2023 10:22:28 GMT

Hi @Hemalatha1 ,