Flow's Set Thing Property Action to set parameter of Infotable type?

[anickolsky]

Hi all,

Anybody used Thingworx Flow "Set Thing Property" Action to set parameter of Infotable type?

Seems like it could only be used to set basic types like string or number?

Any ideas of how to use it for parameters of type Infotable ?

Thanks

[raluca_edu]

Hi,

I tested in TWX Flow 8.5.3 and it is working on my side:

What version are you using?

Raluca Edu

[anickolsky]

Hi Raluca,

I'm on 8.5.4

Issue is if input is infotable (and holds multiple rows) it's not possible to map it as infotable to infotable.

I cannot see input in your silde.

Pls see attached screenshots.

Many thanks,

Andrey

[raluca_edu]

Hi,

I have added infotable as input for set property and I am getting the following error in Application.log:

"An Invalid Property Value Was Sent To [thing1 Property: [[{"name":"tom","age":1},{"name":"jerry","age":2}]]"

Can you see same error in Application.log after running flow?

Thanks,

Raluca Edu

[anickolsky]

Hi Raluca,

I don't see this kind of error since I use input as an output from provious service that runs smooth.

The only way to do mapping is to derive single parameters one by one from input and map them to aparameters of manualy added row. That's not a solution for sure.

Regards,

[raluca_edu]

Hi,

Seems I would need to open a ticket with R&D.

I will come back to confirm ticket was open.

Do you want also to open a ticket with PTC Support?

Thanks,

Raluca Edu

[anickolsky]

Hi Raluca,

Yes I did, 

https://www.ptc.com/appserver/cs/view/case.jsp?n=15344071

Regards,

Andrey

[slangley · Accepted solution]

Hi @anickolsky.

Per the case opened for this issue, the following is the workaround:

Create another javascript service which assigns the Property value of Infotable P1 to P2.  Example: me.P2=me.P1.  In Workflow, instead of using SetThingProperty, use another Execute Service action for executing this new Service.

If you agree that this is the solution, please mark this post as the Accepted Solution for the benefit of others on the community.

Regards.

--Sharon