1 ACCEPTED SOLUTION
Hi,
Please find the steps below to achieve your requirement:
1) Create a Outbound Rest API by navigating to the module "Outbound Rest" as shown below:
2) Click on New button and give a valid Name as shown below:
3) Now click on New under HTTP Method as shown below and select method as "Get"
4) Define your HTTP header and then you can write a Async or After Insert and Update Business Rule on your table where you want and use the script below to fetch the response
Sample script shared below to be used in BR:
try {
var r = new sn_ws.RESTMessageV2('Get Records', 'Get Records');
//override authentication profile
//authentication type ='basic'/ 'oauth2'
//r.setAuthenticationProfile(authentication type, profile name);
//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();
for(var i=0;i<responseBody.length;i++){
createRecord(responseBody[i]);
}
var httpStatus = response.getStatusCode();
function createRecord(responseBody[i]){
var gr = new GlideRecord('Table Name');
gr.initialize();
gr.FIeldName = responseBody[i].vm;
gr.FIeldName = responseBody[i].name;
gr.FIeldName = responseBody[i].power_state;
gr.FIeldName = responseBody[i].cpu_count;
gr.insert();
}
}
catch(ex) {
var message = ex.message;
}
This way you can fetch the response and then parse it and insert record.. Let me know if you are facing an issue.
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
