how to extract data from response body.

[niveditakumari]

Hello,

How to extract data from response body and set that value in table.

ex - I am calling one API and with that I am getting some records and that are stored in response body. Now I want to extract all the values from response body and set that value in one table.

I am trying to achieve this by schedule job.

Can anyone please help me that how I can extract that values from response body and set that value in our tables.

Regards,

Nivedita 

[niveditakumari]

Hello,

I have written below code in my schedule job to get response body

try {
var r = new sn_ws.RESTMessageV2('Get Data', 'Default GET');

//override authentication profile
authentication_type ='Basic';
r.setAuthenticationProfile(authentication_type, 'Test data');

//set a MID server name if one wants to run the message on MID
//r.setMIDServer('MY_MID_SERVER');

//if the message is configured to communicate through ECC queue, either
//by setting a MID server or calling executeAsync, one needs to set skip_sensor
//to true. Otherwise, one may get an intermittent error that the response body is null
//r.setEccParameter('skip_sensor', true);

var response = r.execute();
var responseBody = response.getBody();
var httpStatus = response.getStatusCode();
gs.addInfoMessage(responseBody+ "responsebody is");
gs.log(responseBody+'Nivi test');
}
catch(ex) {
var message = ex.message;
}

but I am getting below error : 

Any suggestions on this?

Regards,

Nivedita

[niveditakumari]

Hello Abhishek,

I need to get the value from response body and set the value in custom table.

How I can set values in my custom table 'x'.

Regards,

Nivedita

[Narendra Kota]

Hi,

After the REST call, to parse the response and put it in a table, can you please try the below thing:

var responseBody = response.getBody();
responseBody = JSON.parse(responseBody);
for (var i = 0; i < responseBody.length; i++) { // parse response body records
    var gr = new GlideRecord('TABLE_NAME');
    gr.initialize(); //insert records into table with response values
    gr.TABLE_FIELD_NAME_1 = responseBody[i].PARAMETER_NAME_A;
    gr.TABLE_FIELD_NAME_2 = responseBody[i].PARAMETER_NAME_B;
    gr.TABLE_FIELD_NAME_3 = responseBody[i].PARAMETER_NAME_c;
    gr.insert();
}

Please change the TABLE_NAME, TABLE_FIELD_NAME_1, PARAMETER_NAME_A accordingly and try it.

Hope this helps.
Mark Helpful, Correct based on the impact.

Thanks.

[niveditakumari]

Hello,

Thank you so much for your reply.

I need to insert all the data into my custom table.

I have written below code but when i am running this background script it is showing some output. When i see my custom table then data is not filled in table.

Below is my code :

try {
var r = new sn_ws.RESTMessageV2('Get Data', 'Default GET');

//override authentication profile
authentication_type ='basic';
r.setAuthenticationProfile(authentication_type, 'efea940d1b408010acf5fc88cc4bcbf7');

var response = r.execute();
var responseBody = response.getBody();
var httpStatus = response.getStatusCode();

gs.print(responseBody);
gs.log("response body is" + responseBody);
var obj = JSON.parse(responseBody);

for(var i = 0; i<obj.plannedEvents.length; i++) {

var gr = new GlideRecord('u_outage');
gr.initialize();
gr.u_rollbackplan = obj.plannedEvents[i].rollbackPlan;
gr.u_plannedeventstartdate = obj.plannedEvents[i].plannedEventStartDate;
gr.u_closurecode = obj.plannedEvents[i].closureCode;
gr.u_description = obj.plannedEvents[i].description;
gr.u_plannedeventenddate = obj.plannedEvents[i].plannedEventEndDate;
gr.u_ticketid = obj.plannedEvents[i].ticketId;
gr.u_correlationid = obj.plannedEvents[i].correlationId;
gr.u_impact = obj.plannedEvents[i].impact;
gr.u_executionowner = obj.plannedEvents[i].executionOwner;
gr.u_maintenancetype = obj.plannedEvents[i].maintenanceType;
gr.u_sitelocation= obj.plannedEvents[i].maintenanceType;
gr.u_expecteddowntime= obj.plannedEvents[i].expectedDowntime;
gr.u_activitystatus= obj.plannedEvents[i].activityStatus;

for(var j = 0; j<obj.plannedEvents[i].services.length; j++) {

gr.u_serviceidentifier= obj.plannedEvents[i].services[j].serviceIdentifier;
gr.u_protectionstatus= obj.plannedEvents[i].services[j].protectionStatus;
gr.u_servicetype= obj.plannedEvents[i].services[j].serviceType;
gr.u_servicealias= obj.plannedEvents[i].services[j].serviceAlias;
gr.u_customerlename= obj.plannedEvents[i].services[j].customerLeName;
gr.u_cuid= obj.plannedEvents[i].services[j].cuid;

}
gr.insert();
gs.log("table data is" + responseBody);
}

catch(ex) {
var message = ex.message;

}

Below is my output : 

Could you please tell me where I am doing wrong.

Regards,

Nivedita

[Omkar Mone]

Hi 

instead of gr.field_value = "your_json res" can you do gr.setValue("field",your_jsonres);