SaaS CMS has officially launched! Learn more now.

Getting friendly URL from SQL query

Vote:
 

Hello!

Is there any good way of imitating the UrlRewrite implementation with a regular SQL query? See when you look in tblContentLanguage, it only contains LinkURL which is basically just /link/hash. Can you get the friendly URL by query in any good/reliable way? The only obvious thing I've seen so far is to build it by URLSegment from parents + child as well as the LanguageId (becomes e.g. /en/parent/parent/child).

My reason for doing this is simply because I'm trying to read the full tree structure with all page information through an SQL connection in python, the project is not allowed to use any EPiServer dependency - so I can't just make the python app call a C# app which uses EPiServer's API.

I'm thankful for suggestions,

Richard

#171536
Edited, Nov 09, 2016 20:26
Vote:
 

Hi Richard

The easiest way I can think off my head is to make your own RESTful API in your episerver project, so you can call the API from your python app. 

#171541
Nov 10, 2016 7:39
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.