You are here:
Find How Many Records of a Specific Type Synced Successfully
Determine how many records of a specific file type (for example, HTML, PDF, and images) were ingested.
Use this procedure to count the number of files that were ingested based on the file type. This is helpful to use when youget reports that images are not ingesting and you want to track the number of image files that are ingested.
- From App Launcher, select Data Cloud.
-
Open the Data Streams tab, open the relevant data stream, and copy the data stream Object API Name, for example:
SffWeb-Crawler__dll. - Open the Query Editor tab, and create a new query. Get familiar with the Query Editor to understand how to create queries.
-
For your new query, use the following format examples.
- HTML Pages:
SELECT COUNT(*) FROM "<your_Object_API_Name>" WHERE "ContentType__c" = 'html' -
PDF Files:
SELECT COUNT(*) FROM "<your Object API Name>" WHERE "ContentType__c" = application/'pdf' -
Image Files:
SELECT COUNT(*) FROM "<your Object API Name>" WHERE "ContentType__c" = 'image/png'
- HTML Pages:

