Integration of Service Catalog With 3rd Party Tool using REST API's ?

[Gaurav Kumar15]

Hi All,

We have a requirement of integrating Service Now with another toll using REST API integration.

Now, we are trying to run the get Query, which gives us the desired result. We just want to check the Best Practise, like how we can push data from Get Query into the Import Set table(which is staging table) and then can transform synchronously into the Target Table.

If anyone had used Import Sets with REST integration, then could you please guide us from where to start, as this is the first time we are utilizing the functionality of Import Sets, so wanted to know the Best Practices for the same.

Any help will be highly appreciated!

TIA,

Gaurav Kumar

[bernyalvarado]

Hi Gaurav,

The following should be helpful:

Import Set API - ServiceNow Wiki

Thanks,

Berny

[Gaurav Kumar15]

Hi Berny,

Thanks for the link. I went through this already i have few doubts ?

for e.g :- 3rd party tool has the following get request end-point

End point URL :- https://xxxxxx.com/API/v1/xxx/xxx/search

This is the end point they shared. And we have created one table in Service Now by the name "Demo"(u_demo), which acts as our import table(staging). SO for pushing data into staging table, when i used the following link

https://xxxxxx.com/API/v1/xxx/xxx/search/u_demo

It is giving me error as 404, so did i missed anything here for pushing data into staging table ?

Regards,

Gaurav Kumar

[bernyalvarado]

Hi Gaurav, from where is running the application that is reaching your 3rd parth end point URL?

If you're doing that from ServiceNow then you will already have direct access to the table and you don't longer need to access it through REST. If your application is outside ServiceNow then I believe you only need the table name on the URL (without the search) as it is shared on the wiki:

POST /api/now/import/(staging TableName)

Thanks,

Berny

[bernyalvarado]

And here goes another helpful link (using SOAP) Web Service Import Sets - ServiceNow Wiki

Thanks,

Berny