{"id":322,"date":"2017-07-02T11:03:11","date_gmt":"2017-07-02T11:03:11","guid":{"rendered":"http:\/\/www.awonderfulchoice.com\/web\/?page_id=322"},"modified":"2021-08-12T15:39:44","modified_gmt":"2021-08-12T15:39:44","slug":"rest","status":"publish","type":"page","link":"http:\/\/www.awonderfulchoice.com\/web\/rest\/","title":{"rendered":"RESTful Web Services"},"content":{"rendered":"<p style=\"text-align: left;\">I have extensive experience of consuming and publishing RESTful web services. Using mainly PhP and SQL\u00a0I have created services that:<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.awonderfulchoice.com\/web\/wp-content\/uploads\/2017\/07\/rest.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-313 alignright\" src=\"http:\/\/www.awonderfulchoice.com\/web\/wp-content\/uploads\/2017\/07\/rest-300x257.jpg\" alt=\"\" width=\"300\" height=\"257\" srcset=\"http:\/\/www.awonderfulchoice.com\/web\/wp-content\/uploads\/2017\/07\/rest-300x257.jpg 300w, http:\/\/www.awonderfulchoice.com\/web\/wp-content\/uploads\/2017\/07\/rest-768x658.jpg 768w, http:\/\/www.awonderfulchoice.com\/web\/wp-content\/uploads\/2017\/07\/rest.jpg 782w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<ul style=\"text-align: left;\">\n<li>control access to specific databases<\/li>\n<li>parse requests and convert JSON as required<\/li>\n<li>error trap malformed or illegal requests<\/li>\n<li>form database connections using ODBC and php libraries<\/li>\n<li>audit requests<\/li>\n<li>handle responses and convert as necessary<\/li>\n<\/ul>\n<p style=\"text-align: left;\">Consuming REST services within SQL I have written:<\/p>\n<ul>\n<li style=\"text-align: left;\">OLE SQL stored procedures to issue requests and receive responses<\/li>\n<li style=\"text-align: left;\">Convert JSON to XML and vice versa<\/li>\n<li style=\"text-align: left;\">Error trap standard errors where services are non responsive<\/li>\n<li style=\"text-align: left;\">Retrieve data from the HTTP header such as cookies<\/li>\n<li style=\"text-align: left;\">Parse the responses to provide targeted and bespoke output<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I have extensive experience of consuming and publishing RESTful web services. Using mainly PhP and SQL\u00a0I 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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-322","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.awonderfulchoice.com\/web\/wp-json\/wp\/v2\/pages\/322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.awonderfulchoice.com\/web\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.awonderfulchoice.com\/web\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.awonderfulchoice.com\/web\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.awonderfulchoice.com\/web\/wp-json\/wp\/v2\/comments?post=322"}],"version-history":[{"count":3,"href":"http:\/\/www.awonderfulchoice.com\/web\/wp-json\/wp\/v2\/pages\/322\/revisions"}],"predecessor-version":[{"id":830,"href":"http:\/\/www.awonderfulchoice.com\/web\/wp-json\/wp\/v2\/pages\/322\/revisions\/830"}],"wp:attachment":[{"href":"http:\/\/www.awonderfulchoice.com\/web\/wp-json\/wp\/v2\/media?parent=322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}