Ravi Kumar Blog Posts

  The  ServiceNow CLI  is a command-line interface that lets us to perform instance operations from our local system. We can extend the CLI to include new commands that meet the application's needs. Benefits The ServiceNow CLI lets us to: Perform basic CRUD operations on records in SN instance. Develop custom components and deploy them to SN instance to personalize a UI. Create custom commands that enable to manage custom applications from the command line. Use the ServiceNow CLI in scripts to simplify setup tasks and operational activities.   Architecture Commands are stored in a table on the instance where we are connected to. When the  ServiceNow CLI  connects to the instance, it receives all the available commands supported by that instance.   Commands map to a REST endpoint that executes asynchronously.  Activating  ServiceNow CLI in Windows machine:   Here are the steps I followed to run this functionality succe...

Here I am explaining on how to read a CSV file from an FTP location and insert the records into ServiceNow on a periodical manner.  Before starting this exercise, we need the below prerequisites. CSV File with few records (Eg:Employee) Target table in ServiceNow to store the file records Transform map to load the records into ServiceNow FTP server to store the CSV file. For this, we have a free FTP file server:  https://byet.host/free-hosting/   Data source record to map the FTP server path Scheduled Imports record to schedule the run for uploading the file data periodically After following all the above steps, we see the list of records in ServiceNow at the end. References: 1) www.Google.com 2) https://docs.servicenow.com/ 3) https://developer.servicenow.com/ 4) https://byet.host/

We can login into ServiceNow with External Sign in options like Goggle, OKTA, Facebook etc if we have OIDC configuration details with us like 1.    Client ID 2.    Client Secret 3.    Well-known configuration URL  Here I am talking about Google OIDC configuration in SN. Before we start the implementation, we need to have the below plugins installed in SN. 1) com.snc.integration.sso.multi.installer 2) com.glide.e_signature_approvals First, we need to setup Google configuration. Here are the steps to be followed. Login into Gmail Account and open: https://console.developers.google.com ·       Create a project and generate OAuth Client ID credentials ·       In the credentials Section update the ‘Authorized Javascript Origins’ and ‘Authorized Redirect URLs’ with PDI details like:  https://devXXXX.service-now.com  and  https://devxxxx.service-...

LDAP integration allows SN instance to use existing LDAP server as the master source of user data. It is part of Single Sign On (SSO) implementation. Lightweight Directory Access Protocol (LDAP) is a client/server protocol used over an IP n/w to manage and access the distributed directory info service. LDAP directories are structured as a tree of entries, where each entry consists of set of attribute-value pairs describing one object. LDAP is not limited to contact info or even info about people. LDAP notations: on means organization name, ou means organization unit, dc means domain concept, cn means connection name, uid means user id, dn means distinguished name. For more info on LDAP, pls google it. LDAP servers supported by SN are: 1) MS Active Directory 2) Novell 3) Lotus Notes 4) Open LDAP Before working on the changes in SN side, we need to have LDAP server. We have a free LDAP server and is read-only and here is the site for more info. https://www.forumsys.com/2022/05/10/onl...

  It took some time to work and complete a small usecase (PoC) to integrate both SF and SN platforms. The idea is very simple. Whenever we create a new user from SN (sys_user), I am making an API call (REST) to SF via a Business Rule (aync) logic from SN and creating the new acct in SF successfully. To work on this, I took our UHCSand (EWD) and my SF developer portal. Before implementing it, I was able to make a successful service call to SF (OAuth2) using Postman.   Here are the snapshots for better understanding. Postman connectivity - Success Updates in Salesforce portal – Success for both Postman and SN user: Ravi Kumar Pisupati The changes I have made in my PDI env: REST Message instance and the corresponding HTTP Method: OAuth Provider and Application Registries instances: Business Rule instance to make an async call to SF after creation of a new user from SN. This is the key for the whole PoC and it runs on the table: sys_user   References: 1) https://www.goog...