// Fetch consumers for the given first name and last name and associated
// financial accounts from the remote bank application
function fetchConsumers(consumer_fname, consumer_lname) {

  var request = new sn_ws.RESTMessageV2();
  request.setHttpMethod('get');
  request.setEndpoint('api/getConsumerDetails?fname=consumer_fname&lname=consumer_lname');

  var response = request.execute();
  var responseBody = response.getBody();
  var responseObj = JSON.parse(responseBody);
  var consumers = responseObj.consumers;

  // Create a record in the ServiceNow Consumer [csm_consumer] table for the specified consumer
  var consumerDetails = [];
  consumers.foreach(function(consumer){
    var consumerGR = new GlideRecord('csm_consumer');
    consumerGR.initialize();
    consumerGR.setValue('uid', consumer.uid);
    consumerGR.setValue('name', consumer.name);
    consumerGR.setValue('email', consumer.email);
    consumerGR.setValue('mobile', consumer.mobile);
    consumerGR.setValue('address', consumer.address);
    if(consumerGR.update()){
      consumer.sysId = consumerGR.getValue('sys_id');
      consumer.financialAccount = fetchFinancialAccountsForConsumer(consumer);
    }
  });
}
// Fetch financial accounts for the specified consumer
function fetchFinancialAccountsForConsumer(consumer) {

  var financialAccounts = [];
  var request = new sn_ws.RESTMessageV2();
  request.setHttpMethod('get');
  request.setEndpoint('api/getFinancialAccounts/' + consumer);
  var response = request.execute();
  var responseBody = response.getBody();
  var responseObj = JSON.parse(responseBody);
  var financialAccounts = responseObj.financialAccounts;

// Create a record in the ServiceNow financial_account table for each of the customer's financial accounts
  financialAccounts.foreach(function(finAccount){
    var finAccountGR = new GlideRecord('financial_account');
    finAccountGR.initialize();
    finAccountGR.setValue('uid', finAccount.uid);
    finAccountGR.setValue('type', finAccount.type);
    finAccountGR.setValue('number', finAccount.ac_number);
    finAccountGR.setValue('balance', finAccount.balance);

    if(finAccountGR.update()){
      finAccount.sysId = finAccountGR.getValue('balance');
      financialAccounts.push(finAccount);
    }
  });

  return financialAccounts;
}


// The following retrieves an object to display in UI page

fnmae = ‘john’;
lname = ‘brown’;

var consumerObj = fetchConsumers(fname, lname);

consumerObj.foreach(function(consumer){
  // Display the details on the page and populate it in the form as necessary
  console.log(consumer);
});