Pulling data into Servicenow from a third party

[paradise611]

Hi All,

I need to pull data from a third party website into ServiceNow, what is the best method to complete this?

[DilipKumar DJ]

Hi,

When you are configuring REST message in Servicenow, you are actually getting the schema of third party and converting it Servicenow compatible sample code. So that you can use this code for querying/pulling the require data.

Authentication is required in most cases unless they have made public and in REST you would have to provide them in the form of HTTP headers.

[paradise611]

Hi Dilip,

I just found out they are using SOAP not Rest. How does this change things? Also I have access to their WSDL, now I am waiting on authentication to be able to query the data from their system. However how do I know which fields I need from their system or   is there a query to pull everything over? Will I still need to know which fields I need from the third party system to be able to bring in that data into ServiceNow?

[Steven1]

This should help

Running a REST query to populate a table

[Ashby]

Regarding the fields......yes, you will need to know what fields you need to bring over.   The third party site should have an API reference for you to use which normally include the data points exposed and the location of the WSDL/XDS files.   Below is an example from the PayPal API reference.... .

PayPal SOAP API Basics - PayPal Developer

[paradise611]

Hi John,

Yes they provided me with a   Wsdl but the fields aren't quite clear on there. Should I ask for the fields? or should they be clear in the Wsdl?