I have access to an API. The API takes an XML post as input and then returns an XML response with the relevant data.
I want to
- Send the HTTP Post to the Server (Authentication and Request will be sent together)
- Receive the response (One of the options to be returned is CSV or XML)
- Insert the data into the appropriate rows and columns and then perform data analysis using pivot tables.
I don't have a programming background in excel but am comfortable with different web scripting languages, HTML, CSS, Javascript etc.
Any ideas?