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

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Access Data Sent to Thingworx Foundation Server

mkumar-41
1-Newbie

Access Data Sent to Thingworx Foundation Server

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

5 REPLIES 5

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

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

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

Thanks a lot Lily it is working now.

Hi Mahesh,

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

BR,

Lily

Top Tags