New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Retrieve urls / statistics #1

Closed
LBegnaud opened this Issue Jul 24, 2017 · 4 comments

Comments

Projects
None yet
2 participants
@LBegnaud

I have this working per the blog post, but I'm not well-versed with azure enough to know how to retrieve data from the storage tables. What would be the simplest way to list that data?

@sjkp

This comment has been minimized.

Show comment
Hide comment
@sjkp

sjkp Jul 27, 2017

Owner

Hi @LBegnaud I wrote a blog post on how I would do the analytics using power bi, http://wp.sjkp.dk/azure-functions-shortcode-analytics/

Owner

sjkp commented Jul 27, 2017

Hi @LBegnaud I wrote a blog post on how I would do the analytics using power bi, http://wp.sjkp.dk/azure-functions-shortcode-analytics/

@sjkp sjkp closed this Jul 27, 2017

@LBegnaud

This comment has been minimized.

Show comment
Hide comment
@LBegnaud

LBegnaud Jul 27, 2017

Cool I'll take a look

Thanks!

Cool I'll take a look

Thanks!

@LBegnaud

This comment has been minimized.

Show comment
Hide comment
@LBegnaud

LBegnaud Jul 27, 2017

Hmm @sjkp i don't see the changes you made to clean up clientIP

Otherwise great writeup!

Hmm @sjkp i don't see the changes you made to clean up clientIP

Otherwise great writeup!

@sjkp

This comment has been minimized.

Show comment
Hide comment
@sjkp

sjkp Jul 27, 2017

Owner

@LBegnaud yes, I have commited the changes now. Look in https://github.com/sjkp/UrlShortener/blob/master/UrlShortener/Redirect/run.csx for the changes.

Also commited my powerbi file for reference, but it is using the OData Azure Table endpoint, so it will not work when more than 1000 elements are in the analytics table, use the method described in the blog post instead.

Owner

sjkp commented Jul 27, 2017

@LBegnaud yes, I have commited the changes now. Look in https://github.com/sjkp/UrlShortener/blob/master/UrlShortener/Redirect/run.csx for the changes.

Also commited my powerbi file for reference, but it is using the OData Azure Table endpoint, so it will not work when more than 1000 elements are in the analytics table, use the method described in the blog post instead.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment