Users' address book

[alimovz]

Hey guys,

Where do I look for a certain user's address book items? Like lets say I have a user's id 301 and/or account_id 1b7ffae4-366a-4746-82c8-cc65a4ec3aae. Where in the database do I look to see that user's address book emails? There are four tables in each user's mysql mailbox databases. Let's say the above user 301 with the databases name mailbox301 will have four tables:

appointment
mail_item
open_conversation
tombstone

Where to look?

Thank you.

[dkarp]

We don't suggest you do that. It's much, much, much more straightforward to get at the contact data in CSV or vCard format via the REST interface.

However, if you really want to go straight to the database, the contact data is in the METADATA column of the MAIL_ITEM table. Contacts are rows for which TYPE = 6. To decode this data, convert to a string (the column data is in UTF-8) and then use the BEncoding decoder of your choice.

[alimovz]

What is REST interface?

[dkarp]

You need to work with us here. There's a wiki and there's a large quantity of old threads in the forums. You need to look there before asking questions.

Anyway, here's a good place to get started in the wiki.