SmartConnect 2018
Run Map Data Table
Runs the specified map using the data provided in the data table xml and returns the results.
Service uri:
To call the get map list method make a call to SmartConnect.svc/runmapdatatable/{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
Service security:
The settings used to determine WCF REST security and log settings is Run Map With Data Table
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. |
• | Add request.Accept = "application/json" to receive JSON back from the service instead of xml. |
• | This method requires the data passed to the service to be a DataTable in either xml or JSON format |
Return type:
The return type of this method is RunMapResponse
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/runmapdatatable/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/runmapdatatable/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>