Question Re: Transaction Execution from URL in Product Lifecycle Management Q&A

Transaction Execution from URL

Former Member — Thu, 10 Apr 2014 00:10:46 GMT

Hi Experts,

Need Your help to know how i can get the transaction output in Plain Text form using the URL.

Currently I am trying the following URL :

http://<server>/XMII/Runner?Transaction=Default/TDLF/TestTrxforYUI&Server=XacuteConnector&Mode=Query&OutputParameter=Text&type=text

Output :

<?xml version="1.0" encoding="UTF-8" ?>

- <Rowsets DateCreated="2014-04-09T23:41:19" EndDate="2014-04-09T23:41:19" StartDate="2014-04-09T23:41:19" Version="14.0.0 Build(802)" TransactionID="-1">

</Columns>

<Row>

<Text>HelloWorld</Text>

</Row>

</Rowset>

</Rowsets>

But i need the output in plain text format as

HelloWorld

Thanks

Shashank

Re: Transaction Execution from URL

Former Member — Thu, 10 Apr 2014 03:53:24 GMT

Hi Shashank,

Just mention Content-Type=text instead type in your URL as below ,it works

http://<server>/XMII/Runner?Transaction=Default/TDLF/TestTrxforYUI&Server=XacuteConnector&Mode=Query&OutputParameter=Text&Content-Type=text

Cheers,

Padma Rao

Re: Transaction Execution from URL

Former Member — Thu, 10 Apr 2014 05:56:58 GMT

Hi Shashank,

1. If you just want to get the output xml as string, then append 'content-type=text/plain' at the end of your runner URL.

2. But if you are looking to get the value of your output parameter 'Text' as string, then you need to parse through the xml and get the string value.

MII transaction gives output as xml in the Rowsets-->Rowset-->Row format and never a singular string.

Parsing through an xml can be a bit tedious, hence a better way to do it is, that you get the output of your transaction using Xacute query as JSON and get your string value by simple parsing of JSON as Rowsets.Rowset[0].Row[0].Text

http://<host>:<port>/XMII/Illuminator?QueryTemplate=<Xacute query path>&content-type=text/json

Regards,

Rutika Bodas

Re: Transaction Execution from URL

saumya_govil — Thu, 10 Apr 2014 14:44:10 GMT

Hi Shashank,

If the output of the transaction call is an XML and you need to parse the data out of it then the content-type should remain as 'text/xml'. You can parse the XML using the parse function below. I found this on searching the web but unfortunately don't remember the source.

	var parseXml;
	var groups = [];
	var recordlist = "";

	if (typeof window.DOMParser != "undefined") {
		parseXml = function(xmlStr) {
		return ( new window.DOMParser() ).parseFromString(xmlStr, "text/xml");
	};
	} else if (typeof window.ActiveXObject != "undefined" &&
	new window.ActiveXObject("Microsoft.XMLDOM")) {
	parseXml = function(xmlStr) {
	var xmlDoc = new window.ActiveXObject("Microsoft.XMLDOM");
	xmlDoc.async = "false";
	xmlDoc.loadXML(xmlStr);
	return xmlDoc;
	};
	} else {
	throw new Error("No XML parser found");
	} You can call it like parseXML(<data_received>) Hope this helps! Regards, Saumya Govil