javascript - Calling a RESTful web service using SSIS -
i need call restful web service using ssis.
the web service accepts json object parameter - can call service constructing json object using javascript:
data = { customerkey: "demo", apikey: " 9999aa99-999a-9a9a-99a9-99999999a999", registrationno: "reg n02", insuranceref: "ins ref", vehicletype: "lorry", carmake: "car make", carmodel: "car model", chassisno: "chassisno", grossplatedweight: "gp weight", manufactureyear: 1999, vehiclestatus: "hired", deliverydate: null, transferdate: new date(2004, 4, 1, 0, 0, 0).tomsdate(), lastmotdate: new date(2013, 12, 1, 0, 0, 0).tomsdate(), lastinspectiondate: new date(2013, 1, 11, 0, 0, 0).tomsdate(), lastservicedate: new date(2014, 2, 2, 0, 0, 0).tomsdate(), informationlog: "information log , more information", vehiclenotes: "vehicle notes", entityreference: "reference", userootorgunit: "true", adddictionaryitemifmissing: "true"};
and posting object web service. web service returns json object.
however, javascript not available me in ssis - possible call such web service using ssis? if so, can me link show steps necessary? (i have no experience ssis).
thanks.