D3 Game Data API experts out there

[MicroRNA-1507]

I’m looking for help from the API experts.

I am trying to get the current era leaderboards for all classes for solo greater rifts to perform a careful analysis using data from multiple regions. Is anyone willing to help generate an excel file for this? I tried to get the data from the API link at the bottom of the website but for some reason I can not get the subsequent json to excel file conversion to work.

[DogBone-1354]

Use an intermediate to pull the data and translate it to CSV/XML/other format.

Personally, I’d look at Node.js to translate and store the results into some free database (MS SQL Express/Oracle Express/Postgresql etc). From there, export the data in Excel CSV/XML format.

As an Oracle guru…i can say : this can be easily done with Oracle APEX, Simple PL/SQL Code, and Oracke 18c Express RDBMS. (12GB max…uncompressed)

Note: most likely, you will need a “developer’s key”. Never post that info.

[Venaliter-1813]

@MicroRNA-1507

I am trying to get the current era leaderboards for all classes for solo greater rifts to perform a careful analysis using data from multiple regions.

Cant help you with your current project, but I wanted to pop in and say I enjoy your posts. I look forward to this one.

[MicroRNA-1507]

I suspect this one may be beyond my ability.

For my statistics post, I tend to brute force them unless I can find an alternative approach like diablo3ladder.

I saw this and immediately got jealous.

(Example from S12) Offensive Ability and Efficiency Analysis Sample

CLAIMER: THIS IS AN OLD ANALYSIS GIVEN AS AN EXAMPLE FOR POTENTIAL FUTURE ANALYSES, I MIGHT TURN THIS INTO A WIKI SO THAT VARIOUS FOLKS CAN DO THE SAME/SIMILAR WORKS WITH DIFFERENT FORMULAS. THIS WILL SHOW VARIOUS PERFORMANCE MEASURES FROM DIFFERENT PERSPECTIVES WITH NEW SEASONS OR ERAS In this study, I am going to compare the greater rift clearing efficiency of every class using whole leader board of Season 12 as of 01/12/2017. As a confirmation basis for balancing, I will compare every cla…

Considering that the next patch that involved any changes was patch 2.6.4, I suspect the numbers for season 13-15 (Patches 2.6.1 a,b,c) might be similar. Season 16 had patch 2.6.4. Season 17 had patch 2.6.5.

[Venaliter-1813]

Maybe I don’t know what I’m doing (or reading), but since Wizards are doing like 10x more damage then WDs with LoN Starpact, I’m pretty skeptical of that analysis.

I often wonder how the game would look if reverse-archon wasn't a thing. Honestly, I think it might be way better.

[MicroRNA-1507]

The post that I linked was looking at the data from season 12. Since then, a number of game changes have occurred including discovery of the wizard bazooka build.

[Venaliter-1813]

LoN was buffed in S16, but I think FP SP has been the same since…Season 11?

[Ubiquity-6737]

Something like this for example?

Rank, Rift level, BattleTag, Paragon, Completion time in milliseconds

1, 136, pseudonym#11985, 4332, 825383
2, 133, Condi#11212, 4170, 829183
3, 132, Yikes#11199, 4305, 782450
4, 132, Mosstradamus#1302, 4268, 815000
5, 131, Okaper#1351, 4202, 790316
6, 129, Giles#6828, 2592, 890416
7, 128, Puger#1930, 2971, 745199
8, 128, Dumba22#1526, 3310, 754216
9, 128, BruceLeeroy#11708, 2250, 875300
10, 127, cagna#11751, 4230, 723650