Timeline for How do I automate the data explorer download?
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 18, 2021 at 12:14 | history | edited | CommunityBot |
replaced http://data.stackexchange.com/ with https://data.stackexchange.com/
|
|
| Nov 17, 2020 at 21:06 | comment | added | rene Mod |
@user3123159 this will work https://api.stackexchange.com/docs/comments-on-users#order=desc&sort=votes&ids=811&filter=!)Q2A3(brA9BlriV-A2Kh)6X3&site=stackoverflow&run=true but if you want the question title, you have to do an extra call per comment to get the title of the posts from the posts endpoint https://api.stackexchange.com/docs/posts-by-ids#order=desc&sort=activity&ids=243778&filter=!9_bDDt835&site=stackoverflow&run=true that can all be done client side with a bit of javascript run in the browser
|
|
| Nov 17, 2020 at 19:45 | comment | added | user3123159 |
I want to have the result of this query: DECLARE @UserId int = ##UserId## SELECT c.Score, c.Id as [Comment Link], p.Id as [Post Link], c.Text, c.CreationDate, c.UserId as [User Link] FROM Comments c, Posts p WHERE p.Id = c.PostId AND c.UserId = @UserId ORDER BY c.Score DESC on my website on github pages (no server, only js).The option with csv does not work because I am serverless.Just creating an api link seems impossible because of 2 tables in use(comments and posts).
|
|
| Mar 20, 2017 at 10:30 | history | edited | CommunityBot |
replaced http://meta.stackexchange.com/ with https://meta.stackexchange.com/
|
|
| Mar 10, 2015 at 22:14 | history | edited | reneMod | CC BY-SA 3.0 |
be nice for other answers
|
| Mar 10, 2015 at 21:45 | history | edited | reneMod | CC BY-SA 3.0 |
added 1 character in body
|
| Mar 10, 2015 at 21:40 | history | answered | reneMod | CC BY-SA 3.0 |