# Deleted Reporting Balance Row Track

**URL:** <https://community.cdata.com/t/deleted-reporting-balance-row-track/901>\
**Category:** CData Connect AI\
**Tags:** question, cdata-connect-ai, cdata-sync\
**Created:** [September 11, 2024, 3:18pm UTC](https://community.cdata.com/t/deleted-reporting-balance-row-track/901 "2024-09-11T15:18:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![muthuEOL](https://avatars.discourse-cdn.com/v4/letter/m/cc9497/32.png) [@muthuEOL](https://community.cdata.com/u/muthuEOL)\
**Post date:** [September 11, 2024, 3:18pm UTC](https://community.cdata.com/t/deleted-reporting-balance-row-track/901/1 "2024-09-11T15:18:00Z")

</div>

How to track which reporting balance row is deleted? because I am syncing record through Power automate. I am not able to track which row is deleted in reporting balance. if i get to know about that transaction I will sync that particular row related records again

I am using cdata connect ai

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [September 18, 2024, 8:19pm UTC](https://community.cdata.com/t/deleted-reporting-balance-row-track/901/2 "2024-09-18T20:19:29Z")

</div>

@muthuEOL ,

Since this question is related to the other inquiry&nbsp;you have raised in your other [post](https://community.cdata.com/cdata-connect-cloud-46/reason-for-id-change-in-reporting-balance-1087)&nbsp;and this is an issue related to Connect AI, I am answering here.

While we do have a way to cache the results of a table/view and in a way have a method to track changes between the cached data and the new data the source is furnishing in some of our products, this would&nbsp;still&nbsp; not be possible for your use case as in order to support this scenario the table/view will need to have a timestamp column (i.e ModifiedDate, UpdatedAt, etc..) and the ReportingBalance ([CData JDBC Driver for Exact Online - ReportingBalance](https://cdn.cdata.com/help/DYK/jdbc/pg_table-reportingbalance.htm)) view does not expose such a column.

To provide more context, the timestamp column can be used as an ‘IncrementalCheckColumn’ and this way we can&nbsp;track&nbsp;what changed by making use of the ability that the connectors have to get incremental changes based on the timestamp columns and thus having a “History Mode” option. We do have a similar option in our Sync product and it would also be possible to add this in Connect AI as well if there is enough customer interest in such a functionality. However, as stated above this would only be possible for tables/views that support a timestamp column. That being said, we don’t have a way to assist you with what you are trying to do.

I also did search a bit around to see if there is a way to accomplish this in Power Automate directly but they seem to suggest the same that in order to track if a record has been modified you would still need a column referred to as ‘rowversion’ which in most cases is a timestamp column. You might want to take a look at the following resources to learn more:

[Create a Cloud Automated Flow which Triggers when the conditions meet using When an item is modified (V2)(SQL) in Power Automate. | by Siva\_M | Medium](https://medium.com/@doctorlemon23/create-a-cloud-automated-flow-which-triggers-when-the-conditions-meet-using-when-an-item-is-7e4e675d3ecc)

[“Understanding the “When an Item is Modified (v2)” Trigger” (linkedin.com)](https://www.linkedin.com/pulse/understanding-when-item-modified-v2-trigger-lokesh-singara-npjtf)

Hope this helps.