Overview
The list page that contains the Change logs.
|
Endpoint name |
|
|
Source table in Wisefish |
|
|
Fixed view |
Can return all entries in the table. |
|
Editable |
No data modification possible. |
|
Procedures |
There are no procedures on this endpoint. |
|
Primary key of table |
the field “Entry No.” is the primary key. It is a BigInteger. |
Data
Field List
|
Property |
Type |
Table Field |
Field Type |
Note |
|
|
string uuid |
SystemId |
GUID |
|
|
|
Integer |
Integer |
Integer |
|
|
|
string |
|
Text[30] |
|
|
|
string |
|
Text[100] |
|
|
|
string |
|
Text[30] |
|
|
|
string |
|
Text[100] |
|
|
|
string |
|
Text[30] |
|
|
|
string |
|
Text[100] |
|
|
|
string |
|
Text[30] |
|
|
|
string |
|
Text[100] |
|
|
|
string |
|
Text[30] |
|
|
|
string |
|
Text[100] |
|
|
|
string |
|
Text[30] |
|
|
|
integer |
|
integer |
|
|
|
string |
|
Option |
|
|
|
string |
SystemModifiedBy |
Text[50] |
Username of the user that performed the action (but note, the username is in a format like this
|
|
|
date-time utc |
SystemModifiedAt |
DateTime |
Note: The name of this field in business central is “systemmodifedAt” and it can be seen in page inspection in the user interface. |
Example
The idea behind this endpoint is to enable external systems to get notified if a record is deleted in Wisefish.
User in Wisefish can turn this logging on, by going to Wisefish Setup Configuration, and turn on logging for various tables.
-
i.e. all those switches shown above can be turned on individually, and in some sence it might be pointed out that it does not do any harm to have them all on.
-
Examples of usage is shown here on the right, i.e. this logs that a record has been deleted in the following tables.
-
If Item Changelog active = true → delete of item is logged. "tableName": "Item".
-
If Item Translation Changelog active = true → delete of “Item Translation” is logged. "tableName": "Item Translation".
-
If External Item Changelog active = true → delete of “WiFi External Item” is logged. "tableName": "WiFi External Item No.". (Note, Insert to this table is also logged, see field "typeOfChange": "Insert" in examples).
-
If External Item Label Selection Changelog active = true → delete of “External Item Label Selection” is logged. "tableName": "External Item No.".
(Note, Insert to this table is also logged, see field "typeOfChange": "Insert" in examples). -
If Production Agreement Changelog active = true → delete of “Production Agreement” and “Production Agreement Line” is logged. "tableName": "
WiFi Production Agreement" and"WiFi Production Agreement Line". -
If Sales Agreement Changelog active = true → delete of “Sales Agreement” and “Sales Agreement Line” is logged. "tableName": "
WiFi Sales Agreement Header" and"WiFi Sales Agreement Line". -
If Lot Changelog active = true → delete of lot is logged. "tableName": "Lot".
-
If Processing Method Changelog active = true → delete of Processing Method is logged. "tableName": "
”WiFi Processing Method". -
If RM Official report Changelog active = true → delete of RM official reporting logged. "tableName": ”
WiFi RM - Official Reporting". -
If “Item Unit of Measure Changelog active = true → delete of item unit of measure logged. “tableName”: “
Item Unit of Measure"
"value": [
{
"@odata.etag": "W/\"JzE5OzI0MjIyMjkwOTc4MzcxNjA0OTUxOzAwOyc=\"",
"systemId": "d1adbb07-3cba-f011-bbd1-7ced8d254de3",
"dateTime": "2025-11-05T11:39:04.9Z",
"entryNo": 18960,
"pk1FieldName": "Item_No_",
"pk1FieldValue": "DAME0010015028300",
"pk2FieldName": "Variant_Code",
"pk2FieldValue": "ENUTEST",
"pk3FieldName": "Language_Code",
"pk3FieldValue": "ENU",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "Item Translation",
"tableNo": 30,
"typeOfChange": "Delete",
"systemModifiedBy": "422e93ae-ed78-4ee6-90d4-c21a60343e81",
"lastModified": "2025-11-05T11:39:04.913Z"
},
{
"@odata.etag": "W/\"JzE5OzQ5NjE4ODQ4MDkxNTcxNTY3NTQxOzAwOyc=\"",
"systemId": "6e59910b-01bb-f011-bbd1-7ced8d254de3",
"dateTime": "2025-11-06T11:09:24.007Z",
"entryNo": 18961,
"pk1FieldName": "Type_of_Ext_Party",
"pk1FieldValue": "Country",
"pk2FieldName": "External_Party_Code",
"pk2FieldValue": "AW",
"pk3FieldName": "Ext_Item_No_",
"pk3FieldValue": "BITER ARUBA",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "WiFi External Item No.",
"tableNo": 10004867,
"typeOfChange": "Insert",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-06T11:09:24.01Z"
},
{
"@odata.etag": "W/\"JzE5OzczNDEwNTI4MjgzOTUxODg2ODcxOzAwOyc=\"",
"systemId": "53031cf2-d1b0-f011-bbd0-6045bdc6a9ce",
"dateTime": "2025-10-24T12:07:01.52Z",
"entryNo": 18959,
"pk1FieldName": "Type_of_Ext_Party",
"pk1FieldValue": "Customer",
"pk2FieldName": "External_Party_Code",
"pk2FieldValue": "80010",
"pk3FieldName": "Ext_Item_No_",
"pk3FieldValue": "DAME 1",
"pk4FieldName": "Ship_to_Code",
"pk4FieldValue": "1",
"pk5FieldName": "Stock_Center_Code",
"pk5FieldValue": "",
"tableName": "WiFi Ext. Item Label Selection",
"tableNo": 10004876,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-10-24T12:07:01.52Z"
},
{
"@odata.etag": "W/\"JzIwOzE3NDUyNjU0MzU0NTM0ODg2NzE0MTswMDsn\"",
"systemId": "3b105fd4-d1b0-f011-bbd0-6045bdc6a9ce",
"dateTime": "2025-10-24T12:06:14.887Z",
"entryNo": 18958,
"pk1FieldName": "Type_of_Ext_Party",
"pk1FieldValue": "Country",
"pk2FieldName": "External_Party_Code",
"pk2FieldValue": "FI",
"pk3FieldName": "Ext_Item_No_",
"pk3FieldValue": "DAME00100150101",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "WiFi External Item No.",
"tableNo": 10004867,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-10-24T12:06:14.887Z"
},
{
"@odata.etag": "W/\"JzIwOzE0NTI3MjQzNTI4NDUxODU2NTk4MTswMDsn\"",
"systemId": "fe8aa688-d1bf-f011-bbd1-7ced8d254de3",
"dateTime": "2025-11-12T14:11:54.583Z",
"entryNo": 18964,
"pk1FieldName": "No_",
"pk1FieldValue": "PA10000002",
"pk2FieldName": "",
"pk2FieldValue": "",
"pk3FieldName": "",
"pk3FieldValue": "",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "WiFi Production Agreement",
"tableNo": 10005303,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-12T14:11:54.583Z"
},
{
"@odata.etag": "W/\"JzE5OzI2NzE0NDMyNjkyMjY2MDYwNDgxOzAwOyc=\"",
"systemId": "fd8aa688-d1bf-f011-bbd1-7ced8d254de3",
"dateTime": "2025-11-12T14:11:54.573Z",
"entryNo": 18963,
"pk1FieldName": "Prod_Agreement_No_",
"pk1FieldValue": "PA10000002",
"pk2FieldName": "Line_No_",
"pk2FieldValue": "20000",
"pk3FieldName": "",
"pk3FieldValue": "",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "WiFi Production Agreement Line",
"tableNo": 10005304,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-12T14:11:54.573Z"
},
{
"@odata.etag": "W/\"JzIwOzE1NDQ3Mjc0MDY5NTU1MTg0NzYzMTswMDsn\"",
"systemId": "770d9d88-d2bf-f011-bbd1-7ced8d254de3",
"dateTime": "2025-11-12T14:19:03.763Z",
"entryNo": 18967,
"pk1FieldName": "Document_Type",
"pk1FieldValue": "Delivery",
"pk2FieldName": "No_",
"pk2FieldValue": "SA10004873",
"pk3FieldName": "",
"pk3FieldValue": "",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "WiFi Sales Agreement Header",
"tableNo": 10005300,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-12T14:19:03.763Z"
},
{
"@odata.etag": "W/\"JzE4OzcxMDU0NzUyMTk3OTQxNjA5NTE7MDA7Jw==\"",
"systemId": "760d9d88-d2bf-f011-bbd1-7ced8d254de3",
"dateTime": "2025-11-12T14:19:01.733Z",
"entryNo": 18966,
"pk1FieldName": "Document_Type",
"pk1FieldValue": "Delivery",
"pk2FieldName": "Document_No_",
"pk2FieldValue": "SA10004873",
"pk3FieldName": "Line_No_",
"pk3FieldValue": "20000",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "WiFi Sales Agreement Line",
"tableNo": 10005301,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-12T14:19:01.733Z"
},
{
"@odata.etag": "W/\"JzIwOzE4MzEzNTU4NzgyOTg3ODUxMDQwMTswMDsn\"",
"systemId": "002249d8-d2bf-f011-bbd1-7ced8d254de3",
"dateTime": "2025-11-12T14:21:24.093Z",
"entryNo": 18968,
"pk1FieldName": "Code",
"pk1FieldValue": "102206",
"pk2FieldName": "",
"pk2FieldValue": "",
"pk3FieldName": "",
"pk3FieldValue": "",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "WiFi RM - Official Reporting",
"tableNo": 10005052,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-12T14:21:24.093Z"
},
{
"@odata.etag": "W/\"JzIwOzEzNTcxNTU3Mjk3NTg5NzY1NDAxMTswMDsn\"",
"systemId": "461d325f-d3bf-f011-bbd1-7ced8d254de3",
"dateTime": "2025-11-12T14:25:01.467Z",
"entryNo": 18969,
"pk1FieldName": "Code",
"pk1FieldValue": "MY LOT",
"pk2FieldName": "",
"pk2FieldValue": "",
"pk3FieldName": "",
"pk3FieldValue": "",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "WiFi Lot",
"tableNo": 10004504,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-12T14:25:01.467Z"
},
{
"@odata.etag": "W/\"JzIwOzE3OTYxOTcyNTMxNTkxMjY0NDQ4MTswMDsn\"",
"systemId": "c1fccf0d-d4bf-f011-bbd1-7ced8d254de3",
"dateTime": "2025-11-12T14:29:56.533Z",
"entryNo": 18971,
"pk1FieldName": "Item_No_",
"pk1FieldValue": "BITER",
"pk2FieldName": "Variant_Code",
"pk2FieldValue": "",
"pk3FieldName": "Language_Code",
"pk3FieldValue": "LAT",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "Item Translation",
"tableNo": 30,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-12T14:29:56.533Z"
},
{
"@odata.etag": "W/\"JzE4OzU3MzUyMzg4NDMyNTgyODc0NTE7MDA7Jw==\"",
"systemId": "9feea2ff-0dc6-f011-bbd1-7c1e5288834e",
"dateTime": "2025-11-20T12:39:48.43Z",
"entryNo": 19206,
"pk1FieldName": "Item_No_",
"pk1FieldValue": "BITER",
"pk2FieldName": "Code",
"pk2FieldValue": "BLOKK 1/1",
"pk3FieldName": "",
"pk3FieldValue": "",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "Item Unit of Measure",
"tableNo": 5404,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-20T12:39:48.43Z"
},
{
"@odata.etag": "W/\"JzIwOzE3OTI3OTQ5NTAwNTgyMjQ3ODk0MTswMDsn\"",
"systemId": "c019fac3-0bc6-f011-bbd1-7c1e5288834e",
"dateTime": "2025-11-20T12:23:49.9Z",
"entryNo": 19201,
"pk1FieldName": "No_",
"pk1FieldValue": "BITTER-SWEET",
"pk2FieldName": "",
"pk2FieldValue": "",
"pk3FieldName": "",
"pk3FieldValue": "",
"pk4FieldName": "",
"pk4FieldValue": "",
"pk5FieldName": "",
"pk5FieldValue": "",
"tableName": "Item",
"tableNo": 27,
"typeOfChange": "Delete",
"systemModifiedBy": "cf3fb5f8-43bf-4015-8ab6-1ff87579760e",
"lastModified": "2025-11-20T12:23:49.9Z"
}