Getting my infotable to my stream

[Janicen]

Hello everyone

I have a stream that has a property infotable.

I want to write a service inside of that stream, I want this service to get each row ID inside of my infotable and store these IDs within an array.

I have tried using the queryinfotableproperty history service.

This does not seem to work.

Kindly suggest how I can go about fixing this?

Thank you so much.

[nmilleson]

@Janicen ,

Is this a Stream thing or a Value Stream? Also, could you share some of the code you're using?

Nick

[Janicen]

Hi Nick

This is a stream Thing.

I have attached a screenshot below.

[nmilleson · Accepted solution]

@Janicen ,

Thanks for the code sample.  The service you are using above is used on properties of that Stream thing, not for columns that are actually in the stream.  To access stream entries, you would use the service QueryStreamEntriesWithData.  That will give you the metadata (i.e. the Id of the stream entry) as well as the data columns in each row.

Thanks,

Nick

[nmilleson]

To clarify the QueryInfoTablePropertyHistory vs. QueryStreamEntriesWithData a bit more on your stream thing:

If you were to click on the Properties tab of your stream, create an Infotable property, and set logging to true, it would log that property's history to a Value Stream (if you have one set up on your Stream thing).  Then you would use QueryInfoTablePropertyHistory to access the history of that property on your Stream thing.  That is not tied in any way to the contents of the Stream that you are storing on the Stream thing.

Conversely, when you add entries to your stream using AddStreamEntry or AddStreamEntries, you would then use QueryStreamEntries or QueryStreamEntriesWithData to access the data that is inside that Stream.  Again, it is not tied in any way to the Properties of the Stream Thing.  

Hope that helps clear it up a little.