Small and medium business | Business Central, N...

API: System Audit Date

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I am developing a custom API to extract vendor and related data using BC 19.1. My API is working fine and I would like to add audit fields such as systemCreatedAt and SystemModifiedAt

I tried adding them using Rec as well xRec but getting compilation error

field(systemCreatedAt; Rec.SystemCreatedAt)

{

Caption = 'SystemCreatedAt';

}

field(systemModifiedAt; Rec.SystemModifiedAt)

{

Caption = 'SystemModifiedAt';

}

compilation failed

src/api/manageVendorAPI.al(92,44):

error AL0132: 'Record Vendor' does not contain a definition for 'SystemCreatedAt' src/api/manageVendorAPI.al(96,45): error AL0132: 'Record Vendor' does not contain a definition for 'SystemModifiedAt'

Any idea what can be the best approach to add field such as SystemCreatedAt and SystemModifiedAt in my APIs (Page Type API)

Thanks

Famy

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: API: System Audit Date

Hi, Stefano is right.

More details:

Data audit system fields are added to every table in Dynamics 365 Business Central 2020 Release Wave 2 (BC17)

https://yzhums.com/1897/

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: API: System Audit Date

Version 16 does not contain these fields. These fields are available starting from BC 17 (October 2020).
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report
RE: API: System Audit Date

I am using version 20.3 and this works fine for me:

Unfortunately i do not have a version 16 to look at.

page 50100 vendapi { APIGroup = 'vendor'; APIPublisher = 'publisherName'; APIVersion = 'v1.0'; Caption = 'vendapi'; DelayedInsert = true; EntityName = 'vendor'; EntitySetName = 'Vendors'; PageType = API; SourceTable = Vendor; layout { area(content) { repeater(General) { field(systemCreatedAt; Rec.SystemCreatedAt) { Caption = 'SystemCreatedAt'; } field(systemCreatedBy; Rec.SystemCreatedBy) { Caption = 'SystemCreatedBy'; } field(systemId; Rec.SystemId) { Caption = 'SystemId'; } field(systemModifiedAt; Rec.SystemModifiedAt) { Caption = 'SystemModifiedAt'; } field(systemModifiedBy; Rec.SystemModifiedBy) { Caption = 'SystemModifiedBy'; } } } } }
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: API: System Audit Date

Maybe you can try to use the lastmodifedat field and see if that works.

I see that is the field MS use in their standard API's.
Community Member Microsoft Employee on at

Like (0)

Report

RE: API: System Audit Date

sorry BC version I am using is 16.5