# API /GUI Req

**URL:** <https://forums.plex.tv/t/api-gui-req/47416>\
**Category:** Feature Suggestions\
**Created:** [November 21, 2013, 12:03am UTC](https://forums.plex.tv/t/api-gui-req/47416 "2013-11-21T00:03:48Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![dane22](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/dane22/32/4389_2.png) [@dane22](https://forums.plex.tv/u/dane22)\
**Post date:** [November 21, 2013, 12:03am UTC](https://forums.plex.tv/t/api-gui-req/47416/1 "2013-11-21T00:03:48Z")

</div>

I would like to have the hash field from the metadata\_items table exposed in the xml of the web UI.

&nbsp;

I could really use that for 3.Party programming, in order to avoid direct access to the database

&nbsp;

And yes...this is a strange one, so likely no likes here....snifff, but....

&nbsp;

Ninja's, could you please point the devs towards this, cuz. it's a very little change in their code, but will have a huge impact for me and others coding against the meta-data file-structure

&nbsp;

/Tommy

&nbsp;

EDIT: wrong table.....I need the hash field from the media\_parts table, not from the metadata\_items table

---

<div class="post-metadata">

**Author:** ![elan](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elan/32/5_2.png) [@elan](https://forums.plex.tv/u/elan)\
**Post date:** [November 22, 2013, 3:29am UTC](https://forums.plex.tv/t/api-gui-req/47416/2 "2013-11-22T03:29:44Z")

</div>

Not something we really want to expose, why would you want it? :)

---

<div class="post-metadata">

**Author:** ![dane22](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/dane22/32/4389_2.png) [@dane22](https://forums.plex.tv/u/dane22)\
**Post date:** [November 22, 2013, 6:37am UTC](https://forums.plex.tv/t/api-gui-req/47416/3 "2013-11-22T06:37:28Z")

</div>

> Not something we really want to expose, why would you want it? :)

Working on an offline indexer, and have so far a proof of concept working in my lab.

But need the location of where to put the index-sd.bif file, and the only way I can get to that, is AFAIK by accessing the database directly.

/Tommy

---

<div class="post-metadata">

**Author:** ![dane22](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/dane22/32/4389_2.png) [@dane22](https://forums.plex.tv/u/dane22)\
**Post date:** [November 22, 2013, 6:44am UTC](https://forums.plex.tv/t/api-gui-req/47416/4 "2013-11-22T06:44:44Z")

</div>

Proof of concept:

[https://github.com/ukdtom/Plex\_Offline\_Indexer](https://github.com/ukdtom/Plex_Offline_Indexer)

/T

---

<div class="post-metadata">

**Author:** ![dane22](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/dane22/32/4389_2.png) [@dane22](https://forums.plex.tv/u/dane22)\
**Post date:** [November 22, 2013, 3:11pm UTC](https://forums.plex.tv/t/api-gui-req/47416/5 "2013-11-22T15:11:41Z")

</div>

And adding to self....

My little project works perfectly on OpenSuse 12.3, but fails sadly on Win7x64 with a db connect error saying that the database is encrypted......SIGH....

(And yes....Running Python 2.7 on that as well)

So really could use this property, in order to completely avoid having to connect to the database, and instead could use your wonderful api :wub:

And remember Elan.....Christmas is very close so it would be a nice present from you to us&nbsp; :rolleyes:&nbsp;

/Tommy

---

<div class="post-metadata">

**Author:** ![dane22](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/dane22/32/4389_2.png) [@dane22](https://forums.plex.tv/u/dane22)\
**Post date:** [November 22, 2013, 4:46pm UTC](https://forums.plex.tv/t/api-gui-req/47416/6 "2013-11-22T16:46:52Z")

</div>

Currently running an indexing of +3500 items in my tv-section, with increased speed compared towards running it nativvly on my QNAP, and the util. on my QNAP is for Plex is 0.5% :D

/Tommy

---

<div class="post-metadata">

**Author:** ![dane22](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/dane22/32/4389_2.png) [@dane22](https://forums.plex.tv/u/dane22)\
**Post date:** [December 1, 2013, 12:29am UTC](https://forums.plex.tv/t/api-gui-req/47416/7 "2013-12-01T00:29:14Z")

</div>

@Elan

You asked for reasons, but never responded, so I guess you got sidetracked here?

Best Regards

Tommy

EDIT: Might also wanna take a peek here: [https://forums.plexapp.com/index.php/topic/88012-q-about-hash/?p=510036](https://forums.plexapp.com/index.php/topic/88012-q-about-hash/?p=510036)
