Forums / Support / Halo API Support

Getting Victim Agent Locations Through Power Query

OP Foge

I'm currently having issues getting the VictimAgentLocation to load up in Excel using power query. I am able to get TimeSinceStart, EventName, Player, Weapon Attachment ID, and weapon Stock ID, but nothing seems to go past those rows (which is where I imagine the x,y,z locations would be) Heres an image for reference: https://i.imgur.com/KDdeAYx.png

The query I'm using is as follows:
Quote:
let
Source = Json.Document(Web.Contents("https://www.haloapi.com/stats/h5/matches/72932747-1d16-427f-b7ba-0c72c710cdbf/events?", [Headers=[#"Ocp-Apim-Subscription-Key"="e2f7c59c1f5a401ca364fa8e20a5583d"]])),
GameEvents = Source[GameEvents],
#"Converted to Table" = Table.FromList(GameEvents, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"RoundIndex", "TimeSinceStart", "EventName", "Player", "WeaponAttachmentIds", "WeaponStockId"}, {"RoundIndex", "TimeSinceStart", "EventName", "Player", "WeaponAttachmentIds", "WeaponStockId"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded Column1", each true)
in
#"Filtered Rows"
I used the guide written up on this thread from Furiousn00b: https://www.halowaypoint.com/en-us/forums/01b3ca58f06c4bd4ad074d8794d2cf86/topics/importing-data-using-excel-powerquery/5f525270-27bd-42fb-b5c2-0a1b6ea1e6d1/posts

I can see that there is an extra values error that is occurring, but I'm not sure why. I am new to this so I'm probably missing something super obvious.
I'm trying to gather location data to create various overhead maps for Forge maps within ArcGIS.
Any help would be appreciated! Thanks!