Update remote information in the system of record
Summarize
Summary of Update Remote Information in the System of Record
This content outlines the process for updating a customer's credit card limit in a remote bank application using ServiceNow workflows. The integration allows ServiceNow to communicate with the bank's system of record, ensuring that customer information is accurate and up-to-date.
Show less
Key Features
- The integration uses a REST API endpoint, POST /api/card/updateLimit, to facilitate communication between ServiceNow and the bank application.
- Data is retrieved from the Consumer [csmconsumer] table for customer records, ensuring proper data handling before making the update request.
- ServiceNow scripts manage the request process, including the preparation of the request body with necessary credit card details and limits.
Key Outcomes
By following this process, ServiceNow customers can:
- Update credit card limits in the bank application efficiently, ensuring alignment with the system of record.
- Reduce discrepancies between the ServiceNow database and the bank's records by relying on the most current information.
- Utilize example JavaScript code to implement the update functionality, facilitating quick integration into existing workflows.
This integration scenario illustrates how to update a system of record within the bank application.
In this scenario, a script in a ServiceNow workflow makes a request to the remote bank application to update a customer's credit card limit. If the new limit is approved, the customer limit is updated in the bank application (system of record).
The table that is accessed in this scenario is the Consumer [csm_consumer] table which contains the business-to-customer records.
The following diagram shows the flow of the REST API calls for this use case and provides brief remarks on any required processing. It assumes that you have used the steps outlined in Lookup remote information in the system of record to obtain the customer account information.
|
Example code
// Shows how to request the increase the credit limit for a specified card
// This code assumes there is a REST endpoint 'api/card/updateLimit' on the bank application system
// REST call to the /api/card/updateLimit endpoint to request
// an update to the customer's credit card limit
function updateCreditLimit(requestBody) {
var request = new sn_ws.RESTMessageV2();
request.setHttpMethod('post');
request.setEndpoint('/api/card/updateLimit');
request.setRequestBody(JSON.stringify(requestBody));
var response = request.execute();
var responseBody = response.getBody();
var responseObj = JSON.parse(responseBody);
return responseObj;
}
// The following is the data object sent to the /api/card/updateLimit endpoint
// to increase the credit limit for the card
var requestBody = {
'cardNumber': 'xxxx-xxxx-xxxx-5896',
'accountNumber': 'xxxxxxxxxxxx9590',
'oldLimit': 'USD 5000',
'newLimit': 'USD 10000',
'requestType': 'Increase_limit',
};
updateCreditLimit (requestBody);