Get a List of all Content Entities of the Same Content Type in Sitecore Content Hub

-

While working on the Content Hub project I received the requirement to get all the Content Entities of a specific Content Type from the Content Hub.

For instance, if your Content Hub contains various types of content entities such as a Blog, Article, and News type and there are multiple entities of each content type. Here I am taking an example of retrieving all the Content Entities of the Blog type.

get-list-of-entities-1

To get the list of all the content types, you can use Web Client SDK , there is a method to retrieve the single entity using the Get entities method.

Solution:

1. Create a sample console/web application in Visual Studio and add a reference to the Web Client SDK NuGet package (Stylelabs.M.Sdk.WebClient) to your project. 

2. Before beginning to write the logic, you should have the Parent ID of the Content Entities that represent the ID of the Content-Type.

To find the Content Type ID or Parent ID of a content entity from the Content Hub interface, follow these steps:

  • Go to any of the content entities page by using the Search option from the Main Menu in the Content Hub navigation bar get-list-of-entities-2
  • Click on the Content Entity of the desired Content-Type or use the filter from the left side section, this action will open the content entity on a new detail page: get-list-of-entities-3
  • Copy the URL from the browser and update it to get the entity details in JSON format, as below: https://{your-content-hub-instance-url}/api/entities/1516618 To find the parent ID of the content you need to search the ContentTypeToContent relation in this content entity JSON and copy the ID, where 35045 is the Content-Type Id that is Blog Type. get-list-of-entities-4
  • To verify this, copy the URL and paste it into the browser, this action will provide you the list of all children in JSON format: https://{your-content-hub-instance-url}/api/entities/35045 get-list-of-entities-5

3. There are several ways to get the list of entities, I am explaining all here, go to the Class and paste the following snippet of the code as per your requirement:

Option A: if you have the parent ID (Content Type ID) of the content entity:

In the above code, you are searching for content type instead of Asset so the Definition name would be “M.Content”. If you use the same code for Assets then the Definition Name would be “M.Asset” and 35045 is the Blog Type ID.

Option B: If you do not have content Type ID and it can vary on different environments like Staging, UAT, or PROD then:

Option C: Get the list of all the entities of Blog Type using parent-children relation:

Happy Sitecoreing ðŸ˜Š

Comments

Post a Comment

Popular posts from this blog

Sitecore Installation Error: Failed to Start Service 'Sitecore Marketing Automation Engine'

-
Image
 Error: [------- XConnectXP0_StartServices [2] : ManageService -----------------------] [XConnectXP0_StartServices [2]]:[Updating] sc903xconnect.dev.local-MarketingAutomationService Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing ...
Read more

Import CSV Data in Sitecore Using PowerShell: Part-3

-
Image
In my previous blog , we had discussed Sitecore PowerShell Command and Scripts. In this blog, I am discussing with you about How to Import CSV Data in Sitecore using PowerShell Scripts? To do the same you need to read the CSV file rows and create Sitecore Items into the Content Tree for each row then assign the column values of the row into the respective Item Field. There are two options: Write your own customized PowerShell Script and Import CSV Data. Use the inbuilt Data Importer tool that comes with Sitecore PowerShell Extension .  Option 1: Perform the Below steps to Import the CSV Data into Sitecore: First, you will need a CSV file. If you have Excel Sheet, then go to the File Menu and click on Save As option and change the format and save it into CSV format. Suppose you have a CSV file with the number of rows and each row has several columns with predefined values. Here I am taking the below CSV file for an...
Read more

Sitecore : The database principal owns a schema in the database, and cannot be dropped message

-
Image
While upgradation to Sitecore 10.2, I was to restore the database on the Managed Cloud Service Azure SQL Server. I have connected the Azure SQL server on my local SSMS and started to import the Database using the option Import Data-tier Application. While importing the database using the above option you need a BACPAC file instead of a .bak file. So I was to create a BACPAC file of the database from my local. Go to the database, right-click and select the Export Data-tier Application option under the Task menu. After clicking on the next, while creating the BACPAC file you may get the below error: Solution: Go to the Users in that Database. Your Database => Security => Users Find the user, right click and delete it. If you are unable to delete the user and encountered a new error as below: It means the user you are going to delete owns a schema in the database and owners. First, you need to search which schemas own...
Read more