Ravi Kumar Blog Posts

We all know the REST API service calls and the way of using OOB feature:   REST API Explorer   using SN. There are some instances where we can call/integrate SN from other systems/tools like Postman/ReactJS/Python etc. Of course we don’t have a biz requirement to consume SN services to fetch the data & use it (Eg: List of Incidents, call a SN module etc). We can connect SN from outside by using any of the below authentications. Basic – direct user/pwd in the API call and is not that secured OAUTH – 2 step process to connect and is secured option JWT – Secured option and I am still working on this.   For the above mentioned, I have taken Postman as the source to call SN API service (Email API)      https://dev119117.service-now.com/api/now/v1/email Basic authentication : Used my user/pwd to connect my PDI and then send email from Postman Request Body:                     { ...

Here is the way I found to setup Java/JRE path in MacBook and we don't need to use any tools. Before following the below steps, we need to have Java/JRE software needs to be present in the sys. I have a trick for this too  😃  What I did is like I installed Eclipse tool and I got the path where we have the JRE folder setup in Eclipse (My path:  /Users/rpisupat/.p2/pool/plugins/org.eclipse.justj.openjdk.hotspot.jre.full.macosx.x86_64_19.0.0.v20221005-1658/jre ). I copied the entire JRE folder (cp -R command) into my /Documents/Java path and used that for setting the java path as mentioned below. After that, tried with a simple hello world program and I am all set  😊 Setting the java path in Mac permanently: follow these commands on terminal % vim ~/.zshrc Press i key to add the below line export JAVA_HOME=/Users/rpisupat/Documents/Java/jre Press esc key Press :wq Quit from Terminal and open a new Terminal instance Type java from the new Terminal Test a simple java p...

Using the built-in /sys_import.do 'API' it's possible to import CSV or Excel files directly. There's no need to use a MID Server for this, it can be done from any host where you have the relevant tools (either a script that can do POST requests or a program such as Postman). Note that there's also nothing stopping you doing this import from a MID Server host.     Note:   the file content itself must be uploaded as a POST request, as a multi-part attachment. The name (key) of this parameter can be called anything you like.   Pls note that there's also nothing stopping you doing this import from a MID Server host. Those who are interested to work on this, give a try in your free time and let me know if any questions   😊   Here are the simple steps can be followed to achieve this: Create a simple test CSV file Upload the CSV file once manually using 'Load Data' on the instance, to create the necessary Import Set Staging table (e.g. u_mytestimport) D...