Skip to main content
S
svisveswaraiya_2859881-Visitor
1-Visitor
July 4, 2019
Question

Passing result to property through subscription

  • July 4, 2019
  • 2 replies
  • 1680 views

Hi,

How can I pass a result to a property of a Thing? 

I have a service which executes the stored procedure and returns a output string. I am calling this stored procedure through a subscription so whenever there is a data change in a tag in kepware, a row is updated into the sql. 

I wanted to set the service output string in the property of that Thing through a subscription whenever the tag value is changed.

PropertyPropertyserviceservicesubscriptionsubscription

 

Thanks,

Shalini V.

2 replies

B
BennyB16-Pearl
16-Pearl
July 5, 2019

Hi @svisveswaraiya_285988 ,

 

have you defined the output of your service? I am not familiar with the old Thingworx layout but the question marks do not tell me the output type.

Additionally from what I know the service output needs to be stored to the variable result in your service. But I am also not familiar with this Execute syntax you use there.

K
kornelius5-Regular Member
5-Regular Member
July 5, 2019

Hi @svisveswaraiya_285988 ,

 

You are trying to map an infotable (output from service) to a string (property on Thing). To map your an entry from the first row, you result1.<ColumName> or choose your row with result[rowNumber].<ColumnName>: E.g result1[3].name

S
svisveswaraiya_2859881-VisitorAuthor
1-Visitor
July 5, 2019

Hi @kornelius,

Thanks for your response. Should I change the property base type to infotable? Because after changing the subscription in a format you told its not setting any value in property.


var params = {
stationName: undefined /* STRING */,
skidNumber: undefined /* STRING */,
ToggleType: undefined /* STRING */
};

// result: INFOTABLE dataShape: "Navistar_ExecShipping_DS"
var result1 = me.Exec_TrackingData(params);

me.PRB415 = result1.ReturnResult

 

The ReturnResult is the column name of my infotable of Exec_TrackingData service.

Please tell me what I am missing.

 

Thanks,

Shalini V.

K
kornelius5-Regular Member
5-Regular Member
July 5, 2019

Hi @svisveswaraiya_285988 ,

 

The property base type in the PRB415 should stay as a string. In general it looks fine. As you are still facing issues, I recommend following:

To understand how to update properties, strip away the complexity first before working with a subscription:
1) Create an infotable with one row (e.g. as property, or in a service)

2) Write one field from the infotable into a string property on a thing (with a service)

Use the script logs to understand where your service fails.
Then apply it to your case. 

Terms & ConditionsAccessibility statement