cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Textbox value to infotable

SP_9715784
11-Garnet

Textbox value to infotable

I have an Mashup(Temp), which has an TextBox, When ever I enter an Value it is getting updated in the service(Demo). But the values are not getting stored in the INFOTABLE, it's just updating the present value of the TextBox in the Mashup(Temp) to the Service(Demo) InfoTable

Note: I want to store all the data entered in the textbox of the mashup in to an INFOTABLE, 

 

Service Code: 

 

var params = {
    infoTableName : "InfoTable",
    dataShapeName : "Temp_DemoDataShape"
};

var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

var newEntry = new Object();
newEntry.WaterPump = me.WaterPump; // STRING
result.AddRow(newEntry);

 

 

Mashup:

SP_9715784_0-1611215134125.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

I have used QueryImplementingThingsWithNamedPropertyHistory so that I get the logged history data as well last updated value. But I m not getting the output when I used this into service. Can you suggest me what parameters are to be used to call this service.Or I should use some other service.

 
 
 
 

image_2021-01-21_164732.png

 

 

 

var result1 =  ThingTemplates["Temp_DemoThingTemplate"].QueryImplementingThingsWithNamedPropertyHistory({
	propertyNames : {
      "rows": [{
          "name": "WaterPump",
          "description": "propertyDescription"
      }],
      "dataShape": {
          "fieldDefinitions": {
             
              "WaterPump": {
                  "name": "WaterPump",
                  "aspects": {},
                  "description": "",
                  "baseType": "STRING",
                  "ordinal": 2
              }
          }
      }
  },
	nameMask: undefined /* STRING */,
	maxDataItems: 50000 /* NUMBER */,
	dataQuery: undefined /* QUERY */,
	startDate: StartDate /* DATETIME */,
    endDate: EndDate /* DATETIME */,
    oldestFirst: undefined /* BOOLEAN */,
	tags: undefined /* TAGS */
});
result = result1;

 

 

View solution in original post

4 REPLIES 4

You can have a property of type infotable on a Thing. Make it persisted and then you can set it using below type of service where 'Test' is your input from text box. As you will add the value from text box all the values will be appended in the infotable property and if you want to get all the values you can simply do a getpropertyvalues on that thing property:

 

let params1 = {
t1: me.Test /* INFOTABLE */
};
// result: INFOTABLE
let result2 = Resources["InfoTableFunctions"].Clone(params1);
var obj = new Object();
obj.Test=Test;
result2.AddRow(obj);
me.Test = result2;

 

In above snippet my property name is Test and the input in the service is also Test ,so don't get confuse with many Test.

 

Thanks,

Mukul Narang

Thanks for the Reply.... but that's a lot of confusion with the 'Test'....

Let me paste some screenshot to make it more clear, one Test is the service input which will be binded to value of text box. Another Test is the property name (of type infotable) on the thing which will retain all the values for you.

mnarang_0-1611226818505.png

 

mnarang_1-1611226912457.png

 

I have used QueryImplementingThingsWithNamedPropertyHistory so that I get the logged history data as well last updated value. But I m not getting the output when I used this into service. Can you suggest me what parameters are to be used to call this service.Or I should use some other service.

 
 
 
 

image_2021-01-21_164732.png

 

 

 

var result1 =  ThingTemplates["Temp_DemoThingTemplate"].QueryImplementingThingsWithNamedPropertyHistory({
	propertyNames : {
      "rows": [{
          "name": "WaterPump",
          "description": "propertyDescription"
      }],
      "dataShape": {
          "fieldDefinitions": {
             
              "WaterPump": {
                  "name": "WaterPump",
                  "aspects": {},
                  "description": "",
                  "baseType": "STRING",
                  "ordinal": 2
              }
          }
      }
  },
	nameMask: undefined /* STRING */,
	maxDataItems: 50000 /* NUMBER */,
	dataQuery: undefined /* QUERY */,
	startDate: StartDate /* DATETIME */,
    endDate: EndDate /* DATETIME */,
    oldestFirst: undefined /* BOOLEAN */,
	tags: undefined /* TAGS */
});
result = result1;

 

 

Top Tags