[Music] please subscribe to my channel and click on the bell icon to get the regular updates of my channel and do not forget to like comment and share hello everyone welcome to sas with servers now in this video i will show you an application i created in servicenow which is integrated with covin portal covin portal provides information about the vaccination in india so i have just tried to use its public apis and how can i fetch some information and store in servicenow system for that i have created an application scoped application so let's see in my personal developer instance so this is my personal developer instance now in order to integrate basically with any third party application that third party application should have some apis so that it can expose those apis and we can use it so similarly you can also find coven application coven portal apis so here it says protected one but you also have public apis so i have used public apis in which i was able to fetch information about estates and i was able to fetch information about districts and you can search for the state id as well what all districts you have within that particular state now i was able to fetch these information because these are publicly available right now however if i talk about appointment sessions they need some authentication moreover even sessions are available publicly you can see it says public that means you can still get the sessions but i'm still getting some error from service now maybe because of some and the error i'm getting it just telling me that maybe the traffic there's a lot of traffic on the website that's the reason you're not able to fetch the data so what i did and just to show you that how exactly i did this integration so i just try to pull the data of states and districts so in that case my goal is just to make you understand that how you can integrate with a fresh new application so cohen application is pretty much new so i just thought if we can utilize the power of service now and create some some kind of a dashboard or some kind of application so that users can basically uh get the details of the vaccination and also they can register the appointments for vaccination with the help of servicenow systems servicenow platform so i will just directly go to uh my instance and now i will type here so the name i gave to this application is cohen so you can see this is the application i created what i did now because how exactly you can search for vaccination slots and all so you can search with restricts pin codes states what i did i created three different tables now this one is transaction it's just to tr see the transactions and how many transactions i'm doing to that particular portal so for that what i did as i mentioned i created a scoped application so i will go here studio you can see i created a lot of tables so i created like these four tables like this and you can see i will also show you the data and here is district we have pin codes we have this is the coven api now i have to fetch the data so i just created a few outbound apis you can see here get location by states get sessions guess district by states and then here is this scheduled script basically so i i just execute the script and you can get that data now this is basically the script includes so this is calling the script include and the function in that script include and where we have that script include i will quickly go here so you can see this i have this uh function written over here uh this one get states which basically gets the states so if i will go to here you can see that i can get all the states what i did i'm just fetching all the states and i'm storing that here so if i click this you can see i'm getting all the states you can see some bogus names as well the reason is because that's coming from the test server that's the reason you're not getting the actual actual name like dnm state dh state these are all test states so as i mentioned i just did it just for demo purpose to see how can i integrate and how can i use power of service now so if i go here and i will show you the second function the second function i wrote get district because we have different uh different endpoint for uh district as well so you can see we have state id so you have to provide the state id so i'm storing that state and then i'm providing the state id which i am also storing so you can see i have this id and then i am pulling district as well as of now it is just showing 24 that's what that's kind of response i'm getting from that test server but yeah if you will be able to get the authentication details then you can definitely fetch all the data not even this the data which is public if you will be able to access with this like for all these apis then you can definitely create a concrete application a solid application which can basically can be used by the users to uh create the appointments get the data of the vaccination slots and all that's something you can definitely do so as i mentioned i just did it with this these two uh these two different parts i have and we have created script include we have created uh the scheduled job which can keep on running and check for the new states maybe it it's some time it might happen right that's the reason i wrote in schedule job so that my system can keep on checking that hey do i have a new district do i have a new maybe uh the coven portal doesn't have that ideally it should have all the states so maybe it's kind of a one-time one-time job which you just run and fetch all the details but if if let's say if that particular site is getting is getting updated then you can just write this in schedule job and you can get the data frequently and as i mentioned we have created this outbound rest apis we are just getting so we're not posting anything it's all get but you can still post so you can see we have post method as well for rest apis and and this is the application i created this is the pin code so if you get the restrict data and if you want to store pin codes as well so i have created that as well but i did not fetch that information but here we have district and here we have states that's how i have integrated one of my application i think i just created this application in just one hour and i just use the application studio and i was able to create this application i just use the end point provided by this cohen portal and i will i was able to fetch that data you can see it says demo data so i'm all i'm i'm getting all demo data and i was able to fetch the data and store in my service now instance so this is how you can integrate a service now with cohen portal and if you're able to get the authentication then you can also create a full-fledged application and and utilize uh maybe maybe for different users thank you for watching this video if you like my channel and videos please do not forget to subscribe to my channel like my videos and comment on my videos and share my channel and videos thank you and have a great day