Is the tiny URL stored in any of the confluence DB Schema?

[Ruth Truong]

I've been looking for the tiny URL in the conflurence DB Schema. There doesnt seem to be a place where this is store other then on the pages itself?

[David Peterson · Accepted solution]

The Tiny URL is generated based on the page/blog post's unique ID. You can access it via the com.atlassian.confluence.pages.TinyURL class. Eg:

AbstractPage pageOrBlogPost = findPage(...);
TinyUrl tinyUrl = new TinyURL( pageOrBlogPost );
String url = confluenceContextPath + "/x/" + tinyUrl.getIdentifier();

You'll need to get the context path from elsewhere, possibly the ContextPathHolder or ApplicationProperties which you can inject into your code.

Hope that helps!