I have a web service I need to consume that can only be accessed in SOAP. Our sites still run in Classic ASP, so the script must be written in Classic ASP (VB Script).
The webservice is a standard webservice that requires four pieces of data to be passed (login, password, license plate, license plate state), and returns an array of information that needs to be consumed.
What I need from you is a SQL Ready script for consumption based on the results of the webservice:
If there is no result, then a flag to indicate not to do a database insert, otherwise, write a sql statement similar to:
insert into tbl_people (first_name, last name, address, city, state, zip) values (results_from_webservice)
Documentation and sample .net code attached for review. I estimate this would take 2 or less days to complete (including any fixes / changes)