Access Data Sent to Thingworx Foundation Server

[mkumar-41]

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

[liliu]

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

[mkumar-41]

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

[liliu · Accepted solution]

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

[mkumar-41]

Thanks a lot Lily it is working now.

[liliu]

Hi Mahesh,

Sure, if you have any concern, please feel free to let us know.

BR,

Lily