Integration with Asset Management

[punitchourey]

Hi All,

We have to integrate Asset management with another Tool. We have got the API and credentials of the of the third party tool.

1. We need to consume their API and get Asset details from their tool using REST.

2. Whenever there is an insert/update to the Asset on their tool, we need to get those records and push them into the staging table. Then we need to push the data from staging table to actual table in servicenow.

Please suggest the solution for this integration.

Thanks

[punitchourey]

Thanks Varsha. I will check those links.

[Ashutosh Munot1]

Hi Brother,

Here you go:

I have couple of approaches use which you want.

A) Real Time Approach:

1) Create Staging table extended with Import set table.

2) Give End point of this Staging table to Third party tool admin.

3) As soon as there is any insert in third party tool ask them to post the data to our staging table.

4) Write a transform map on this staging table and map the fields to our target table i.e. alm_asset.

5) Do necessary validation in transform scripts of transform maps.

B) Scripted Rest Approach:

1) Create a scripted REST API.

2) Give the endpoint to admin of third party tool and ask them to consume it.

3) Once it hits the Endpoint we will write a code in scripted rest service so that it will directly create update record in out target table.

4) We can send custom response to third party tool as well.

Thanks,
Ashutosh Munot

[punitchourey]

Thanks Ashutosh for the update.

Agreement is that, we will hit their API on hourly basis. There is a GET method in their API. When we hit their API on hourly basis, we should get the updated that and then push them in staging table we created and then to actual table.

Thanks,

Punit

[Ashutosh Munot1]

HI,

This will be a serviceNow to third party call. This will be scheduled import of data or assets then.

Sounds good, create a inbound rest message with get method and do it in script include. This script include will put records into staging table and then transform map will trigger.

Thanks,
Ashutosh Munot

[punitchourey]

Hi Ashutosh,

Thanks for your input. 

One more thing i want to ask is that the API provided by client is accessible in client's network only.

https://xxx.xxx.xxx.xxx

How to proceed in this case.

Thanks,
Punit