Oct 14, 2021
06:02 PM
1 Kudo
Following on from comments on the post "New ServiceNow Scoped App v5.0.6 is now Available in ServiceNow Store", I'm interested to understand the sequence of events in the data exchange between Data Platform and ServiceNow (more-so than the technical specs of the API's). I'm a ServiceNow developer tasked with implementing this integration for a client.
I find it unusual that the documentation is lacking in detail. Other than the tables involved and simply entering credentials. I've had to work backwards to find out how we're receiving data into the ServiceNow platform.
Below is my guess on how the data is exchanged from FDP to ServiceNow? I'm not as concerned with FNMS and Inventory CI data but more rather than normalized hardware and software model and information.
Step
1
Scheduled Job runs in Flexera (Data platform?/FNMS?)at (x) Interval
2
Queries SN Instance via "/api/x_fls_flexera_fnms/v1/integration/can_export" until true result is returned
3
Triggers REST call to "/api/x_fls_flexera_fnms/v1/integration/export"
4
This triggers scheduled jobs (x,y,z) in ServiceNow to export .CSV files to MID server noted in Export Sets
5
Flexera Polls Export Status on SN instance ("/api/x_fls_flexera_fnms/v1/integration/export_status") until export job complete
6
FDP normalizes data from CSV Export in MID server
7
FDP Queries 'Can Import' ('/api/x_fls_flexera_fnms/v1/integration/can_import') until true
8
Data transfered from FTP in batches via Import ('/api/x_fls_flexera_fnms/v1/integration/import')
9
FDP Polls Import Progress Status ("/api/x_fls_flexera_fnms/v1/integration/import_progress_status") until complete
10
Once import complete status returned import complete message sent to trigger data import/transform in ServiceNow ('/api/x_fls_flexera_fnms/v1/integration/import_data_complete')
Is this following a similar path to the high level process for FNMS is documented here on page 314?
https://docs.flexera.com/ServiceNowFlexeraIntegrationApp/FlexNetManagerSuite/v505/FlexeraIntegrationApp.pdf
It would be great if there were some further detail on the actual sequence of data exchange.
Apologies if a bit wordy, but I'm trying to understand the ins and outs of this without much documentation to go on!
Thanks for your help.
- Stephen
... View more
Oct 13, 2021
05:56 PM
Hi Ubhatt, Thanks, but this documentation does not go into any detail about the methods of data exchange between Flexera and ServiceNow, only that there is a scheduled job that runs. If you look at the Flexera Integration scripted rest service there are 17 endpoints: https://[your_instance_here].service-now.com/nav_to.do?uri=sys_ws_definition.do?sys_id=155cee970fbe5200b49e47bce1050e10 name http_method active relative_path operation_uri web_service_definition web_service_version Can-Import GET TRUE /can_import /api/x_fls_flexera_fnms/v1/integration/can_import Flexera Integration v1 Version GET TRUE /version /api/x_fls_flexera_fnms/v1/integration/version Flexera Integration v1 Last-Successful-Import GET TRUE /last_successful_import /api/x_fls_flexera_fnms/v1/integration/last_successful_import Flexera Integration v1 Cancel-Import-Status GET TRUE /cancel_import_status /api/x_fls_flexera_fnms/v1/integration/cancel_import_status Flexera Integration v1 Import-Status GET TRUE /import_status /api/x_fls_flexera_fnms/v1/integration/import_status Flexera Integration v1 Is-SAM-Plugin-Enabled GET TRUE /is_sam_plugin_enabled /api/x_fls_flexera_fnms/v1/integration/is_sam_plugin_enabled Flexera Integration v1 Can-Export GET TRUE /can_export /api/x_fls_flexera_fnms/v1/integration/can_export Flexera Integration v1 Export-Status GET TRUE /export_status /api/x_fls_flexera_fnms/v1/integration/export_status Flexera Integration v1 Cancel-Export-Status GET TRUE /cancel_export_status /api/x_fls_flexera_fnms/v1/integration/cancel_export_status Flexera Integration v1 Import-Progress-Status GET TRUE /import_progress_status /api/x_fls_flexera_fnms/v1/integration/import_progress_status Flexera Integration v1 Test-Connection GET TRUE /test_connection /api/x_fls_flexera_fnms/v1/integration/test_connection Flexera Integration v1 FNMSToSN POST TRUE /fnmstosn /api/x_fls_flexera_fnms/v1/integration/fnmstosn Flexera Integration v1 Cancel-Export POST TRUE /cancel_export /api/x_fls_flexera_fnms/v1/integration/cancel_export Flexera Integration v1 Export POST TRUE /export /api/x_fls_flexera_fnms/v1/integration/export Flexera Integration v1 Cancel-Import POST TRUE /cancel_import /api/x_fls_flexera_fnms/v1/integration/cancel_import Flexera Integration v1 Import-Data-Complete POST TRUE /import_data_complete /api/x_fls_flexera_fnms/v1/integration/import_data_complete Flexera Integration v1 Import POST TRUE /import /api/x_fls_flexera_fnms/v1/integration/import Flexera Integration v1 As far as I can tell there is no documentation available for these API's, both what they are sending or receiving - are there any API Specifications available? Thanks, - Stephen
... View more
Oct 13, 2021
04:59 PM
Hi there, I would like to know if there is any documentation available for the exchange of information from Flexera/ServiceNow, both from the Data Platform and FNMS in relation to APIs and the API Specifications? I can see the various scripted REST API's in ServiceNow that get created as part of the app installation, but I cant seem to find any data flow documentation, or API specfications, such as sample payloads, expected headers, etc. Does this exist? Thanks, - Stephen
... View more
Oct 13, 2021
04:59 PM
Hi there, I would like to know if there is any documentation available for the exchange of information from Flexera/ServiceNow, both from the Data Platform and FNMS in relation to APIs and the API ? i.e. - wh
... View more
Latest posts by stephenlagan
Subject | Views | Posted |
---|---|---|
539 | Oct 14, 2021 06:02 PM | |
865 | Oct 13, 2021 05:56 PM | |
890 | Oct 13, 2021 04:59 PM | |
891 | Oct 13, 2021 04:59 PM |
Activity Feed
- Got a Kudo for Data exchange between Data Platform and ServiceNow. Oct 15, 2021 07:38 AM
- Posted Data exchange between Data Platform and ServiceNow on Data Platform Forum. Oct 14, 2021 06:02 PM
- Posted Re: New ServiceNow Scoped App v5.0.6 is now Available in ServiceNow Store on Data Platform Release Blog. Oct 13, 2021 05:56 PM
- Posted Re: New ServiceNow Scoped App v5.0.6 is now Available in ServiceNow Store on Data Platform Release Blog. Oct 13, 2021 04:59 PM
- Posted Re: New ServiceNow Scoped App v5.0.6 is now Available in ServiceNow Store on Data Platform Release Blog. Oct 13, 2021 04:59 PM