ServiceNow Multiple API calls from excel
€8-30 EUR
Kiszállításkor fizetve
Hi there! My team gets an excel spreadsheet with multiple info, we focus only on one, that we copy and execute an API call via the ServiceNow native REST API Explorer ($[login to view URL]) , hit the send button, search for one particular info "inventory status" and save the reply into excel. We would like to automate this as we get a hundres of values that we need to collect the API answer.
Please design a solution.
Source is excel spresheet collum makred "site_global_location_id" , then there is the API call. Response is json with many rows. We are looking for one unique value "inventory_status":"ACTIVE"
Example source excel , column2=site_global_location_id"
column1 column2 column3
loreipsum XjgIhpNgLg loreipsum
loreipsum X9gczas67H loreipsum
loreipsum XGsMKKqKiH loreipsum
API call:
GET [login to view URL]
Expected output:
XjgIhpNgLg - API OK - Inventory Status: ACTIVE
X9gczas67H - API OK - Inventory Status: site not found
XGsMKKqKiH - API failure
The solution can be executed as ServiceNow app, or Microsoft Power Automate app or anything that can be executed on computer of the agent. This servicenow instance is in isolated network and it cannot be reached from internet. (therefore no web app to execute this automation)
Please recommend design solution first. I need to validate if that is doable within the network and our system before moving to next step.
Projektazonosító: #36972635
A projektről
Odaítélve:
Hello, I am interested in your project. I am a Telematics Engineer, with more than 10 years of experience in technology and specialized in DevOps, Automation. I am new to this platform, I propose a free first deliverab Továbbiak
6 szabadúszó tett átlagosan 60€ összegű árajánlatot erre a munkára
I already worked on such automation task. I have read your requirement and I can easily work on this. I have more than 8 years of experience in IT field. And I have mainly experience on .net and c#. I have vast experie Továbbiak
Hello there! My name is Carlos and I'm a freelance developer with extensive experience in web and desktop application development. I have a strong background in web development which makes me well-suited to build scala Továbbiak