Resurfacing this question, but I cannot for the life of me figure out what data tables (using the analytics data source) the imported bank data shows up in. It is not actually in the
That didn't work, but is a very interesting post nonetheless @tdietrich.
m
michoel
10/28/2020, 6:50 AM
You can try using this code snippet to identify the table if it is exposed. Basically it works by counting the number of records in every single table in the account, and then you create a new record and compare table counts to see what changed. https://gist.github.com/michoelchaikin/eaed812f02ecbadb66cd61319682662f
michoel
10/28/2020, 6:51 AM
Example run in my account after creating a new employee
m
Marc Reicher
10/28/2020, 4:53 PM
Also a very cool script. Thanks for the share @michoel. I tried this out. I see that there were some tables that changed when I uploaded new bank transactions, but none of them actually stored the transactions 🤔