Access the DocumentMain Table for building Navigation in Angular.

almost 7 years ago by Parteek Chhabra

Hi ASI,

I am trying to access the following tables/views via REST API to get content and navigation items. But It is not accessible via REST.
How can I get this data via REST API?

The following tables/views are not accessible.

DocumentMain / vBoDocument
vBoNavigationHierarchy / vBoNavigationHierarchyCM

I a trying to build navigation menu in Angular.
How can I get the raw data and decide which navigation items go where?

Also, Is there a way to get the blob data from DocumentMain where DocumentTypeCode='CON'? How can I achieve this one?
The blob data from vBoDocumentStorage is accessible.

Any help would be appreciated.
Thanks.

angular

almost 7 years ago by Molivouth Boulom

Hi Parteek,

To retrieve the listing of folders and files at the root we use the following query:
https://{{URL}}/api/DocumentSummary?Path=$

It should return a list of items such as this one:
{
"$type": "Asi.Soa.Core.DataContracts.DocumentSummaryData, Asi.Contracts",
"Description": "",
"DocumentId": "0f1b7dba-0871-4b0a-8583-444a998d6a63",
"DocumentTypeId": "FOL",
"Name": "Communications",
"Path": "$/Communications",
"Status": "Published"
}

From the "DocumentId" value returned you can then get more details using queries such these:
https://{{URL}}/api/Document/0f1b7dba-0871-4b0a-8583-444a998d6a63
https://{{URL}}/api/DocumentMain/0f1b7dba-0871-4b0a-8583-444a998d6a63

Let me know if that helps.
Cheers.

almost 7 years ago by Parteek Chhabra

Hi Molivouth,

I tested this REST Call, but it only returns the folders/files which are present in the Document System(present in the staff site)
The Document System does not have information on the sitemaps which have DocumentTypeCode='NAV'.

Can you give an example which will return all the sitemaps present in Staff site along with hierarchy?
I want to make it dynamically, so whenever I add some sitemap item, it should be populated automatically, meaning the rest call should return the newly added item without changing the code/rest call.

﻿