Retrieve Knowledge Articles that Link to a Topic created in your Site

Step 1: Find the Network ID for Your Experience Cloud Site

1. Launch Data Loader and click Export.
2. Log in to your user.
3. Select Show all Salesforce objects.
4. Select Network (Network) and choose a location for the export file.
5. Click Next.
6. Under "Choose the query fields below", select ID and Name.
7. Click Finish and then Yes.
8. Click View Extraction and then Open in external program.
9. Copy the ID for the impacted site. This is your Network ID.

Step 2: Use the Network ID to Retrieve Topic IDs from Your Site

1. Click Export and Show all Salesforce objects again.
2. Choose Topic (Topic) and a file location.
3. Under "Choose the query fields below", select ID, Name, and Network ID.
4. Under "Create the where clause to your query below", enter: Fields = NetworkID, Operation = equals, Value = the Network ID captured in Step 1.
5. Click Add Condition.
6. The query should resemble: SELECT Id, Name, NetworkId FROM Topic WHERE NetworkId = '0DB1a000000Gn1yGAC'
7. Click Finish and then Yes.
8. Click View Extraction and then Open in external program. This file contains all Topics for your site.

Step 3: Use the Topic ID to Find Knowledge Article Version IDs

1. Click Export and Show all Salesforce objects again.
2. Choose Knowledge Article Version (KnowledgeArticleVersion) and a file location.
3. In the generated query box, enter the following SOQL (Salesforce Object Query Language) query: SELECT Title, ArticleNumber, UrlName, Id, KnowledgeArticleId FROM KnowledgeArticleVersion WHERE Language = 'en_US' AND PublishStatus = 'Online' AND Id in (SELECT EntityId FROM TopicAssignment WHERE TopicId = 'YourTopicID')
4. Replace YourTopicID with the ID found in Step 2.
5. Click Finish and then Yes.
6. Click View Extraction and then Open in external program.

The resulting file lists all Knowledge Article Versions associated with the specified Topic.