Locating Date Added and Date Last Changed Fields for Constituency Codes in RE NXT Nigtly Backup

Venky Immadisetty · October 1

I have a question regarding specific fields in the RE NXT nightly backup file. I am looking for the following information related to constituency codes:

Date Added

Date Last Changed

When examining the CONSTITUENT_CODES table in the schema, I do not see these fields listed.

However, when I look at the SKY API response, the data includes "date added" and "date modified" for each constituency code record.

https://api.sky.blackbaud.com/constituent/v1/constituents/constituentcodes/{constituent_code_id}

Is there another location or table in the backup file where I might find these date fields outside of the CONSTITUENT_CODES table? Appreciate any guidance on where these fields are stored in the backup data.

Is it possible to get the data like who added the constituency code and who last changed it?

Thank you!

Alex Wong · October 3

I do not believe what you are asking for is available in the nightly backup. with RE NXT webview, there are new functionalities and/or data point that is webview only, and those are recorded elsewhere.

I think @Ben Wong can confirm what I said is true or not.

as for who created the constituent code and last changed it, there's no easy way to do this. You can register a webhook to trigger a webapp (created by you via Power Automate or other web programming technology) whenever a constituent code is added or changed. However, the webhook does not provide info on who trigger the adding/changing of the constituent code. However, given how RE NXT works, whenever a constituent code is add/change/deleted, a constituent change is triggered too. So you can register a constituent change webhook to try to capture that info ( constituent change webhook provides who caused the change). However, not easy, b/c constituent change can be any change, so you will have to isolate the change that is related to the constituent code change.

CAN be done, BUT not easy

Alex Wong · October 3

Oh, one more thing that you are not going to like (b/c I didn't)

date/time of constituent code change is not targeted at the specific code. For example, if a constituent have Code A, Code B on the record. If you add a Code C today, the date/time created for Code C is today. the date/time of date modified is today. HOWEVER, the date/time of date modified for Code A and Code B is ALSO updated to today even though NO change was made to Code A and Code B.

You can test this out and see. it sucks

Venky Immadisetty · October 7

@Alex Wong
Thank you!

Locating Date Added and Date Last Changed Fields for Constituency Codes in RE NXT Nigtly Backup

Best Answer

Answers

Categories