question Re: Integration with Asset Management in Developer forum

Integration with Asset Management

punitchourey — Wed, 25 Jul 2018 12:17:09 GMT

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

Re: Integration with Asset Management

punitchourey — Thu, 26 Jul 2018 06:26:04 GMT

Hi All,

Can you please suggest how to proceed in this.

Thanks,

Punit

Re: Integration with Asset Management

punitchourey — Thu, 26 Jul 2018 10:41:37 GMT

Hi All,

Please let me know the approach that can be used.

Thanks,

Punit

Re: Integration with Asset Management

punitchourey — Fri, 27 Jul 2018 04:27:54 GMT

Can someone guide me on this.

Thanks,

Punit

Re: Integration with Asset Management

Varsha21 — Fri, 27 Jul 2018 04:52:49 GMT

Hii punitchourey ,

hope following links will be helpful for you,

https://docs.servicenow.com/bundle/kingston-application-development/page/integrate/outbound-rest/concept/c_OutboundRESTWebService.html

https://community.servicenow.com/community?id=community_blog&sys_id=ecfc62a5dbd0dbc01dcaf3231f9619ac

if useful mark it correct or helpful,

Regards,

Varsha.

Re: Integration with Asset Management

punitchourey — Fri, 27 Jul 2018 05:10:58 GMT

Thanks Varsha. I will check those links.

Re: Integration with Asset Management

Ashutosh Munot1 — Fri, 27 Jul 2018 05:11:59 GMT

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

Re: Integration with Asset Management

punitchourey — Fri, 27 Jul 2018 05:19:16 GMT

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

Re: Integration with Asset Management

Ashutosh Munot1 — Fri, 27 Jul 2018 05:36:37 GMT

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

Re: Integration with Asset Management

punitchourey — Mon, 30 Jul 2018 04:34:57 GMT

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

Re: Integration with Asset Management

Ashutosh Munot1 — Tue, 31 Jul 2018 04:09:09 GMT

HI,

Is that Third party tool on Cloud and not in secured network, If it is on premise or secured in network then you have to do communication via mid server which should be installed in client network.

Thanks,
Ashutosh

Mark answer as correct and helpful if it is satisfied reply.

Re: Integration with Asset Management

punitchourey — Thu, 09 Aug 2018 07:45:44 GMT

Hi All,

The API is accessible within client's network. Also they have provided only the key to test the API.

What authentication do we need to use?

Thanks,

Punit

Re: Integration with Asset Management

Ashutosh Munot1 — Thu, 09 Aug 2018 11:26:08 GMT

Hi,

Is there any Mid Server installed in Clients network. If yes then use MID server to contact the API.

Also you required atleast read access to this API. So ask them as user with password and Name, which you can put in basic authentication.

Thanks,
Ashutosh