---
title: "DeleteLog"
slug: "deletelog"
updated: 2026-03-04T11:07:46Z
published: 2026-03-04T11:07:46Z
canonical: "docs.safran.com/deletelog"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.safran.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DeleteLog

## DeleteLog

### /v1/deletelog

Retrieves delete log details.

### Example for calling:

http://server/v1/deletelog?entity=activities&key1=100026 - Retrieves delete log for the activities entity with network id = 100026. http://server/v1/deletelog?entity=activities&meta_updated_prior=2022-01-04T07:28:00.000&key1=100026 - Retrieves delete log for the activities entity which was deleted prior given date and time.

### Allowed Methods:

[GET] API Controller: **DeleteLog**

### Description:

Retrieves the delete log details for specified entity and date span.

In some situations, a record may have been modified using an SQL UPDATE. These changes are not captured in the delete log. However, if an update was implemented using a DELETE followed by an INSERT, this operation will be logged as a deletion.

The endpoint is designed to exclude such update‑via‑delete cases from its result set. As a result, the endpoint only returns records that were actually deleted, ensuring the output is limited to genuine deletion events.

### Request Fields:

| Name | Type | Description | Notes |
| --- | --- | --- | --- |
| entity | string | The name of the entity to get delete log records for | [Mandatory] Typically the target database table name |
| key1 | integer | First primary Key | [Mandatory] |
| key2 | string | Second primary Key | [Optional] |
| key3 | string | Third primary Key | [Optional] |
| key4 | string | Forth primary Key | [Optional] |
| meta_updated_prior | string | Datetime in ISO-8601 format, using UTC time zone | [Optional], Get records prior this date time |
| meta_updated_after | string | Datetime in ISO-8601 format, using UTC time zone | [Optional], Get records after this date time |

- Supports the tables listed in the [Primary Key Mapping](/v1/docs/deletelog#primary-key-mapping).
- The delete log consist of 1 or up to 4 primary keys.

#### Primary Key Mapping

The usage of the "Primary Key X" depends upon the "Table Name". Here is the usage and their meanings. If a "Primary Key" is left empty it is unused for that table name.

| Entity | Key 1 | Key 2 | Key 3 | Key 4 |
| --- | --- | --- | --- | --- |
| activities | Network ID | The ID of the Activity (seq) |  |  |

### Response Fields

#### deletelog

| **Name** | **Type** | **Description** | **Notes** |
| --- | --- | --- | --- |
| entity | string | Name of the entity related to the delete log entry. |  |
| key1 | integer | Primary key for the record in the entity |  |
| key2 | string | Primary key for the record in the entity |  |
| key3 | string | Primary key for the record in the entity |  |
| key4 | string | Primary key for the record in the entity |  |
| item_guid | Guid | Guid of the deleted record in the table name |  |
| lastupdatedutc | string | Datetime in ISO-8601 format, using UTC time zone | **When** the delete took place |
| hostname | string |  | Name of the host **where** the delete took place |
| username | string |  | Name of the user **who** performed the delete |
| application | string |  | Name of the application **used** to performed the delete |

**Sample JSON Response**

    
    

json result

```
[
    {
        "tablename": "ACTIVITIES",
        "primarykey1": 100026,
        "primarykey2": "100006",
        "primarykey3": "",
        "primarykey4": "",
        "lastupdatedutc": "2026-02-05T08:40:55.207",
        "item_guid": "00000000-0000-0000-0000-000000000000",
        "hostname": "MyComputer",
        "username": "SAFRANSA",
        "application": "Safran Project"
    },
    {
        "tablename": "ACTIVITIES",
        "primarykey1": 100026,
        "primarykey2": "100006",
        "primarykey3": "",
        "primarykey4": "",
        "lastupdatedutc": "2026-02-05T11:33:24.797",
        "item_guid": "00000000-0000-0000-0000-000000000000",
        "hostname": "MyComputer",
        "username": "SAFRANSA",
        "application": "Safran Project"
    }
]
```