Skip to main content

IoT & Connectivity

10000+ Topics
S
sniculescu12-Amethyst
 IoT & Connectivity Tips
Analytics Models Version Control

With the advent of faster and cheaper hardware, and owing to vast improvements in connectivity such as Gigabit networks and 5G, data is collected and processed at an ever increasing pace. As such, there is a related need for the Analytical Models built on top of such data to evolve over time. As part of this evolution, modelling experiments with more data, new variables, new techniques, and different training parameters will be performed. The resulting models need to be tracked, monitored, and appropriate versions need to be used for scoring in various scenarios. This creates the need for version control of Analytical Models.   ThingWorx Analytics makes it easy to implement an “Analytics Model Version Control” system via two mechanisms: A job Id and timestamp based identification system, so if a model with the same jobName (model name) is retrained, the old model will still exist and can be easily retrieved A tagging mechanism for the above jobs   Before using the above tec

16090
S
N
NBHD2071-Visitor
 ThingWorx Developers
I
ishas1-Visitor
 ThingWorx Developers
V
VaibhavShinde16-Pearl
 ThingWorx Developers
TWX: Sending email content as iterated infotable data in html table format

Hi , I am looking for sending Infotable data as body part of mail in html table format , but I am getting overwritten data while iterating. please see below code and screenshots too.   var result = me.getDataForWeek(); //infotable resultvar tableLength = result.rows.length; for (var x=0; x < tableLength; x++) {var row = result.rows[x];var rowvalue1= row.M_Key;var rowvalue2 = row.PowerFactor;var emailContent = "<html><body>\<table>\<tr><td>M_Key</td><td>Powerfactor</td></tr>\<tr><td>"+rowvalue1+"</td><td>"+rowvalue2+"</td></tr>\</table></body></html>"} Things["EMS_MailThing"].SendMessageWithAttachment({from: " xyz@gmail.com" /* STRING */,to: " abcd@gmail.com" /* STRING */,cc: undefined /* STRING */,bcc: undefined /* STRING */,subject:"Mail with table content" /* STRING */,//content : emailContent,body: emailContent /* HTML */,   infotable result: key location sou

26453
raluca_edu
K
krishnakomal12315-Moonstone
 ThingWorx Developers
A
anassNasser1-Visitor
 ThingWorx Developers
K
karthik241-Visitor
 ThingWorx Developers
M
Manav_Pampher10-Marble
 Kepware
L
Lakshmit1-Visitor
 ThingWorx Developers
J
jasperlg1-Visitor
 Mfg Solutions & Apps
Operator Advisor (8.4.2): Execution error in service script [GetWorkDefinitionExecutionLog]

Hi all,    We are using Operator Advisor fully implemented at a customer for over a half year now.  Yet, there is some error we encouter we do not fully comprehend.  Like the title says, the error goes like this:  Execution error in service script [GetWorkDefinitionExecutionLog] ....    It happens when we update a row in the database. I've looked at the service 'GetWorkDefinitionExecutionLog' and don't see anything why this error could occur. Now I know OA has some Java methods we can not access, and since the error says also 'Missed Context.JavaToJS() conversion', I assume it has something to do with the OA java services.    Do any of you guys know what this error is about and how we can avoid it? Whenever it occurs, it takes a few seconds to do the update the row in the DB.    Thanks for helping out.    Jasper    

25932
S
E
einsfeldleo1-Visitor
 Kepware
Ascherer17
Ascherer1716-Pearl
 ThingWorx Developers
Service REST Call Infotable Input Using XML

I cannot seem to figure out how to pass an infotable as an input to a Thingworx Service using a XML format REST call.  I am using Postman with an app key to call a Service on the platform using POST.  I am able to pass multiple other basetype inputs like strings, but the length of my infotable My question is How exactly must the infotable be formatted to properly be sent to Thingworx?  When I try to get the length of the Infotable, it always gives me 0 rows.     Here is an example REST call body that I have tried where the 'content-type' header is set to 'text/xml'.  The name of the service is 'TestXMLRest'.  There are 2 inputs: a string called 'StringInput' and a 2-row Infotable called 'MyInfoTableInput' using a datashape the contains 2 strings, 'Name' and 'PhoneNumber'.   <TestXMLRest> <StringInput>Just a string</StringInput> <MyInfoTableInput> <DataShape> <FieldDefinitions> <FieldDefinition

24311
R
B
bkulkarni1-Visitor
 ThingWorx Developers
S
Sri11-Visitor
 ThingWorx Developers
V
VaibhavShinde16-Pearl
 ThingWorx Developers
S
Sri11-Visitor
 ThingWorx Developers
P
Povilas1-Visitor
 ThingWorx Developers
G
gajapriya1-Visitor
 Kepware
E
einsfeldleo1-Visitor
 ThingWorx Developers
L
liwei5-Regular Member
 ThingWorx Developers
G
gourinaik981-Visitor
 ThingWorx Developers
S
steve23714-Alexandrite
 ThingWorx Developers
E
eyli14-Alexandrite
 ThingWorx Developers
S
sk361-Visitor
 ThingWorx Developers
Aggregate function on Infotable

I am trying to use aggregate function on a "result" infotable. The aggregate function is returning and info table "result1". The infotable result1 column names are  infoTable content: {AVERAGE_1667.0=null, AVERAGE_1667.0_COUNT=com.thingworx.types.primitives.NumberPrimitive@0, AVERAGE_1667.0_SUM=com.thingworx.types.primitives.NumberPrimitive@0}   Please find my code below.  How do I read the read the aggregated value(i.e Average values: 1667 this keeps changing every time I run this service)   // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(US_NRV_Env_Reporting_Average_Value)var result1 = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params1); var params = {t: result /* INFOTABLE */,columns: me.Data_Reading/* STRING */,aggregates: "AVERAGE" /* STRING */,groupByColumns: undefined /* STRING */}; // result: INFOTABLEresult1 = Resources["InfoTableFunctions"].Aggregate(params);      

21501
R
A
ankit31-Visitor
 ThingWorx Developers
Show more activity

Badge winners

Show all badges
Terms & ConditionsAccessibility statement