Get reports on Salesforce

The reports that provide data on Salesforce

Backup Activity Report

View the status and details of the backup activities of configured Salesforce instances.

URL

https://apis.druva.com/platform/reporting/v1/reports/sfdcBackupActivityReport

Request type

HTTP POST

Sample cURL request

curl --location --request POST 'https://apis.druva.com/platform/reporting/v1/reports/sfdcBackupActivity' \
--header 'Content-Type: application/json' \
--header 'accept: application/json' \
--data-raw '
{
  "filters": {
    "pageSize": 100,
    "filterBy": [
      {
        "fieldName": "salesforceUser",
        "operator": "EQUAL",
        "value": "sfdc2_sanity sfdc2_sanity"
      },
      {
        "fieldName": "backupType",
        "operator": "EQUAL",
        "value": "Full"
      }
    ]
  },
  "pageToken": ""
}

To try out this API, refer API reference.

πŸ“˜

Note

On the API reference page, select sfdcBackupActivity as the report ID under path params to test this API endpoint.

Sample responses

{
    "data": [
        {
            "backupType": "Ful",
            "completedTime": null,
            "definitionName": "source001_definition_2023_07_19_00_29_3",
            "endTime": "2023-07-18T19:07:23.986Z",
            "organizationID": "00D1100000C9ysvEA",
            "organizationName": "source001",
            "projectName": "test Project",
            "salesforceUser": "sfdc2_sanity sfdc2_sanity",
            "startTime": null,
            "status": "Completed",
            "statusDetails": null,
            "totalBackupSize": 2200
        },
        {
            "backupType": "Full",
            "completedTime": null,
            "definitionName": "source001_definition_2022_05_29_00_43_5",
            "endTime": "2022-05-28T19:16:17.087Z",
            "organizationID": "00D1100000C9ysvEAB",
            "organizationName": "source001",
            "projectName": "test Project",
            "salesforceUser": "sfdc2_sanity sfdc2_sanity",
            "startTime": null,
            "status": "Complete",
            "statusDetail": null,
            "totalBackupSize": 2200
        } ],
    "filters": {
        "pageSize": 100,
        "filterBy": [
            {
                "fieldName": "salesforceUser",
                "value": "sfdc2_sanity sfdc2_sanity",
                "operator": "EQUA"
            },
            {
                "fieldName": "backupType",
                "value": "Full",
                "operator": "EQUA"
            }
        ]
    },
    "lastSyncTimestamp": "2025-01-28T06:23:46Z",
    "nextPageToken": "ZGE4ZWYwYzctNDEwZi00MTVjLWJhNzgtMTFiYzQzMzA2ODMy"
}
FiledTableDescription
backupTypestringBackup type of activity. Example - Incremental, Full
completedTimedate-timeBackup job completion time. The time is in the UTC zone. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
definitionNamestringThe name of the backup definition to which the activity belongs
endTimedate-timeEnd time in UTC format until record changes captured in each backup job must be identified. Example: For Jan 29, 2025 10 PM: 2025-01-29T22:00:00Z
organizationIDstringSalesforce organization ID
projectNamestringThe name of the project to which the activity belongs
salesforceUserstringThe name of the salesforce user who initiated the activity
startTimedate-timeStart time in UTC format from where record changes captured in each backup job needs to be identified. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
organizationNamestringThe name of the salesforce organization to which the activity belongs
statusstringBackup job status of the activity
statusDetailsstringError details if any
totalBackupSizeintegerTotal backup data size of the activity in bytes
filtersobjectFilters applied on the report
nextPageTokenstringThe token to access the next page of results. This parameter will be empty for the last page of the results. This token is valid for 5 minutes
{
  "code": "string",
  "data": {
    "additionalProp": {}
  },
  "message": "string",
  "retryable": true
}
FieldTypeDescription
codestringError code
dataobjectData of the error
messagestringError message
retryablebooleanCan retry the API call (true for yes and false for no.)

Data Restore Activity Report

View the status and details of all restore jobs for the configured Salesforce instances.

URL

https://apis.druva.com/platform/reporting/v1/reports/sfdcDataRestoreActivityReport

Request type

HTTP POST

Sample cURL request

"curl --location --request POST 'https://apis.druva.com/platform/reporting/v1/reports/sfdcDataRestoreActivity' \
--header 'Content-Type: application/json' \
--header 'accept: application/json' \
--data-raw '
{
  "filters": {
    "pageSize": 100,
    "filterBy": [
      {
        "fieldName": "salesforceUser",
        "operator": "EQUAL",
        "value": "sfdc2_sanity sfdc2_sanity"
      },
      {
        "fieldName": "dataTemplateName",
        "operator": "EQUAL",
        "value": "DR_TC06_Template"
      }
    ]
  },
  "pageToken":""
}

To try out this API, refer API reference.

πŸ“˜

Note

On the API reference page, select sfdcBackupActivity as the report ID under path params to test this API.

Sample responses

{
    "data": [
        {
            "backupDefinitionName": "DR_TC06_Backup",
            "dataTemplateName": "DR_TC06_Template",
            "destinationOrganization": "source001",
            "endTime": "2024-04-03T12:26:46.311Z",
            "isDeleted": null,
            "projectName": "DataRestoreRegression",
            "recordsRestored": 10,
            "restoreState": "Completed",
            "salesforceUser": "sfdc2_sanity sfdc2_sanity",
            "snapshotTimestamp": "2024-04-03T12:25:29.983Z",
            "startTime": "2024-04-03T12:26:43.594Z",
            "statusDetails": "",
            "totalRecordCount": 10
        },
        {
            "backupDefinitionName": "DR_TC06_Backup",
            "dataTemplateName": "DR_TC06_Template",
            "destinationOrganization": "source001",
            "endTime": "2024-06-10T17:50:39.904Z",
            "isDeleted": null,
            "projectName": "DataRestoreRegression",
            "recordsRestored": 10,
            "restoreState": "Completed",
            "salesforceUser": "sfdc2_sanity sfdc2_sanity",
            "snapshotTimestamp": "2024-06-10T17:49:35.096Z",
            "startTime": "2024-06-10T17:50:36.424Z",
            "statusDetails": "",
            "totalRecordCount": 10
        }, ],
    "filters": {
        "pageSize": 100,
        "filterBy": [
            {
                "fieldName": "salesforceUser",
                "value": "sfdc2_sanity sfdc2_sanity",
                "operator": "EQUAL"
            },
            {
                "fieldName": "dataTemplateName",
                "value": "DR_TC06_Template",
                "operator": "EQUAL"
            }
        ]
    },
    "lastSyncTimestamp": "2025-01-28T09:20:01Z",
    "nextPageToken":""
}
FiledTableDescription
dataTemplateNamestringData template name of the Activity
isDeletedintegerFlag to filter out deleted data template
salesforceUserstringThe name of the salesforce user who has initiated the activity
projectNamestringThe name of the project to which the activity belongs
restoreStatestringRestore the status of the activity
startTimedate-timeStart time of the data restore task. The time is in the UTC zone. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
endTimedate-timeEnd time of the data restore task. The time is in the UTC zone. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
totalRecordCountintegerThe total number of records identified for restore as part of the activity
recordsRestoredintegerCount of the records restored as part of the activity
destinationOrganizationstringThe Name of the destination organization selected for restore as part of the activity.
statusDetailsstringError details if any
backupDefinitionNamestringThe name of the backup definition from which data is being restored
snapshotTimestampdate-timeBackup snapshot timestamp. The time is in the UTC zone. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
filtersobjectFilters applied on the report
nextPageTokenstringThe token to access the next page of results. This parameter will be empty for the last page of the results. This token is valid for 5 minutes
{
  "code": "string",
  "data": {
    "additionalProp": {}
  },
  "message": "string",
  "retryable": true
}
FieldTypeDescription
codestringError code
dataobjectData of the error
messagestringError message
retryablebooleanCan retry the API call (true for yes and false for no.)

Archival Activity Report

View the details of all the data Archival activities for configured Salesforce instances.

URL

https://apis.druva.com/platform/reporting/v1/reports/sfdcArchivalActivityReport

Request type

HTTP POST

Sample cURL request

"curl --location --request POST 'https://apis.druva.com/platform/reporting/v1/reports/sfdcArchivalActivity' \
--header 'Content-Type: application/json' \
--header 'accept: application/json' \
--data-raw '
{
  "filters": {
    "pageSize": 100,
    "filterBy": [
      {
        "fieldName": "salesforceUser",
        "operator": "EQUAL",
        "value": "sfdc2_sanity sfdc2_sanity"
      }
    ]
  },
  "pageToken": ""
}

To try out this API, refer API reference.

πŸ“˜

Note

On the API reference page, select sfdcArchivalActivity as the report ID under path params to test this API.

Sample responses

{
    "data": [
        {
            "archivalSetName": "source001 archival_set_2024_08_27_00_59_59",
            "endTime": "2024-08-26T19:30:25.000Z",
            "fileSize": 0,
            "organizationID": "00D1100000C9ysvEAB",
            "organizationName": "source001",
            "projectName": "My First Project",
            "salesforceUser": "sfdc2_sanity sfdc2_sanity",
            "startTime": "2024-08-26T19:30:16.000Z",
            "status": "Completed",
            "statusDetails": null,
            "totalRecords": 100
        },
        {
            "archivalSetName": "source001 archival_set_2024_08_27_01_02_06",
            "endTime": "2024-08-26T19:32:31.000Z",
            "fileSize": 0,
            "organizationID": "00D1100000C9ysvEAB",
            "organizationName": "source001",
            "projectName": "My First Project",
            "salesforceUser": "sfdc2_sanity sfdc2_sanity",
            "startTime": "2024-08-26T19:32:21.000Z",
            "status": "Completed",
            "statusDetails": null,
           "totalRecords": 30
        }, ],
    "filters": {
        "pageSize": 100,
        "filterBy": [
            {
                "fieldName": "salesforceUser",
                "value": "sfdc2_sanity sfdc2_sanity",
                "operator"": "EQUAL"
            }
        ]
    },
    "lastSyncTimestamp": "2025-01-28T09:29:30Z",
    "nextPageToken": "NGVhY2I4M2YtZjA2Ni00NmFjLWFmYWYtN2E3YTkwNTI5NDNl"
}
FiledTableDescription
startTimedate-timeStart Time of the archival task. The time is in the UTC zone. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
endTimedate-timeEnd Time of the archival task. The time is in the UTC zone. Example: For Jan 28, 2025, 10 PM: 2025-01-28T22:00:00Z
statusstringArchival status of the activity
totalRecordsintegerCount of records archived as part of the activity
archivalSetNamestringThe name of the archival definition set to which the activity belongs
salesforceUserstringThe name of the salesforce user who has initiated the activity
projectNamestringThe name of the project to which the activity belongs
organizationIDstringSalesforce organization ID
organizationNamestringThe name of the salesforce organization to which the activity belongs
statusDetailsstringError details if any
fileSizeintegerTotal size(in KB) of all archived object files of the activity.
filtersobjectFilters applied on the report
nextPageTokenstringThe token to access the next page of results. This parameter will be empty for the last page of the results. This token is valid for 5 minutes
{
  "code": "string",
  "data": {
    "additionalProp": {}
  },
  "message": "string",
  "retryable": true
}
FieldTypeDescription
codestringError code
dataobjectData of the error
messagestringError message
retryablebooleanCan retry the API call (true for yes and false for no.)

Archival Restore Activity Report

View the details of Archival restore activities of configured Salesforce instances.

URL

https://apis.druva.com/platform/reporting/v1/reports/sfdcArchivalRestoreActivityReport

Request type

HTTP POST

Sample cURL request

"curl --location --request POST 'https://apis.druva.com/platform/reporting/v1/reports/sfdcArchivalRestoreActivity' \
--header 'Content-Type: application/json' \
--header 'accept: application/json' \
--data-raw '
{
  "filters": {
    "pageSize": 100,
    "filterBy": [
      {
        "fieldName": "salesforceUser",
        "operator": "EQUAL",
        "value": "sfdc2_sanity sfdc2_sanity"
      }
    ]
  },
  "pageToken": ""
}

To try out this API, refer API reference.

πŸ“˜

Note

On the API reference page, select sfdcArchivalRestoreActivity as the report ID under path params to test this API.

Sample responses

{
    "data": [
        {
            "archivalSetName": "source001 archival_set_2024_06_11_14_53_02",
            "dataTemplateName": "archival_restore_templatedhr5kuv0ao",
            "destinationOrganization": "source001",
            "endTime": "2024-06-11T09:24:37.000Z",
            "projectName": "My First Project",
            "recordsRestored": 100,
            "restoreState": "Completed",
            "salesforceUser": "sfdc2_sanity sfdc2_sanity",
            "startTime": "2024-06-11T09:24:33.000Z",
            "statusDetails": null,
            "totalRecordCount": 100
        },
        {
            "archivalSetName": "source001 archival_set_2024_06_11_15_04_16",
            "dataTemplateName": "archival_restore_templatemck9jykarp",
            "destinationOrganization": "source001",
            "endTime": "2024-06-11T09:35:55.000Z",
            "projectName": "My First Project",
            "recordsRestored": 20,
            "restoreState": "Completed",
            "salesforceUser": "sfdc2_sanity sfdc2_sanity",
            "startTime": "2024-06-11T09:35:50.000Z",
            "statusDetails": null,
            "totalRecordCount": 20
        }, ],
    "filters": {
        "pageSize": 100,
        "filterBy": [
            {
                "fieldName":"salesforceUser",
                "value": "sfdc2_sanity sfdc2_sanity",
                "operator": "EQUAL"
            }
        ]
    },
    "lastSyncTimestamp": "2025-01-28T09:31:26Z",
    "nextPageToken": ""
}	
FiledTableDescription
dataTemplateNamestringData template name of the Activity
salesforceUserstringThe name of the salesforce user who has initiated the activity
projectNamestringThe name of the project to which the activity belongs
restoreStatestringRestore status of the activity
startTimedate-timeStart Time of the archival restore task. The time is in the UTC zone. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
endTimedate-timeEnd Time of the archival restore task. The time is in the UTC zone. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
totalRecordCountintegerThe total number of records identified for archival restore as part of the activity
recordRestoredintegerCount of the records restored as part of the activity
destinationOrganizationstringThe name of the destination organization selected for archival restore as part of the activity
statusDetailsstringError details if any
archivalSetNamestringThe name of the archival definition set to which the activity belongs
filtersobjectFilters applied on the report
nextPageTokenstringThe token to access the next page of results. This parameter will be empty for the last page of the results. This token is valid for 5 minutes
{
  "code": "string",
  "data": {
    "additionalProp": {}
  },
  "message": "string",
  "retryable": true
}
FieldTypeDescription
codestringError code
dataobjectData of the error
messagestringError message
retryablebooleanCan retry the API call (true for yes and false for no.)

Sandbox Seeding Activity Report

View the status and details of Sandbox Seeding and Data copy activities of configured Salesforce instances.

URL

https://apis.druva.com/platform/reporting/v1/reports/sfdcSandboxSeedingActivityReport

Request type

HTTP POST

Sample cURL request

"curl --location --request POST 'https://apis.druva.com/platform/reporting/v1/reports/sfdcSandboxSeedingActivity' \
--header 'Content-Type: application/json' \
--header 'accept: application/json' \
--data-raw '
{
  "filters": {
    "pageSize": 100,
    "filterBy": [
      {
        "fieldName": "salesforceUser",
        "operator": "EQUAL",
        "value": "sfdc2_sanity sfdc2_sanity"
      }
    ]
  },
  "pageToken": ""
}	

To try out this API, refer API reference.

πŸ“˜

Note

On the API reference page, select sfdcSandboxSeedingActivityReport as the report ID under path params to test this API.

Sample responses

FiledTableDescription
dataTemplateNamestringData template name of the Activity
salesforceUserstringThe name of the salesforce user who has initiated the activity
projectNamestringThe name of the project to which the activity belongs
taskStatestringTask status of the activity
startTimedate-timeStart Time of the data copy task. The time is in the UTC zone. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
endTimedate-timeEnd Time of the data copy task. The time is in the UTC zone. Example: For Jan 28, 2025 10 PM: 2025-01-28T22:00:00Z
totalRecordCountintegerThe total number of records identified for data copy as part of the activity
recordRestoredintegerCount of the records restored as part of the activity
destinationOrganizationstringThe name of the source organization selected for data copy as part of the activity
statusDetailsstringError details if any
filtersobjectFilters applied to the report
nextPageTokenstringThe token to access the next page of results. This parameter will be empty for the last page of the results. This token is valid for 5 minutes
{
  "code": "string",
  "data": {
    "additionalProp": {}
  },
  "message": "string",
  "retryable": true
}
FieldTypeDescription
codestringError code
dataobjectData of the error
messagestringError message
retryablebooleanCan retry the API call (true for yes and false for no.)