- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-07-2017 06:57 AM
Hello community,
I need some answers, guidance and advise on an integration we're working on with an external system MIM (Microsoft Identity Manager).
Basically in ServiceNow we're are managing users requests for SAP roles exemptions (created through Service catalog).
This will create a service request with requested items (one by role) and a catalog task (one by requested item).
The catalog task is where the external system MIM will query informations (like the user, his position, the SAP role, etc) and at the end will update the task to close it.
So the external system will do two types of interactions with ServiceNow: Query and Update. It also has been stated that the external system will be the one to pull and push information periodically.
We need to provide an Inbound web service to the external system (we're going to use REST/JSON)
Here is where I need answers and guidance:
From what I read so for in the community, SNOW documentation and best practices videos:
- We can use a direct inbound web service to a SNOW table (ex: sc_request_task) when the system pull (query) information
- We can use an Import set web service when the system push (create, update) information
In our case, the external system will:
1- Initially query information in SNOW by getting the catalog task informations related to SAP roles exemptions.
2- Process the information
3- Finally update the catalog task to close them
- Can we use an Import set web service when initially an external system is only querying information from SNOW?
- Or we have to use a direct web service first and then an import set web service for the updates in SNOW?
- Or is there any other options
Thank you
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-12-2017 12:33 AM
Hi
You can do it any way you like
- The external system can first query it identify the record it needs to update. Then it can call an update API to do the update. Whether you choose to do this via an import set or via a scripted REST API is up to you, but personally since it is not an import as such, but more an integration I would do a scripted api.
- You could also just do the second step (the update) if the external system can provide you with a number of values (user, case number ect) so that you in the update service can determine which record to update.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-18-2018 02:06 PM
Hi again Lars,
still need guidance if you have a moment...we've been successful at setting up the SOAP connection between BODS and ServiceNow, however on the BODS side only "Get" is working, but not "getRecords", in your experience is there anything on our ServiceNow instance that needs to be "unlocked" for "getRecords"? thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-20-2018 04:12 AM
Hi
No getRecords should work the same as any other method.
Again I would advice you to use a "neuatral" tool like SoaaUI to test with. This will quickly tell you if the issue is on the SAP side or in servicenow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-20-2018 08:06 AM
great and thanks again. We actually have tested in the SoapUI tool and everything is working fine with the SOAP connection. So based on that you'd say the issue must be in the SAP tool?
