Experience Cloud: How to Retrieve Asset File Information (ContentDocumentId) Uploaded to a Specific Site Using Data Loader

Please refer to the following steps.

◆ Steps ◆

0. Obtain the Network ID (starting with "0DB") for the target Experience Cloud site.

※Export the Network object using Data Loader or Developer Console beforehand to identify the ID of your target site.

<Example Query to retrieve the ID from the Network object>

SELECT Id FROM Network WHERE Name = 'Target_Site_Name'

1. Export the ContentDocumentLink object.

Add a condition such as LinkedEntityId = 'Target_Network_ID' to export information only for the specific site. 

※Ensure you include the ContentDocumentId field in the exported columns.

2. Export the ContentVersion object.

※Ensure you include the ContentDocumentId field in the exported columns.

3. Cross-reference the data.

Based on the information from Step 1, identify the rows where the ContentDocumentId from the list in Step 1 matches the ContentDocumentId in the list from Step 2.