Skip to main content
M
mfelton1-Visitor
1-Visitor
March 13, 2017
Question

Rest API XML producing empty infotable

  • March 13, 2017
  • 1 reply
  • 4017 views

Hi,

I am trying to execute this REST API call in a javascript service and produce an infotable based on the returned value.

here is the script code:

var params = {
  proxyScheme: undefined /* STRING */,
  headers: undefined /* JSON */,
  ignoreSSLErrors: undefined /* BOOLEAN */,
  useNTLM: undefined /* BOOLEAN */,
  workstation: undefined /* STRING */,
  useProxy: undefined /* BOOLEAN */,
  withCookies: undefined /* BOOLEAN */,
  proxyHost: undefined /* STRING */,
  url: "https://www.imonnit.com/xml/SensorList/bWF0dGhldy5mZWx0b246V2VsY29tZTI1OENhcHVsYSE=" /* STRING */,
  timeout: undefined /* NUMBER */,
  proxyPort: undefined /* INTEGER */,
  password: undefined /* STRING */,
  domain: undefined /* STRING */,
  username: undefined /* STRING */
};
var params = {
  xml: Resources["ContentLoaderFunctions"].GetXML(params) /* XML */
};
// result: INFOTABLE
var result = Resources["InfoTableFunctions"].FromXML(params);

this is the xml produces when the command is in a web browser (couldn't format this correctly so follow this link https://www.imonnit.com/xml/SensorList/bWF0dGhldy5mZWx0b246V2VsY29tZTI1OENhcHVsYSE= )

And this is the datashape of the infotable:

the output i get from this is just nothing as shown here:

Any help is appreciated,

P.S there is also an extension for communicating with monnit sensors however i get the same problem, an empty infotable.

Thanks

1 reply

P
posipova20-Turquoise
20-Turquoise
March 13, 2017

To convert an XML string into an InfoTable, it needs to adhere to a very specific format:

<fromXMLTest>

<DataShape>

<FieldDefinitions>

<FieldDefinition baseType="STRING" description="" name="c" ordinal="1"/>

<FieldDefinition baseType="STRING" description="" name="l" ordinal="3"/>

<FieldDefinition baseType="STRING" description="" name="r" ordinal="2"/>

</FieldDefinitions>

</DataShape>

<Rows>

<Row>

<r><![CDATA[data]]></r>

<c><![CDATA[silly]]></c>

<l><![CDATA[some]]></l>

</Row>

</Rows>

</fromXMLTest>


The example above includes a DataShape which you need to tailor to your own, and in the Rows section is some dummy data populating each field. You can have as many <Row> sections as desired, but the <DataShape> portion must be included for the parser to know where the row data should go. The outer tag can be named anything, but there must be an outer tag surrounding everything.

    P
    posipova20-Turquoise
    20-Turquoise
    March 13, 2017

    You may also use this article for reference and datashape manipulations https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS218242&lang=en_US

    M
    mfelton1-VisitorAuthor
    1-Visitor
    March 13, 2017

    Following the guide and from what you said i have ended up with this

    // GET XML
    var params = {
      proxyScheme: undefined /* STRING */,
      headers: undefined /* JSON */,
      ignoreSSLErrors: undefined /* BOOLEAN */,
      useNTLM: undefined /* BOOLEAN */,
      workstation: undefined /* STRING */,
      useProxy: undefined /* BOOLEAN */,
      withCookies: undefined /* BOOLEAN */,
      proxyHost: undefined /* STRING */,
      url: "https://www.imonnit.com/xml/SensorList/bWF0dGhldy5mZWx0b246V2VsY29tZTI1OENhcHVsYSE=" /* STRING */,
      timeout: undefined /* NUMBER */,
      proxyPort: undefined /* INTEGER */,
      password: undefined /* STRING */,
      domain: undefined /* STRING */,
      username: undefined /* STRING */
    };
    var XMLDocument =  Resources["ContentLoaderFunctions"].GetXML(params);
    //CREATE INFO TABLE FROM DATA SHAPE
    var params = {
      infoTableName : "InfoTable",
      dataShapeName : "SensorListTest"
    };
    // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(xmlParserTable)
    var infoTable = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);
    //PARSE XML PUT INTO INFO TABLE
    // iterate through xml and add to info table
    for each (var tag in XMLDocument.Result.APISensorList) {
        var newRow = Object();
        newRow.SensorID = tag.SensorID;
        newRow.MonnitApplicationID = tag.MonnitApplicationID;
        newRow.CSNetID = tag.CSNetID;
        newRow.SensorName = tag.SensorName;
        newRow.LastCommunicationDate = tag.LastCommunicationDate;
        newRow.NextCommunicationDate = tag.NextCommunicationDate;
        newRow.LastDataMessageMessageGUID = tag.LastDataMessageMessageGUID;
        newRow.PowerSourceID = tag.PowerSourceID;
        newRow.Status = tag.Status;
        newRow.CanUpdate = tag.CanUpdate;
        newRow.CurrentReading = tag.CurrentReading;
        newRow.BatteryLevel = tag.BatteryLevel;
        newRow.SignalStrength = tag.SignalStrength;
        newRow.AlertsActive = tag.AlertsActive;
        newRow.CheckDigit = tag.CheckDigit;
        newRow.AccountID = tag.AccountID;
        infoTable.AddRow(newRow);
    }
    // return info table
    var result = infoTable

    So this now ends in the following error, "Wrapped java.lang.Exception: Unable To Convert To Value Collection: Unable To Convert From org.mozilla.javascript.xmlimpl.XMLList to NUMBER Cause: Unable To Convert To Value Collection: Unable To Convert From org.mozilla.javascript.xmlimpl.XMLList to NUMBER"

    So i can see its trying to put each whole API sensor list of values into the SensorID, however i have no idea how to convert this to be able to access each XML list item.

    unfortunately there is no way for me to change the source XML coming in.

    Thanks

    Terms & ConditionsCookie settingsAccessibility statement