|
OK OK I'm web stupid this is what I want to do. Using SQL Anywhere 16 I want to call the following web service in a stored procedure or function. https://services.gisgraphy.com/reversegeocoding/search?lat=36.93356&lng=-75.95025&format=xml |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 11 Jan '21, 15:09
question was seen: 1,480 times
last updated: 15 Jan '21, 12:19
Have you looked at the docs? See http://dcx.sap.com/index.html#sa160/en/dbreference/create-procedure-statement.html
Thanks I did take a look but it's greek to me. It seems whomever wrote the help assumed much more knowledge than I have on the subject. Sample procedures shown also are in a strange non-watcom language.
Hm, that's probably just a misunderstanding: The web client procedures do not have a body, they just define the call the database server has to do (i.e. the web request) – similar how external procedurs do not have a body but define the external DLL/function that will be called.
Usually you will have a two-stop approach:
If I find some time (currently I don't), I could provide a small sample.
But looking for questions with the "webclient" tag might give you further hints.
It would be something like:
create or replace procedure foo() url 'https://services.gisgraphy.com/reversegeocoding/search?lat=36.93356&lng=-75.95025&format=xml' type 'https:get';
Note that I get a 401 error when invoking this procedure. The gisgeography documentation suggests that this means "Need auth. The API key parameter is missing, wrong, or doesn't correspond to any subscriptions".
Thank you both I'm going to check the api and try this over the weekend.
FWIW, with 17.0.10.6175, I do get SQLCODE -990 here (" The secure connection to the remote host failed: The TLS handshake failed"), even if I add a CLAUSE LIKE
and
set 'HTTP(VERSION=1.1)';