I have extensive experience of consuming and publishing RESTful web services. Using mainly PhP and SQL I have created services that:
- control access to specific databases
- parse requests and convert JSON as required
- error trap malformed or illegal requests
- form database connections using ODBC and php libraries
- audit requests
- handle responses and convert as necessary
Consuming REST services within SQL I have written:
- OLE SQL stored procedures to issue requests and receive responses
- Convert JSON to XML and vice versa
- Error trap standard errors where services are non responsive
- Retrieve data from the HTTP header such as cookies
- Parse the responses to provide targeted and bespoke output