Export of 24 hour stats as CSV or XLS

Help
1

I need to provide a link on an experience page or dashboard so that my customer can download a file containing the last 4 or 8 hours averages with approx 15 min resolution.

I’ve been looking at the “Time series node”, but wasn’t sure if there was a better direction for me to go.

Any help here would be great.

Thanks

3

Hi @Lars_Andersson,

The best approach to this would be to have a button that triggers an Experience Endpoint (we will call it /download) with a workflow for exporting. The Experience Workflow would contain a Time Series Node followed by a CSV Node to format the data and finally an Email Node to send the data to the user.

Let me know how else I can help!
Julia

4

ok, it seems like I was on the right track then

5

So that endpoint should be: No Static Reply (use experience workflow to reply)

6

So , I got it to work all the way to emailing just the csv string, but is there a way to format the email so it becomes an email with this csv file as an attachment?

7

Hi Lars,

There is a forum post here detailing how to do that! :partying_face:

Thanks,
Julia

8

So if I understand that thread correctly, I need to use the HTTP post to sendgrid?

9

@Lars_Andersson, yes this is correct

10

OK, I’m almost there, but unsure of how to configure the HTTP post node with my Sendgrid API key or authentication.

11

I figured it out. I left out the Base64 mutation.

1 Like
12

Just realized that , as far as I can see, theTime Series node only aggregates one attribute at the time.
What options do I have for doing several attributes?

13

Hi @Lars_Andersson,

You may find some of the actions of the Losant API Node to be quite helpful. I would recommend checking out this documentation.

Thanks!
Julia

14

OK, or do you think a Notebook might be a better option?