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.
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