Cert lines

I am trying to find where in the API the information is stored that shows how many certs were placed in the vanguard tree or the Scythe etc

Anybody have any ideas on where this is located?

 

You can list out which skills (certs) the character has unlocked, which includes the cert cost (skill_point_cost) for each item.
For example:
http://census.daybreakgames.com/get/ps2:v2/character/5428010618015204433?c:join=characters_skill^list:1^inject_at:skills^hide:character_id(skill^list:0^inject_at:skill^hide:skill_id)

You can then use the skill_line, skill_category, and skill_set data to group them together
For example:
http://census.daybreakgames.com/get/ps2:v2/character/5428010618015204433?c:join=characters_skill^list:1^inject_at:skills^hide:character_id(skill^list:0^inject_at:skill^show:name.en'image_id'image_set_id'skill_line_id'skill_line_index'skill_points(skill_line^list:1^inject_at:skill_line^list:0^show:name.en'image_id'image_set_id'skill_category_id'skill_category_index'skill_points'skill_set_id'skill_set_index(image_set^list:1^inject_at:image_set^hide:image_set_id,skill_category^list:0^inject_at:skill_category^show:name.en,skill_set^list:0^inject_at:skill_set^show:name.en)))

However, there appears to something wrong with this data (especially the "skill set") because a lot of them seem to mismatched and don't make any sense. Also sometimes there is no "skill set" listed at all (particularly with weapon attachments and vehicle weapon upgrades, meaning there doesn't seem to be any way to determine which vehicle it belongs to).

I pulled down that data from the second URL and used it to generate a table of all of the certs that I have unlocked, but it shows some really weird stuff including seemingly the same skill multiple times

Here are some examples:

IDSkill SetIDSkill CategoryIDSkill LineIDSkill NameSkill PointsSave Date
51 Infiltrator: Ability Slot 4203 Infiltrator: Cloaking Devices 57 Hunter Cloaking Device 4539 <span style="color: #3366ff">Hunter Cloaking 1 0 2012-11-20 11:00:50.115

192 <span style="color: #ff0000">Heavy Assault: Grenade Slot 195 Infiltrator: Cloaking Devices 454 Hunter Cloaking Device 4540 <span style="color: #3366ff">Hunter Cloaking 1 0 2012-11-20 11:00:50.122
167 <span style="color: #ff0000">Light Assault: Ability Slot 199 Combat Medic: Nano-Healing 475 Nano-Regen Device 4543 Nano-Regen Device 1 0 2012-11-20 11:00:50.122

184 <span style="color: #ff0000">Engineer: Grenade Slot 6184 Mines 1018 Bouncing Betty 4024 Bouncing Betty 2 150 2012-11-21 17:19:39.103

294 <span style="color: #ff0000">Primary 2: Anti-Air: Burster XS 294 Weapon Optics 655 Night Vision Optics 6625 Night Vision Optics 50 2012-11-22 12:37:24.187
387 <span style="color: #ff0000">Primary: Sniper Rifle: Parallax VX3 387 Weapon Optics 810 Night Vision Optics 3166 Night Vision Optics 50 2012-11-25 17:30:58.156

387 <span style="color: #ff0000">Primary: Sniper Rifle: Parallax VX3 387 Weapon Optics 809 Zoom Optics 3163 Zoom Optics 2 50 2012-11-30 17:10:24.077

88 WING MOUNT: Breaker Rockets 111 Weapon Optics 405 Zoom Optics 1856 Zoom Optics 1 1 2012-12-06 16:00:52.045
321 <span style="color: #ff0000">Primary: Assault Rifle: Apocalypse 321 Weapon Optics 699 Zoom Optics 6833 Zoom Optics 1 1 2012-12-06 16:00:52.045

533 <span style="color: #ff0000">PRIMARY WEAPON: S12 Renegade 533 Weapon Ammo 1220 Maximum Ammo Capacity 8376 Ammo Capacity 2 10 2013-02-08 19:03:26.146

136 <span style="color: #ff0000">Primary: Assault Rifle: Cycler TRV 6195 First Aid Certifications 4221 Medical Kit 4630 Medical Kit 2 100 2014-02-09 11:45:46.221
136 <span style="color: #ff0000">Primary: Assault Rifle: Cycler TRV 6195 First Aid Certifications 4222 Restoration Kit 4632 Restoration Kit 2 100 2014-02-09 11:45:46.221

This is an NC character, so there's no way that I have the Cycler TRV (which is also attached to the medical kit / resoration kit certs?), nor the S12 Renegade, Apocalypse, or Parallax VX3 (all of which are attacjed to vehicle weapon upgrades), the Bouncing Betties are listed incorrectly as being in the Engineer Grenade Slot, Medic AOE heal is listed under Light Assault Abilities (instead of Medic Abilities), and Hunter Cloaking 1 is listed twice: once under infiltrator and once under Heavy Assault Grenade slot.

edit: well, that formatting didn't really work out, but you get the idea,

 

Hmm, actually upon further inspection, it appears that these discrepancies might simply be a problem with the joins, rather than the data itself. Pulling up the individual skill categories by ID and then joining directly skill_set seems to produce the correct data.

 

Ok, it turns out that the "skill_set_id" attached to the "skill_line" was the problem, and that I needed to join using the "skill_set_id" from the "skill_category" instead.

This query does exactly what I wanted (of course, this includes everything, so don't use it as-is):
http://census.daybreakgames.com/get/ps2:v2/ch...id(item_category^inject_at:item_category)))))

That lists out the certs by:
skill -> skill_line -> skill_category -> skill_set -> required item (if any) -> item_category

which results in things like:
Zoom Optics 1 -> Zoom Optics -> Weapon Optics -> GUNNER WEAPON: E540 Halberd -> E540 Halberd -> Vanguard Gunner Weapon