topic Re: populate a datagrid from a HTTPservice in ArcGIS API for Flex Questions

populate a datagrid from a HTTPservice

RichardKrell — Mon, 30 Aug 2010 18:18:51 GMT

I am using code provided from the Code Gallery http://resources.esri.com/arcgisserver/apis/flex/index.cfm?fa=codeGalleryDetails&scriptID=15872 to try and populate a datagrid with data obtained in a HTTPservice. The webservice was written by me and works fine. I have used it in other applications. the code I am using on the HTTPserice is as follows:

<mx:HTTPService id="hsID"
url="http://data.cmap.illinois.gov/ws/tip/tipservice.asmx/getproject"
showBusyCursor="true"
requestTimeout="120"
useProxy="false"/>

I know I need to take the results and create a ArrayCollection but I am having problems figuring out the correct code so it will iterate through the selected points and return the data to the datagrid.
Any assistance would be greatly appriciated.

Thanks
Richard Krell
Chicago Metropolitan Agency for Planning

Re: populate a datagrid from a HTTPservice

DasaPaddock — Mon, 30 Aug 2010 19:03:09 GMT

You may want to try using Flash Builder's Data -> Connect to HTTP... menu option. This wizard will generate code that you can use to call your service.

Re: populate a datagrid from a HTTPservice

RobertScheitlin__GISP — Sat, 11 Dec 2021 07:12:30 GMT

Richard,

If you what to know how to do it without using adobes autogenerated code than all you have to do is this

private function getproject_result(evt:ResultEvent):void {
       var pRslt:Object = evt.result;
}

<mx:WebService id="webService" wsdl="http://data.cmap.illinois.gov/ws/tip/tipservice.asmx?wsdl" showBusyCursor="true">
        <mx:operation name="getproject"
                resultFormat="object"
                fault="getproject_fault(event);"
                result="getproject_result(event);">
                <mx:request><projectid>{sProjectId}</projectid></mx:request>
        </mx:operation>
    </mx:WebService>

Re: populate a datagrid from a HTTPservice

RichardKrell — Mon, 30 Aug 2010 19:25:37 GMT

I appriciate everyone's response and I guess I haven't explained myself. The progblem is not the service call. As I said that is working fine. Where I am having problems is creating an ArrayCollection that will populate my grid with all the records that have been selected.

thanks
Richard Krell
Chicago Metropolitian Agency for Planning.

Re: populate a datagrid from a HTTPservice

RichardKrell — Mon, 30 Aug 2010 19:28:32 GMT

A little more info.

Here is what I am working with right now trying to get it working.

function onXMLResult(event:ResultEvent, featureSet:FeatureSet, token:Object = null😞void{
for(var i:uint = 0; i < featureSet.features.length; i++){
xml = event.result.ArrayOfTipproject.tipproject;
}
dgrid1.dataProvider = xml;

}

Needless to say, it is not working but I have just written it and am working through the errors.

Re: populate a datagrid from a HTTPservice

ReneRubalcava — Sat, 11 Dec 2021 07:12:33 GMT

Try this
You can go XML -> Array or ArrayCollection
Don't forget to set your result format.
service.resultFormat = "e4x";

var xml:XML = event.result as XML;
var items:Array = [];
for each (var queryXML:XML in xml.tipProject) {
 var obj:Object = {
 project:queryXML.@project,
 agency:queryXML.@agency // and so on adding the fields you want
 }
 items.push(obj);
}

You can also turn it into an XMLListCollection
var xmlListCollection:XMLListCollection = new XMLListCollection();
xmlListCollection.source = new XMLList( event.result );

You can then treat the XMLListCollection like an ArrayCollection

When dealing with an HTTPService, your results are easy to parse in XML, I never used ArrayCollection with an HTTPService result, but I think the event.result object is xml by default.

Re: populate a datagrid from a HTTPservice

RichardKrell — Sat, 11 Dec 2021 07:12:35 GMT

I started this thread the other day in an attempt to resolve a coding problem I am having and received some really good answers. But after being deverted for a day on another project I am back and hate to keep being such a bother but I am truely over my perverbial head. Below is the funtion I am trying to get working but I keep getting an error 1034 telling me I cannot covert a featureset into an resultevent. I believe I understand the error but don't understand where it is coming from.


//*************************************************************************
public function runQueryTask(geometry:Geometry):void {

 
//*************************************************************************
[INDENT]

var queryTask:QueryTask = new QueryTask();


 

queryTask.url = "http://data.cmap.illinois.gov/ArcGIS/rest/services/Maps/TIP_Test/MapServer/0";

 
 
 
[LEFT]var query:Query = new Query();

query.geometry = geometry;
[LEFT]query.returnGeometry = true;
query.spatialRelationship = "esriSpatialRelContains";
query.outFields = ['PROID','PROGRAMMIN','COMPLETION'];[/LEFT]
[/LEFT]

 
 
 
 

queryTask.execute(query, new AsyncResponder(onXMLResult, onFault));

 
 
 

function onXMLResult(event:ResultEvent, token:Object=null):void{

 
 
[INDENT]

//xml = event.result.ArrayOfTipproject.tipproject;


 
[LEFT]var xmlListCollection:XMLListCollection = new XMLListCollection;

xmlListCollection.source = new XMLList(event.result.ArrayOfTipproject.tipproject);
[LEFT]var items:Array = [];
foreach(var queryXML:XML in xmlListCollection){[/LEFT]
[/LEFT]

 
 
 
[INDENT]

var obj:Object = {


 

project:queryXML.@PROID,

agency:queryXML.@PROGRAMMIN


 
 
 
 
[/INDENT]}
 
[/INDENT]}

items.push(obj);

 
[/INDENT]}

Re: populate a datagrid from a HTTPservice

RobertScheitlin__GISP — Wed, 01 Sep 2010 15:12:10 GMT

Richard,

Just change your onXMLResult to

function onXMLResult(featureSet:FeatureSet, token:Object = null):void

Re: populate a datagrid from a HTTPservice

RichardKrell — Wed, 01 Sep 2010 15:29:06 GMT

I am trying to retrieve the information from a SQL database via a HTTPservice not through the featureset.

Re: populate a datagrid from a HTTPservice

RobertScheitlin__GISP — Sat, 11 Dec 2021 07:12:38 GMT

Richard,

You definently have me confused then as your code snippet above had

var queryTask:QueryTask = new QueryTask();

 
queryTask.url = "http://data.cmap.illinois.gov/ArcGIS/rest/services/Maps/TIP_Test/MapServer/0";

So are you talking about querying a map service layer using the query task or a web service like you began this thread with???

Re: populate a datagrid from a HTTPservice

RichardKrell — Wed, 01 Sep 2010 18:45:42 GMT

Robert,
To be honest I am getting confused and that is probably my biggest problem. I took some code as I mentioned in the beginning that was using the querytask and now I am trying to re-write it to use HTTPservice.

I have always had problems with this and I don't know why. I have done apps in VB, Avenue, and many others for years but this Flex for some reason has me tearing my hair out.

So yes I am trying to use HTTPservice to retrieve these records. I know the webservice is OK because I have been using it. You can try it if you want and just enter a ID 01-06-0068. I will return one record.

Re: populate a datagrid from a HTTPservice

ReneRubalcava — Sat, 11 Dec 2021 07:12:40 GMT

Ok, sorry. I got confused reading your earlier posts. Looking at what you have, you actually want to use a WebService, not an HTTPService. You'd use a WebService to send requests to a function and get results. An HTTPService would be used to load something like an XML or Text file.

Here is an example of using a WebService with your service. Don't worry about converting to XML unless that's your thing.

<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
      xmlns:s="library://ns.adobe.com/flex/spark"
      xmlns:mx="library://ns.adobe.com/flex/mx"
      minWidth="955"
      minHeight="600"
      applicationComplete="init()">

 <fx:Declarations>
  <!-- Place non-visual elements (e.g., services, value objects) here -->
 </fx:Declarations>
 <fx:Script>
  <![CDATA[
   import mx.collections.ArrayCollection;
   import mx.controls.Alert;
   import mx.rpc.events.FaultEvent;
   import mx.rpc.events.ResultEvent;
   import mx.rpc.soap.mxml.WebService;
   
   protected var service:WebService;
   
   protected function init():void {
    service = new WebService();
    service.showBusyCursor = true;
    service.wsdl = "http://data.cmap.illinois.gov/ws/tip/tipservice.asmx?wsdl";
    service.addEventListener(ResultEvent.RESULT, onResultsLoaded_handler);
    service.addEventListener(FaultEvent.FAULT, onFault_handler);
    service.loadWSDL();
   }
   
   protected function onFault_handler(event:FaultEvent):void {
    Alert.show("Error in calling service: " + event.message, "Error");
   }
   
   protected function onResultsLoaded_handler(event:ResultEvent):void {
    try {
     dgResults.dataProvider = event.result as ArrayCollection;
    }
    catch (e:Error) {
     Alert.show("An error occurred loading results: " + e.message, "Results error");
    }
   }
   
   
   protected function btnRequest_clickHandler(event:MouseEvent):void {
    
    service.getproject(input.text);
   }
  ]]>
 </fx:Script>
 <s:layout>
  <s:VerticalLayout gap="5"
        horizontalAlign="center"
        paddingTop="25" />
 </s:layout>
 <s:TextInput id="input"
     width="200" />
 <s:Button id="btnRequest"
     label="Send Request"
     width="200"
     click="btnRequest_clickHandler(event)" />
 <mx:DataGrid id="dgResults"
     width="800"
     height="300" />
</s:Application>

Now as far as how this relates to the example you linked in your first post, the above will get you the ArrayCollection of results you were looking for in your first post. Now you can use those results to create a "where" query on your map service.

Re: populate a datagrid from a HTTPservice

RichardKrell — Thu, 02 Sep 2010 14:03:40 GMT

Thanks for the latest response and believe me I will look at it. I spent last evening working on this and I came up with something different.

I am also attaching the file and the actionscript class file. Again, unfortunetly these are examples I found as I was researching this. I know it is probably that I have been working on this for so long that it has become so hard but I really do appriciate everyone's help.

Re: populate a datagrid from a HTTPservice

RichardKrell — Sat, 11 Dec 2021 07:12:44 GMT

Is this code written in Flash 4 or Flex 3.6 because although we are due for upgrading we are still working in 3.6?

<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
               xmlns:s="library://ns.adobe.com/flex/spark"
               xmlns:mx="library://ns.adobe.com/flex/mx"
               minWidth="955"
               minHeight="600"
               applicationComplete="init()">
 
    <fx:Declarations>
        <!-- Place non-visual elements (e.g., services, value objects) here -->
    </fx:Declarations>
    <fx:Script>
        <![CDATA[
            import mx.collections.ArrayCollection;
            import mx.controls.Alert;
            import mx.rpc.events.FaultEvent;
            import mx.rpc.events.ResultEvent;
            import mx.rpc.soap.mxml.WebService;
 
            protected var service:WebService;
 
            protected function init():void {
                service = new WebService();
                service.showBusyCursor = true;
                service.wsdl = "http://data.cmap.illinois.gov/ws/tip/tipservice.asmx?wsdl";
                service.addEventListener(ResultEvent.RESULT, onResultsLoaded_handler);
                service.addEventListener(FaultEvent.FAULT, onFault_handler);
                service.loadWSDL();
            }
 
            protected function onFault_handler(event:FaultEvent):void {
                Alert.show("Error in calling service: " + event.message, "Error");
            }
 
            protected function onResultsLoaded_handler(event:ResultEvent):void {
                try {
                    dgResults.dataProvider = event.result as ArrayCollection;
                }
                catch (e:Error) {
                    Alert.show("An error occurred loading results: " + e.message, "Results error");
                }
            }
 
 
            protected function btnRequest_clickHandler(event:MouseEvent):void {
 
                service.getproject(input.text);
            }
        ]]>
    </fx:Script>
    <s:layout>
        <s:VerticalLayout gap="5"
                          horizontalAlign="center"
                          paddingTop="25" />
    </s:layout>
    <s:TextInput id="input"
                 width="200" />
    <s:Button id="btnRequest"
              label="Send Request"
              width="200"
              click="btnRequest_clickHandler(event)" />
    <mx:DataGrid id="dgResults"
                 width="800"
                 height="300" />
</s:Application>

Re: populate a datagrid from a HTTPservice

RobertScheitlin__GISP — Sat, 11 Dec 2021 07:12:47 GMT

Richard,

Here is Rene's code downgraded for Flex Builder 3

The real question is are you part of the domains that has access to this web service look at the http://data.cmap.illinois.gov/crossdomain.xml
is your machine part of one of these?

<allow-http-request-headers-from domain="*.pathfinder-development.com" headers="*"/>
<allow-http-request-headers-from domain="*.greatarc.com" headers="*"/>
<allow-http-request-headers-from domain="208.70.17.37" headers="*"/>
<allow-http-request-headers-from domain="localhost" headers="*"/>

If so then Rene's code should work.

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" 
 layout="vertical" creationComplete="init()">
 <mx:Script>
  <![CDATA[
   import mx.collections.ArrayCollection;
   import mx.controls.Alert;
   import mx.rpc.events.FaultEvent;
   import mx.rpc.events.ResultEvent;
   import mx.rpc.soap.mxml.WebService;
   
   protected var service:WebService;
   
   protected function init():void {
    service = new WebService();
    service.showBusyCursor = true;
    service.wsdl = "http://data.cmap.illinois.gov/ws/tip/tipservice.asmx?wsdl";
    service.addEventListener(ResultEvent.RESULT, onResultsLoaded_handler);
    service.addEventListener(FaultEvent.FAULT, onFault_handler);
    service.loadWSDL();
   }
   
   protected function onFault_handler(event:FaultEvent):void {
    Alert.show("Error in calling service: " + event.message, "Error");
   }
   
   protected function onResultsLoaded_handler(event:ResultEvent):void {
    try {
     dgResults.dataProvider = event.result as ArrayCollection;
    }
    catch (e:Error) {
     Alert.show("An error occurred loading results: " + e.message, "Results error");
    }
   }
   
   
   protected function btnRequest_clickHandler(event:MouseEvent):void {
    
    service.getproject(input.text);
   }
  ]]>
 </mx:Script>

 <mx:TextInput id="input"
     width="200" />
 <mx:Button id="btnRequest"
     label="Send Request"
     width="200"
     click="btnRequest_clickHandler(event)" />
 <mx:DataGrid id="dgResults"
     width="800"
     height="300" />
</mx:Application>

Re: populate a datagrid from a HTTPservice

RichardKrell — Thu, 02 Sep 2010 15:47:29 GMT

Thaks Robert,
I was just in the process of re-writing the code into 3. Yes, I am part of the crossdomain.

Re: populate a datagrid from a HTTPservice

RobertScheitlin__GISP — Thu, 02 Sep 2010 15:53:37 GMT

Richard,

Good, as I am not in that list I can not test to see if it works but everything in the code looks good so give it a test.