Feature degradation | Gmail Email delivery failure

Set Up and Maintain Your Salesforce Organization

Table of Contents

No results

Here are some search tips

Check the spelling of your keywords.
Use more general search terms.
Select fewer filters to broaden your search.

Search all of Salesforce Help

Set Up and Maintain Your Salesforce Organization

Query Batches of Archived Field History Data

You are here:

Query Batches of Archived Field History Data

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

Required Editions

Available in: Lightning Experience

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

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

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

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

Here’s an example Post request.

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

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.

curl --include --request GET \
--header "Authorization: Bearer token" \
--header "Accept: text/csv" \
https://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.

Did this article solve your issue?

Let us know so we can improve!