Tandem stream data from excel file

[Rahma_MorshedWDF4L]

Hello, 

I have been wondering if i could post data to tandem connection stream from an excel file containing a series of history data defined by  parameter and timestamp? I would appreciate you letting me know if there is a way.

Thank you

[derek_milz]

Hi,

Yes, you can certainly do this and would suggest performing a POST to Tandem's generic webhook.  In Tandem if you go to connections > click the 3 vertical ellipsis > webhook integration > and within that configuration if you click the hyperlinked "Here", we have example code on how to achieve this.  Ultimately you'll have to write a program that creates a payload and convert your timestamps to unix like:

[
{
temperatureValue: 25,
pressureValue: 100,
id: 'AQAAAJVLslwb80o0jqA8wgUzxPYAAAAA',

ts: 1713902785
},
{
temperatureValue: 23,
pressureValue: 95,
id: 'AQAAAJVLslwb90o0jqA9wgUzxQYAAAAA',

ts: 1713902785
}
]

You would then POST this data to the webhook given to you by Tandem.

This can also be done in Tandem Connect if you regularly schedule these files to go to an sftp server for example or maybe the data is accessible via REST API.

Any questions, please let us know.  Thanks!

Derek

[rahma_202010551]

Sorry for the late reply!

This is very helpful thank you... I am trying to use Tandem Connect for that purpose as you suggested,  but I have a problem creating the right flow for that purpose. Is there a sample pipeline to start with that can be used to get data from an Excel file and post it to my stream?

[derek_milz]

Sure, we can help with that.  Is it an excel file that is hosted in SharePoint that TandemConnect would be able to access?  Or perhaps a more direct connection to the system where this data is coming from?

Thanks,

Derek

[rahma_202010551]

Currently, it's not on SharePoint; it's on my local server. Do we require it to be on a cloud storage platform? I can utilize OneDrive for that if necessary to facilitate the process.

Thanks for your help,

Rahma

[derek_milz]

It will be the easiest at this point.

One Drive works well, we can use our Microsoft Graph plugin to authenticate and read that file.  If you could start here:  

https://learn.microsoft.com/en-us/onedrive/developer/rest-api/getting-started/msa-oauth?view=odsp-gr... 

This will show you how to setup access to your environment.  Once that is in place, we can work together to build out the pipeline.

Thanks!

Derek

[rahma_202010551]

Well, I'm checking the link you sent, I found it a bit more complicated than i thought. So i am trying to create that access token and will get back to you. If there is a way we can use to link the file directly from my PC locally to Tandem connect, please let me know how to do it.

Thanks 

Rahma

[AdamPeter]

This is an old video, but if you can convert your CSV file into a JSON format (there are web sites that can do this) you can use postman to send it.

[rahma_202010551]

I tried that and it was successful. Trying now to do it using Tandem Connect.

Thanks for the support.

Rahma