Trying to pull data from Service now using WSDL

[swe1]

I am trying to pull data from Service now into our EDW. I am using SSIS, I read about the performance issues and see there are other tools which would help replicate the tables. But for now when I am using SSIS's Web Service task and use 'get records' method, I do not see any records pulled. But when I do a csv on the same I see lots of records in the browser.

below is the wsdl I am using for incident

https://NAME.service-now.com/incident.do?WSDL

and when I run the same with ?CSV it shows me records.

I have output to an xml, there is no error when I run the package all I see is

<?xml version="1.0" encoding="UTF-16"?>

<Result>The result is null. Either the result is null or the Web method returns void.</Result>

Please suggest.

Thank you.

[geoffcox]

WSDL just gives you the xml definition needed for a soap request, and is not a request for data itself.

Having said that, I don't know what SSIS is or what it does with the WSDL once it gets it.

[swe1]

SSIS is SQL Server Integration services, it acts like an ETL. On SSIS I use the Web Service Task. This WebService tasks uses a HTTP connection with the WSDL and credentials in it. And on the Web Service task we can select the method(Get records as Input) to be run and it should push the output to an xml file(output). My output file is empty. I am trying   to get all the Incidents.

[geoffcox]

have you tried "incident_list.do" instead of "incident.do"?

[swe1]

Yes I did try that. No Luck with it.