Stephen Tigner

A client needed to extract data from our system and put it into a flat-file format specified by a 3rd-party. Due to the nature of the data they needed and other factors, the data had to be extracted via the web service. However, they did not have the necessary development resources to develop a solution on their own to pull out data via the web service interface we provided. I created a PowerShell script to generate the extracts for this client that they can run on their end. It 1) prompts the user for a few details necessary to connect to the web service and generate the extract, then 2) makes the requests against the web service to get the requested data, then 3) extracts the relevant data from the XML responses, and 4) outputs the transformed data into the specified flat file format.