Fatima ELKADDOURI
Fatima ELKADDOURI

Reputation: 183

How can i display data from xml api in flutter?

I want to display the 'name' of groupes (groupID) into listView, the names of device that i want to display are (demo,4v,demo2,doker...) from DeviceGroup table, using XML webservice.i used the xmljson to convert it, plz Can someone correct my faults.

My Xml web service:

<GTSResponse command="dbget" result="success">
    <Record table="DeviceGroup">
        <Field name="accountID" primaryKey="true">
            <![CDATA[demo]]>
        </Field>
        <Field name="groupID" primaryKey="true">
            <![CDATA[demo]]>
        </Field>
        <Field name="PushpinsLimitGroup">0</Field>
        <Field name="ReportsLimitGroup">0</Field>
        <Field name="displayName"></Field>
        <Field name="description">
            <![CDATA[4 v]]>
        </Field>
        <Field name="notes"></Field>
        <Field name="lastUpdateTime">1529258380</Field>
        <Field name="creationTime">1498727371</Field>
        <Field name="workOrderID"></Field>
        <Field name="allowNotify">false</Field>
        <Field name="notifyEmail"></Field>
        <Field name="parentGroupID"></Field>
    </Record>
    <Record table="DeviceGroup">
        <Field name="accountID" primaryKey="true">
            <![CDATA[demo]]>
        </Field>
        <Field name="groupID" primaryKey="true">
            <![CDATA[demo2]]>
        </Field>
        <Field name="PushpinsLimitGroup">0</Field>
        <Field name="ReportsLimitGroup">0</Field>
        <Field name="displayName"></Field>
        <Field name="description"></Field>
        <Field name="notes"></Field>
        <Field name="lastUpdateTime">1555499492</Field>
        <Field name="creationTime">1555499492</Field>
        <Field name="workOrderID"></Field>
        <Field name="allowNotify">false</Field>
        <Field name="notifyEmail"></Field>
        <Field name="parentGroupID"></Field>
    </Record>
    <Record table="DeviceGroup">
        <Field name="accountID" primaryKey="true">
            <![CDATA[demo]]>
        </Field>
        <Field name="groupID" primaryKey="true">
            <![CDATA[doker]]>
        </Field>
        <Field name="PushpinsLimitGroup">0</Field>
        <Field name="ReportsLimitGroup">0</Field>
        <Field name="displayName"></Field>
        <Field name="description"></Field>
        <Field name="notes"></Field>
        <Field name="lastUpdateTime">1528138728</Field>
        <Field name="creationTime">1528138728</Field>
        <Field name="workOrderID"></Field>
        <Field name="allowNotify">false</Field>
        <Field name="notifyEmail"></Field>
        <Field name="parentGroupID"></Field>
    </Record>
    <Record table="DeviceGroup">
        <Field name="accountID" primaryKey="true">
            <![CDATA[demo]]>
        </Field>
        <Field name="groupID" primaryKey="true">
            <![CDATA[glowex]]>
        </Field>
        <Field name="PushpinsLimitGroup">0</Field>
        <Field name="ReportsLimitGroup">0</Field>
        <Field name="displayName"></Field>
        <Field name="description"></Field>
        <Field name="notes"></Field>
        <Field name="lastUpdateTime">1604598739</Field>
        <Field name="creationTime">1604598739</Field>
        <Field name="workOrderID"></Field>
        <Field name="allowNotify">false</Field>
        <Field name="notifyEmail"></Field>
        <Field name="parentGroupID"></Field>
    </Record>
    <Record table="DeviceGroup">
        <Field name="accountID" primaryKey="true">
            <![CDATA[demo]]>
        </Field>
        <Field name="groupID" primaryKey="true">
            <![CDATA[inter]]>
        </Field>
        <Field name="PushpinsLimitGroup">0</Field>
        <Field name="ReportsLimitGroup">0</Field>
        <Field name="displayName"></Field>
        <Field name="description"></Field>
        <Field name="notes"></Field>
        <Field name="lastUpdateTime">1579869475</Field>
        <Field name="creationTime">1579869475</Field>
        <Field name="workOrderID"></Field>
        <Field name="allowNotify">false</Field>
        <Field name="notifyEmail"></Field>
        <Field name="parentGroupID"></Field>
    </Record>
    <Record table="DeviceGroup">
        <Field name="accountID" primaryKey="true">
            <![CDATA[demo]]>
        </Field>
        <Field name="groupID" primaryKey="true">
            <![CDATA[supporttest]]>
        </Field>
        <Field name="PushpinsLimitGroup">0</Field>
        <Field name="ReportsLimitGroup">0</Field>
        <Field name="displayName"></Field>
        <Field name="description"></Field>
        <Field name="notes"></Field>
        <Field name="lastUpdateTime">1599144965</Field>
        <Field name="creationTime">1599144965</Field>
        <Field name="workOrderID"></Field>
        <Field name="allowNotify">false</Field>
        <Field name="notifyEmail"></Field>
        <Field name="parentGroupID"></Field>
    </Record>
</GTSResponse>

Function to get data from web service

getDataGroupe() async {
    String message = "<GTSRequest command='dbget'><Authorization account='demo' user='xxxxxx' password='xxxxxxx'/><Record table='DeviceGroup' partial='true'><Field name='accountID'>demo</Field></Record></GTSRequest>";
    print("message: $message");

    String url = "http://xxxxxxxxxxxx";

    final http.Response response =
    await http.post(Uri.parse(url), body: message, headers: {
      'Content-type': 'text/xml',
    });

    Provider.of<APIProvider>(context, listen: false).setAccount(account);
    Provider.of<APIProvider>(context, listen: false).setUser(user);
    Provider.of<APIProvider>(context, listen: false).setPassword(password);

    if (response.statusCode == 200) {
      print(response.body);

      final Xml2Json xml2Json = Xml2Json();
      xml2Json.parse(response.body);
      var jsonString = xml2Json.toParker();
      print(jsonString);

      var  data= jsonDecode(jsonString);
       list = data['GTSResponse']['Record']['Field'];
      for(var item in list){
        print(item);
      }
    }
  }

listview

@override
  Widget build(BuildContext context) {
  
    return Scaffold(

      body:  new Expanded(
        child: ListView.builder(
          itemCount: list == null ? 0 : list.length,
          itemBuilder: (BuildContext context, int index) {
            return new ListTile(
              title: new Card(
                elevation: 5.0,
                child: new Container(
                  alignment: Alignment.centerLeft,
                  margin: new EdgeInsets.only(
                      top: 10.0, bottom: 10.0, left: 15),
                  child: new Text(
                     null  //data['GTSResponse']['Record'],
                  ),
                ),
              ),
            );
          },
        ),
      ),
    );
  }
}

the result in the console

i think this path of deviceID name that i used list = data['GTSResponse']['Record']['Field']; not correct enter image description here

the result after convert xml data to json, me i want to display the second element after "Field" (demo,demo2, doker,glowex,inter, and suportest)

{"GTSResponse": {"Record": [{"Field": ["demo", "demo", {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}]}, {"Field": ["demo", "demo2", {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}]}, {"Field": ["demo", "doker", {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}]}, {"Field": ["demo", "glowex", {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}]}, {"Field": ["demo", "inter", {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}]}, {"Field": ["demo", "supporttest", {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}]}]}}

Upvotes: 0

Views: 873

Answers (1)

Afridi Kayal
Afridi Kayal

Reputation: 2285

The Error is that data['GTSResponse']['Record'] is a list itself and you are trying to provide a string as the index to access.

It should be like

data['GTSResponse']['Record'][0]['Field'][1];

to access the 2nd field (index 1) of first record,

data['GTSResponse']['Record'][1]['Field'][1];

for the second record and so on.


Try this:

var recordList = List.of(data['GTSResponse']['Record']); // Get the records
var requiredList = recordList.map<String>((record) => record['Field'][1]).toList(); // Generate the list of 2nd elements (index 1) of field of every record.

print(requiredList);

// Output: [demo, demo2, doker, glowex, inter, supporttest]

Upvotes: 1

Related Questions