ThingWorx

I am calling rest api(thingworx url) from java eclipse but throwing error in java.Below is my code String b64 = Base64.getEncoder().encodeToString(bytes);//Construct jsoninput body//JSONObject params=new JSONObject(); params.put("path","/Motivation.pdf");params.put("content", b64); //Load pdf to Thingworx repository//String url = "HiddenServerurlforsafetypurpose/Thingworx/Things/komal_FileRepo/Services/SaveBinary"; URL obj = new URL(url); HttpURLConnection con = (HttpURLConnection) obj.openConnection(); //add request header con.setRequestMethod("POST"); con.setRequestProperty("Accept", "application/json"); con.setRequestProperty("Content-Type", "application/json"); con.setRequestProperty("appKey", "removedforsafetypurpose"); con.setRequestProperty("Body", params.toJSONString()); // Send post request con.setDoOutput(true); DataOutputStream wr = new DataOutputStream(con.getOutputStream()); wr.flush(); wr.close();&

In Thingworx 9.4, the localization of some texts in the Chip Based Data Filter in Toolbar Widget does not work. For example, the text of the buttons of the filter (Image 1) are not translated as well as conditions used to query the data(Image 2). Moreover, it is not possible to set the localization manually in the properties. Does anyone know about a possible solution?Image 1image 2  

I cannot change the value of INFOTABLE during the Advance Grid feature of Thingworx 9.2.0. The operation as follows;1 create  a DataShape for INFOTABLE.2 create a ThingShape includes INFOTABLE  properties defined by the created DataShape.3 Create Thing and set default values in INFOTABLE properties.4 Create a Mashup with Advance Grid Widget as follows.  (1) Bind INFOTABLE to Data of Advance Grid Wiget by getProperties service. (2) set all columns to be editable on the setting grid column of Advance Grid Widget context menu. (3) check EnableEditButtons in Property tab of Advance Grid Widget,5 show created widjet.6 click the edit button.7 change values of cells.8 click the save button.9 Chaned values are displyed on the grid, at this point, looks so good!10  click edit button again.11  cells are not changed.(same as default values)Please show me something wrong.Regards,  

Hi, I have a collections of infotable as shown below. Each table has different column structure and no tables are same. Now I need to iterate through each infotable and export the data as a excel report.using the snippet.let params = {infotable: undefined /* INFOTABLE */};// result: STRINGlet result = Resources["InfotableExporterFunctions"].ExportInfotableAsExcel(params);Kindly assist 

I have 3 infotables. How to export one excel sheet which having 3 sub sheets to add each infotable data in each sheet of excel. (or)How to export all 3 infotables in same file by differentiating each infotable separtely. Note: There is no common column present in all the 3 infotables.

Hi,I'm new in Thingwvorx and java script.I'm trying to take a single text file and split it into chunks by a specified chunk size. In my example, trying to split a single file into 1MB chunks.Example;source file will be available in the Repository.File test.txt in repository is 5MB.chunk size mentioned is 1MBProgram need to split and create five new files in repository with each file have 1MB size.Please help me to achieve this.

How to make numeric entry widget non-editable?

I added wrong additional data to my data, and retrain it. How to delete the additional data without deleting whole data?   

In ThingWorx v 9.3.9-b1648, developed a mashup with a bar chart widget to show the data and on-click of a single bar, it should pass the data the Navigation function of popup type. I believe there is a bug with Bar chart widget.  However the bar chart widget doesn't seem to send the selected bar data as a mashup parameter to the Popup function. I've set the 'selectedMode' property to single, also tried with default and multiple modes. Whereas when using the Grid widget, the data is getting passed to the popup function as a mashup parameter.  I've followed the below steps: Create a popup mashup and add mashup parameters to it, for binding it in base mashup.Create a base mashup, add bar chart widget and configure the widget properties accordinglyAdd data to the bar chart widget. Use a service that returns infotable type result, and the service will have "All data" and "selected row(s)" values. In the Base mashup, Add Navigation function with Popup

I have a gauge that I need to change the color of something based on if the value in the gauge is above or below a target value. The target value is constantly changing so it needs to be dynamic. I create different CSS classes, and then pass the class it should look at, but I am not sure how to properly write the CSS that would change the face of the gauge face, needle, or value color.  Thanks!  ThingWorx 9.3.8

Hi, Can anybody provide an overview of how to push notification from Thingworx server to Android devices? We are planning to integrate push notification to Android & Ios mobile devices whenever any events are generated on thingworx server.  

I need  to get Property Wise data for logged properties, I have tried to use QueryNamedPropertyHistory service but seems it is too slow, is there alternatives that may be i didn't tried ?We are using TWX Version 9.3.5. 

I get data from Kepware in DWORD and want to show in mashup but doesn't show. How to solve it?      

Now i got line chart like picture below but i want to modify something1.X-Axis that is a time didn't show full date2.On the right hand side, i want to edit sequence that L.33 is first one and then L.34 , L.35 respectively. Thank you  

As per the original post.    Hi  willie.  The following is my service, to upload my csvfile from repository to s3Bucket.But i am not able to upload it from my service.     try { var FolderName = Company + " Stocks"; logger.debug("FolderName :" + FolderName); var ESSSIMDetailsFilePath = FolderName + "/" + Company + "_SIMDetails.csv"; logger.debug("ESS SIM DetailsFilePath :" + ESSSIMDetailsFilePath); // Content: BLOB var Content = Things["SystemRepository"].LoadBinary({ path: FolderName /* STRING */ }); var headers = { 'Content-Type': 'text/csv' }; // result: BLOB var result = Resources["ContentLoaderFunctions"].PutBinary({ proxyScheme: undefined /* STRING {"defaultValue":"http"} */ , headers: headers /* JSON */ , ignoreSSLErrors: undefined /* BOOLEAN */ , useNTLM: undefined /* BOOLEAN {"defaultValue":false} */ , workstation: undefined /* STRING {"defaultValue":""} */ , useProxy: undefined /* BOOLEAN {"defaultValue":false}

Hi all,How to read the timezone in Thingworx? Thank you!    

Hi Experts, Problem : A bar chart and a schedule each have a data set bound. These data sets are created dynamically. Therefore the number of series cannot be defined on a bar chart. (Consequently defining style formats for individual data series is not possible for the bar chart. ) Is it possible to give the same color to the bars that have the same name from the two different charts  ?e.g.,Bar Chart: Apple_Series = Green, Banana_Series = YellowSchedule Chart: Apple_Series = Green, Banana_Series = Yellow Regards, 

I want to fetch all records from the value stream. Value stream stores the 86400 records in one day. I used the QueryPropertyHistory() which gives me only 500 rows and if I define maxItems(Data points of 3 days) it gives me a script timeout error and I want to show this on the line chart. Or is there any limit to showing data points on a line chart?   

How to install Thingworx extensions (RTTPM, DPM, AMU,CWC). I'm browsing the PTC help center to find out how to install the solutions, but I don't understand, as there is no step-by-step guide. I would like help and a description of how to install my ThingWorx is 9-4-1 step by step   Translated by the Community Moderation using Google Translate   Como instalar as extensões do Thingworx ( RTTPM , DPM, AMU,CWC) . Estou navegando para no help center da PTC para saber como instalar as soluções , mais não estou entendendo ,pois, não há um passo a passo. Gostaria do auxilio e uma descrição de como instalar passo a passo meu ThingWorx é 9-4-1.  

Hi all,   When I try to access the Mashup Runtime using a non-administrator account, I get the below error message     I tried following the article    Article - CS289125 - Error getting IR status in Application logs when non-admin users try to access Thingworx Mashups during runtime (ptc.com)   Setting Permissions for Integration Connector Activities (ptc.com)   Still, I'm getting an error   Could someone help me with this    Thanks in advance   /VR  

Hi, I have one property for which I log data for every second in valuestream. I want to display last 3month data from valuestream on time series chart. What is approach I need to use?I am new to Thingworx. Please help.

While fetching data from sql db in thingworx , this query executing for morethan 80 seconds. Any idea on simplifying this query? Query:SELECT distinct a.cmp , a.engseq , a.it, null as COUNTFROM ENGINEERING a WHERE a.MODEL like 'R24R%' AND a.cmp not in ( select cmp from ENGINEERINGwhere MODEL like 'R23R%' ) ;

I need to make a SQL query in Thingworx. The query should read (if I were creating it directly): SELECT * FROM MyDB.MyTable where Name like '%Name_Input%'   Another PTC forum post had recommended this as a possible solution: SELECT * FROM MyDB.MyTable where Name like '%' || [[Name_Input]] || '%'   But this query (above) does not work. The post was from the year 2014 and I'm currently using 8.4.1, so I'm guessing that's the issue.....   Solutions anyone?

I am currently attempting to install an instance of ThingWorx 9.0.3 and I have been having trouble with building the docker images with PostgresSQL as far as I can tell there is no issues with the version numbers. however when I run the build.sh Script it always errors out  with the error: ERROR: failed to solve: process "/bin/sh -c echo 'hosts: files mdns4_minimal [NOTFOUND=return] dns mdns4' >> /etc/nsswitch.conf && adduser --uid 1337 --disabled-password --gecos \"\" --home \"/home/${APP_USER}\" \"${APP_USER}\" && apt-get update && apt-get dist-upgrade -y && apt-get install -y --no-install-recommends wget ca-certificates gnupg && rm -rf /var/lib/apt/lists/* && wget -O /usr/local/bin/gosu \"https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-amd64\" && wget -O /usr/local/bin/gosu.asc \"https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-amd64.asc\" && export GNUPGHOME=\"$(mk

We fetched 5000 rows and 4 columns from sql db in 40seconds.Then In Thingworx code, if i used InfoTable.length to find total number of rows in table is taking additional 20seconds. Any other shortcut to get table length quickly.?Query:SELECT distinct a.cmp , a.engseq , a.it,  null as totalrowsFROM ENGINEERING a WHERE a.MODEL like 'R24R%' AND a.cmp not in ( select cmp from ENGINEERINGwhere MODEL like 'R23R%' ) ;