topic Re: How to query a non-ArcGIS database from WAB? in ArcGIS Web AppBuilder Questions

How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Thu, 12 Jan 2017 22:35:48 GMT

Hi,

I need to send information from my WAB app to a non-ArcGIS database, run a query and return the results back to my app. From what I see online, using only JavaScript is not a secure idea. It looks like I need an intermediary, which my employer would like to be Visual Basic. If someone has successfully done this, please let me know how I might go about it. Any help is appreciated. Thank you for your time.

William

Re: How to query a non-ArcGIS database from WAB?

RobertScheitlin__GISP — Fri, 13 Jan 2017 01:10:50 GMT

William,

JS does not have any database access ability like native languages do so you would have to use a web service to query and return json or xml to the JS client. I do this for several of my sites but I am an experinced .Net and JS developer. You can search the web for VB.net RESTfull web service examples as a starting point (the majority you will find will be for C# though).

Re: How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Thu, 26 Jan 2017 15:37:27 GMT

Hi Robert,

I have a very basic web service. How do I send the search criteria collected from a widget with JavaScript to that web service?

William

Re: How to query a non-ArcGIS database from WAB?

RobertScheitlin__GISP — Sat, 11 Dec 2021 13:44:23 GMT

William,

With some code like this:

        var requestHandle = esriRequest({
          url: 'your rest service url',
          content: {
            ppin: ppin,
            f: 'json'
          },
          handleAs: "json",
          timeout: 10000
        },{useProxy: true, usePost: false, disableIdentityLookup: true});‍‍‍‍‍‍‍‍‍

Re: How to query a non-ArcGIS database from WAB?

Drew — Thu, 26 Jan 2017 16:16:22 GMT

William,
I would look into the WebAPI by Microsoft to create your Web Service. It's RESTful and easy. Check out YouTube for some tutorials.

WebAPI
ASP.NET Web API | The ASP.NET Site

Another idea is to just add your standalone table into a map service. Not all data in an MXD has to be Spatial. You can query tables too.

Drew

Re: How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Sat, 11 Dec 2021 13:44:26 GMT

Hi Robert,

I have a couple questions.

If I use XML instead of JSON, is the following format correct?

var requestHandle = esriRequest({
  url: 'your rest service url',
  content: {
    xmlContent: xmlContent
  },
  handleAs: "xml",
  timeout: 10000
},{useProxy: true, usePost: false, disableIdentityLookup: true});
requestHandle.then(requestSucceeded, requestFailed);‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

If I'm running Web AppBuilder on my desktop, can I still test this functionality?

Thank you for your help.

William

Re: How to query a non-ArcGIS database from WAB?

RobertScheitlin__GISP — Mon, 06 Feb 2017 21:08:21 GMT

William,

Assuming that your web service has one input parameter and it is called "xmlContent" then yes. You should be able to put a console statement in the requestSuceeded function to show the results of the request. I not sure the reason you choose xml as the defacto standard now a days is json though.

Re: How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Mon, 06 Feb 2017 21:41:03 GMT

Hi Robert,

I've been having trouble creating a new web service, so I was trying the one that was used with flexviewer. That web service however is SOAP. I asked the guy who developed it what the input parameter name was and he said it wasn't named.

William

Re: How to query a non-ArcGIS database from WAB?

RobertScheitlin__GISP — Mon, 06 Feb 2017 21:43:20 GMT

William,

You will not be able to use a SOAP service, that is why I mention a RESTfull web service was needed.

Re: How to query a non-ArcGIS database from WAB?

Drew — Tue, 07 Feb 2017 00:01:44 GMT

As mentioned below, maybe you don't even need a service.
Can you add the 'non-ArcGIS database' as a table in the Map Document (mxd) and publish it?

Once in the service you can just query it like any ArcGIS service.

Re: How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Tue, 07 Feb 2017 13:25:44 GMT

Hi Drew,

The database I need to connect to has real estate information that is updated regularly. I don't know, but I would guess that adding a table would not work for this situation. Please correct me if I'm wrong. I don't know much about Map Documents.

William

Re: How to query a non-ArcGIS database from WAB?

Drew — Tue, 07 Feb 2017 13:57:48 GMT

You would have to know the database, table name and the credentials to connect to the database.

• Assuming it’s a SQL Server database, its just like connecting to SDE and adding data the same way.
• Add a database connection in ArcCatalog
• In ArcMap just use the add data button and browse to your table.
• Once added got to the table of contents and select the ‘List by Source’ icon to see the able listed.
• Publish to ArcGIS Server
o You might have to register the database with ArcGIS Server
• Navigate to the map services REST endpoint and look for your table.
• You now have a layer you can query using the JSAPI

Drew

Re: How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Tue, 07 Feb 2017 15:42:20 GMT

Hi Drew,

The database has been added to the ArcGIS Rest Services Directory. Do I use esri/Request to query it?

William

Re: How to query a non-ArcGIS database from WAB?

Drew — Tue, 07 Feb 2017 15:51:33 GMT

So you published a map service with the table in it?
You can test your data by clicking on the table in the REST endpoint and selecting the 'Query' operation link at the bottom of the page.
Just query where 1=1 and you should see some results.

In JavaScript you can just use the QueryTask to query the data.

QueryTask | API Reference | ArcGIS API for JavaScript 3.19

Drew

Re: How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Sat, 11 Dec 2021 13:44:29 GMT

Hi Drew,

Below is my code for the QueryTask.

var queryString = this._buildQueryString();
var query = new Query();
var queryTask = new QueryTask("URL_OF_ARCGIS_REST_SERVICE");
query.where = queryString;
query.outFields = ["ACCOUNT_NBR", "ADDRESS_LINE_1", "PROP_ZIP", "TOT_VAL", "LAND_VALUE", "BUILDING_VALUE", "SDWLL_NBR", "ROUTING_NBR", "LIVING_SPACE", "Sch_Dst_Dsc"];
queryTask.execute(query, lang.hitch(this, this._onSuccessfulQueryCompletion), lang.hitch(this, this._onFailedQueryCompletion));‍‍‍‍‍‍

When I run this code, the _onSuccessfulQueryCompletion executes.

_onSuccessfulQueryCompletion: function(results) {
      console.log('RatioQuery::_onSuccessfulQueryCompletion');
      
      new Message({
        titleLabel: "Ratio Query",
        message: "SUCCESS"
      });
      
      console.info(results);
    },‍‍‍‍‍‍‍‍‍‍

However, when I look at the data in the console, I don't see where any results are. Below is what displays in Chrome.

What am I doing wrong?

Thank you for all your help.

William

Re: How to query a non-ArcGIS database from WAB?

Drew — Tue, 07 Feb 2017 21:27:48 GMT

Your Close..

Point your "URL_OF_ARCGIS_REST_SERVICE" to the 'layer'

Sample

http://<MYDOMAIN>arcgis/rest/services/MyTableService/MapServer/1

Re: How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Thu, 09 Feb 2017 17:32:23 GMT

Hi Drew,

If you have a chance, I have a related question that I just posted as a separate thread.

https://community.esri.com/message/665313-how-to-connect-data-to-a-map

Thanks for all your help!

William

Re: How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Fri, 10 Feb 2017 17:02:16 GMT

Hi Robert,

Did you use WCF, MVC or something else to create your web services?

Thank you.

William

Re: How to query a non-ArcGIS database from WAB?

RobertScheitlin__GISP — Fri, 10 Feb 2017 17:06:41 GMT

Nope just a simple VB.net RESTful web service.

Re: How to query a non-ArcGIS database from WAB?

WilliamMiller4 — Fri, 10 Feb 2017 17:25:37 GMT

But you did use the .Net Web API, right?