Skip to main content
M
mkumar-411-Visitor
1-Visitor
July 30, 2017
Solved

Access Data Sent to Thingworx Foundation Server

  • July 30, 2017
  • 2 replies
  • 3655 views

Hi Experts,

I have installed Thingworx Foundation Server 8.0 with Postgres as the persistence provider.

I have configured .NET SDK (ThingWorx IoT Marketplace) and remoteThing is configured in Foundation Server.

http://localhost:8080/Thingworx/Things/SteamSensor2/Properties/isConnected is true and all data pushed by the .NET is reflected when I click refresh in  http://localhost:8080/Thingworx/Composer/index.html under StreamSensor2 --> Properties.

The question is where is the data pushed by the .NET code stored in Thingworx Foundation Server? Is it in-memory or in Posgtres DB?

Using http://localhost:8080/Thingworx/Things/SteamSensor2/Properties?Accept=application%2Fjson&method=get I can access the latest information

How can I want to access all the data pushed by .NET code?

I wanted to access all the data pushed by .NET code so that it can be used in Dataiku as one data source.

Thanks

Mahesh

Best answer by liliu

Hi Mashesh,

When you run "select * from value_stream", you actually get all saved data. If there are more data transfered from .net SDK, it means some data didn't transferred successfully.

BR,

Lily

2 replies

L
liliu5-Regular Member
5-Regular Member
July 31, 2017

Hi Mahesh,

You can set your properties to be logged and bind a value stream to the thing. All data will be loggied in that value stream, which is saved on persistence provider (postgresql)

Run service QueryPropertyHistory, you can get all history data.

If I misunderstood your question, please clarify me.

Best Regards,

Lily

M
mkumar-411-VisitorAuthor
1-Visitor
July 31, 2017

Thanks a lot Lily for the valuable information.

I have did the following steps

Now, when I start the .NET code and execute QueryPropertyHistory I get only 3 results. But .NET code send many records.

I also queries value_stream table in postgres. How can I retrieve all the records?

Thanks

Mahesh

L
liliu5-Regular MemberAnswer
5-Regular Member
August 1, 2017

Hi Mashesh,

When you run "select * from value_stream", you actually get all saved data. If there are more data transfered from .net SDK, it means some data didn't transferred successfully.

BR,

Lily

M
mkumar-411-VisitorAuthor
1-Visitor
August 1, 2017

Thanks a lot Lily it is working now.

Terms & ConditionsAccessibility statement