JavaScript is required to use Bungie.net

Group Avatar

BungieNetPlatform

"Updates, discussions, and documentation of the BungieNetPlatform API."

Request Join
originally posted in:BungieNetPlatform
3/27/2016 10:54:34 PM
1

API activity IDs not present in world content SQLite db

First off, very excited to play around with the Destiny API, and really appreciate it being available to the public! I was trying to familiarize myself with the data, and wanted to make sure I'm looking at the correct data sources because I'm running into the problem of ids or hashes returned in the API not matching anything in the SQLite db. I downloaded and extracted the world content SQLite db from the URL given in the Manifest (http://bungie.net/common/destiny_content/sqlite/en/world_sql_content_2b85b55fdd10478d95b9ed3e976c52f7.content). I wanted to take a look at the current daily / weekly activities, so I pulled that data from the API: [quote]curl -H "x-api-key: MY_API_KEY" -G http://www.bungie.net/platform/destiny/advisors/[/quote] There's an activity in the response with the hash 232625303 , so I tried to look up info about it in the SQLite db: [quote]SELECT * FROM DestinyActivityDefinition WHERE id = 2326253031; [/quote] ... But that returns nothing. The API request equivalent, however, does return data successfully: [quote]curl -H "x-api-key: MY_API_KEY" -G http://www.bungie.net/platform/destiny/manifest/Activity/2326253031/ [/quote] It happened with a couple different activity IDs too. Why are these missing from the SQLite db? Am I not looking in the right place? I'd hate to have to query the API for metadata about every single activity :( Thanks for the help.

Posting in language:

 

Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

  • Try this: SELECT * FROM DestinyActivityDefinition WHERE id & 0xFFFFFFFF = 2326253031; SQLite is wanting to read the values as signed ints, whereas the actual values are unsigned. This should get data back for you.

    Posting in language:

     

    Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

    2 Replies
    You are not allowed to view this content.
    ;
    preload icon
    preload icon
    preload icon