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

Access Data Sent to Thingworx Foundation Server

SOLVED
Highlighted
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 push...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 ...

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

Re: Access Data Sent to Thingworx Foundation Server

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

Re: Access Data Sent to Thingworx Foundation Server

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

Re: Access Data Sent to Thingworx Foundation Server

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

Re: Access Data Sent to Thingworx Foundation Server

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

Re: Access Data Sent to Thingworx Foundation Server

Thanks a lot Lily it is working now.

Re: Access Data Sent to Thingworx Foundation Server

Hi Mahesh,

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

BR,

Lily