# API not returning full values **URL:** \ **Category:** Warcraft Logs\ **Created:** [January 24, 2020, 8:52pm UTC](https://forums.combatlogforums.com/t/api-not-returning-full-values/9045 "2020-01-24T20:52:07Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Ellesmere](https://avatars.discourse-cdn.com/v4/letter/e/dc4da7/32.png) [@Ellesmere](https://forums.combatlogforums.com/u/Ellesmere)\ **Post date:** [January 24, 2020, 8:52pm UTC](https://forums.combatlogforums.com/t/api-not-returning-full-values/9045/1 "2020-01-24T20:52:07Z")
Hi Khira! I’m working on an API similar to wowanalyzer for my site [wingsisup.com](http://wingsisup.com) to help automate giving advice to players on how to improve their mythic+ gameplay as a Holy Paladin based on their logs. Unfortunately I’m running into an issue where fetching the table data for total casts isn’t returning all the values. I saw a post regarding table deaths being limited at 200, is that true for all table APIs? and if so how does WoWanalyzer get around that? Thanks again for all you do for the community. \*edit: here’s an example: [https://www.warcraftlogs.com/v1/report/tables/casts/LhH1MdY9yXAKNfPg?start=78516111&end=79348405&&api\_key=1e988a008d57d35ac87bf6ba5438e69b](https://www.warcraftlogs.com/v1/report/tables/casts/LhH1MdY9yXAKNfPg?start=78516111&end=79348405&&api_key=1e988a008d57d35ac87bf6ba5438e69b) You’ll see it’s missing a ton of casts (everything past consecration isn’t being returned) compared to what it should be returning: [https://www.warcraftlogs.com/reports/LhH1MdY9yXAKNfPg#fight=5&type=casts&source=171](https://www.warcraftlogs.com/reports/LhH1MdY9yXAKNfPg#fight=5&type=casts&source=171) ---
**Author:** ![Kihra](https://yyz1.discourse-cdn.com/flex029/user_avatar/forums.combatlogforums.com/kihra/32/1116_2.png) [@Kihra](https://forums.combatlogforums.com/u/Kihra)\ **Post date:** [January 24, 2020, 11:39pm UTC](https://forums.combatlogforums.com/t/api-not-returning-full-values/9045/2 "2020-01-24T23:39:35Z")
You didn’t specify the paladin as the source in the API query, so you’re just getting casts for all players (which does not include the full casts for everybody). ---
**Author:** ![Ellesmere](https://avatars.discourse-cdn.com/v4/letter/e/dc4da7/32.png) [@Ellesmere](https://forums.combatlogforums.com/u/Ellesmere)\ **Post date:** [January 24, 2020, 11:42pm UTC](https://forums.combatlogforums.com/t/api-not-returning-full-values/9045/3 "2020-01-24T23:42:17Z")
thanks! what query would i add to specify the player? ---
**Author:** ![Kihra](https://yyz1.discourse-cdn.com/flex029/user_avatar/forums.combatlogforums.com/kihra/32/1116_2.png) [@Kihra](https://forums.combatlogforums.com/u/Kihra)\ **Post date:** [January 24, 2020, 11:43pm UTC](https://forums.combatlogforums.com/t/api-not-returning-full-values/9045/4 "2020-01-24T23:43:40Z")
sourceid is what you want. ---
**Author:** ![Ellesmere](https://avatars.discourse-cdn.com/v4/letter/e/dc4da7/32.png) [@Ellesmere](https://forums.combatlogforums.com/u/Ellesmere)\ **Post date:** [January 24, 2020, 11:44pm UTC](https://forums.combatlogforums.com/t/api-not-returning-full-values/9045/5 "2020-01-24T23:44:10Z")
or better yet is there a list of queries I can use to target things like that? (start, end, player, etc) ---
**Author:** ![Ellesmere](https://avatars.discourse-cdn.com/v4/letter/e/dc4da7/32.png) [@Ellesmere](https://forums.combatlogforums.com/u/Ellesmere)\ **Post date:** [January 24, 2020, 11:44pm UTC](https://forums.combatlogforums.com/t/api-not-returning-full-values/9045/6 "2020-01-24T23:44:44Z")
great thanks very much ---
**Author:** ![Kihra](https://yyz1.discourse-cdn.com/flex029/user_avatar/forums.combatlogforums.com/kihra/32/1116_2.png) [@Kihra](https://forums.combatlogforums.com/u/Kihra)\ **Post date:** [January 24, 2020, 11:45pm UTC](https://forums.combatlogforums.com/t/api-not-returning-full-values/9045/7 "2020-01-24T23:45:17Z")
[www.warcraftlogs.com/v1/docs](http://www.warcraftlogs.com/v1/docs) has all the parameters listed. If the parameters aren’t good enough, you can use the filter parameter to pass a full-blown expression (like is used on the site for pins). ---
**Author:** ![Ellesmere](https://avatars.discourse-cdn.com/v4/letter/e/dc4da7/32.png) [@Ellesmere](https://forums.combatlogforums.com/u/Ellesmere)\ **Post date:** [January 24, 2020, 11:46pm UTC](https://forums.combatlogforums.com/t/api-not-returning-full-values/9045/8 "2020-01-24T23:46:00Z")
perfect, you’re a life saver!