SmartConnect 2018

XML Output Run Map Data Table

Runs the specified map using the DataTable xml provided and returns the xml output and run results from the map.

 

Service uri:

To call the get map list method make a call to SmartConnect.svc/getmapxml/datatable/{mapId}

 

Service web.config flag:

The flag used to turn this service call on or off in the WCF REST service web.config file is AllowRunMapDataTable

SmartConnect_WCF_RunMapDataTableConfig

 

Service security:

The settings used to determine WCF REST security and log settings is Run Map With Data Table

SmartConnect_WCF_RunMapDataTable

 

Implementation details:

While the credentials of the user configured to run the SmartConnect WCF REST service are used to run the map, the credentials provided with the service call are used to determine access to the map.

This method may only be called on a map that has a destination that allows output to xml.

 

Return type:

The return type of this method is RunMapXmlResponse

 

Sample usage:

VB.NET

' runs a map with an id of TEST

Dim request As System.Net.WebRequest = System.Net.WebRequest.Create("webservice.eonesolutions.com/SmartConnect.svc/getmapxml/datatable/TEST")

request.Credentials = New System.Net.NetworkCredential("username", "password", "domain")

request.Method = "POST"

Using writer As New StringWriter()

 dataTable.DataSet.WriteXml(writer, XmlWriteMode.WriteSchema)

End Using

Dim xml As String = writer.ToString()

request.ContentLength = xml.Length

request.ContentType = "text/xml"

Using reqStream As Stream = request.GetRequestStream()

 reqStream.Write(Encoding.ASCII.GetBytes(xml), 0, xml.Length)

End Using

Dim response As System.Net.WebResponse = request.GetResponse()

Dim result As String = String.Empty

Using responseStream As New System.IO.StreamReader(response.GetResponseStream())

 Dim result As String = responseStream.ReadToEnd()

End Using

Dim doc As New XmlDocument()

doc.LoadXml(result)

Return doc

 

C#.NET

// runs a map with an id of GP_ACC

System.Net.WebRequest request  = System.Net.WebRequest.Create("webservice.eonesolutions.com/SmartConnect.svc/getmapxml/datatable/GP_ACC");

request.Credentials = new System.Net.NetworkCredential("username","password","domain");

request.Method = "POST";

using(StringWriter writer = new StringWriter())

{

 dataTable.DataSet.WriteXml(writer,XmlWriteMode.WriteSchema);

}

string xml = writer.ToString();

request.ContentLength = xml.Length;

request.ContentType = "text/xml";

using(Stream reqStream = request.GetRequestStream())

{

 reqStream.Write(Encoding.ASCII.GetBytes(xml),0,xml.Length);

}

System.Net.WebResponse response = request.GetResponse();

string result = string.Empty;

using(System.IO.StreamReader responseStream = new System.IO.StreamReader(response.GetResponseStream()))

{

 string result = responseStream.ReadToEnd(); 
}

XmlDocument doc = new XmlDocument();

doc.LoadXml(result);

return doc;

 

Sample DataTable xml

<NewDataSet> 

  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> 

    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> 

      <xs:complexType> 

        <xs:choice minOccurs="0" maxOccurs="unbounded"> 

          <xs:element name="Table"> 

            <xs:complexType> 

              <xs:sequence> 

                <xs:element name="CustomerName" type="xs:string" minOccurs="0" /> 

                <xs:element name="CustomerID" type="xs:string" minOccurs="0" /> 

                <xs:element name="PhoneNumber" type="xs:string" minOccurs="0" /> 

                <xs:element name="Contact" type="xs:string" minOccurs="0" /> 

              </xs:sequence> 

            </xs:complexType> 

          </xs:element> 

        </xs:choice> 

      </xs:complexType> 

    </xs:element> 

  </xs:schema> 

  <Table> 

    <CustomerName>Name</CustomerName> 

    <CustomerID>ID</CustomerID> 

    <PhoneNumber>Phone</PhoneNumber> 

    <Contact>Contact</Contact> 

  </Table> 

</NewDataSet>