Query Batches of Archived Field History Data

You can query Field Audit Trail entries stored on the FieldHistoryArchive object.

Available in: Lightning Experience

Available in: Enterprise, Performance, and Unlimited Editions with the purchase of Salesforce Shield or Field Audit Trail licenses.

This content relates to Field Audit Trail. Read about implementing field audit trail using Shield Extension in Own from Salesforce.

Note

To return a large number of results, use a URI query.

1/services/data/vXX.X/jobs/query

Here’s an example Post request.

1{
2    "operation": "query",
3    "query": "SELECT ParentId, FieldHistoryType, Field, Id, NewValue, OldValueFROM FieldHistoryArchive WHERE FieldHistoryType = ‘Account’ AND CreatedDate > LAST_MONTH"
4}

For more information about Bulk API queries, read Get Results for a Query Job in the Bulk API 2.0 and Bulk API Developer Guide.

You can also make a CURL request.

1curl --include --request GET \
2--header "Authorization: Bearer token" \
3--header "Accept: text/csv" \
4https://instance.salesforce.com/services/data/vXX.X/jobs/query/750R0000000zxr8IAA/results ?maxRecords=50000

These examples result in a CSV file that you can examine for auditing purposes.

Field Audit Trail Implementation Guide

Query Batches of Archived Field History Data