Problem with API Geocoding - Hana XSJS

[LeonardoRomanato]

Hi all,

I'm trying to geocode some addresses with API Geocoding, in Hana XSJS. 

I made a GET request to geocode-api.arcgis.com/arcgis/rest/services/World/GeocodeServer/findAddressCandidates?<parameters>, where in the paremeters I inserted

• Token: the access token
• address: an example address ('1600 Pennsylvania Ave NW, DC')
• pjson as output format
  but it seems that the request doesn't return anything. Can someone help me?
  
  

[Raul_Jimenez]

That's strange,

I just did it as you said (same as the Postman example) and it worked:

curl --location --request GET 'https://geocode-api.arcgis.com/arcgis/rest/services/World/GeocodeServer/findAddressCandidates?token=MY_API_KEY&f=pjson&singleLine=1600 Pennsylvania Ave NW, DC'

I got this same response.

but it seems that the request doesn't return anything. Can someone help me?

What do you mean by this? can you share the curl and screenshot? (blurring the API key)

[LeonardoRomanato]

Hi thanks for the answer.

req = new $.web.WebRequest($.net.http.GET, "f=pjson&singleLine=" + address +"&token="+access_token);
response = client.getResponse()');
response = client.request(req, dest).getResponse();
jresponse = JSON.parse(response.body.asString());

in the 4th row of code I parse the the string into json, but while I access to the response object the code crashes.

It seems like the response is an empty object, maybe because of the wrong request
 

[Raul_Jimenez]

Have you tried:

try{
   // ...
}catch(e){
   console.log("Error: ", e);
}

 It might be an HTML been responded by the API?

[LeonardoRomanato]

sadly the language is not javascript but XSJS (SAP Hana Javscript Language) so I can't print with console.log().

Anyway I have a function to write into a SQL table to log in wich point my code stop, that's why I know that's somethig wrong when I access to response object. 

For example the code crashes even in this snippet:

req = new $.web.WebRequest($.net.http.GET, "f=pjson&singleLine=" + address +"&token="+access_token);
response = client.getResponse()');
response = client.request(req, dest).getResponse();
printInLogDB(idStep,'X',response.body.asString());

[MathiasKemeter]

Since XSJS is a service itself, you can forward the error message as part of the service response and then analyze it in the debug console of your browser. Just checked one of my xsjs project and found this sample code.

function doGet() {  
    try{  
              $.response.contentType = "application/json";  
              $.response.setBody(JSON.stringify(getProperties()));  
    }  
    catch(err){  
              $.response.contentType = "text/plain";  
              $.response.setBody("Error while executing query: [" + err.message + "]");  
              $.response.returnCode = 200;  
    }  
} 

[John-Foster]

The basic operation appears to be correct. Using your exact parameters in a web browser you can see it works (you need to replace your token)

https://geocode-api.arcgis.com/arcgis/rest/services/World/GeocodeServer/findAddressCandidates?f=pjso...

Response:

{
 "spatialReference": {
  "wkid": 4326,
  "latestWkid": 4326
 },
 "candidates": [
  {
   "address": "1600 Pennsylvania Ave NW, Washington, District of Columbia, 20500",
   "location": {
    "x": -77.036546998208649,
    "y": 38.897675107651253
   },
   "score": 100,
   "attributes": {
    
   },
   "extent": {
    "xmin": -77.037546998208654,
    "ymin": 38.896675107651255,
    "xmax": -77.035546998208645,
    "ymax": 38.89867510765125
   }
  }
 ]
}  

1. verify your URL is correct?

2. verify you are URL encoding the address string?

3. verify your token is correct?

[John-Foster]

@LeonardoRomanato are you certain line 2 is correct?

response = client.getResponse()');
response = client.request(req, dest).getResponse();

[Raul_Jimenez]

As John highlighted, my two cents would go for the encoding of the address. You can avoid encoding it if you uses a POST request instead.

[Raul_Jimenez]

@LeonardoRomanato were you able to fix this?