I have data from an external API that needs to be matched with database data in a repeating group. It is currently working for the API call and loads quickly. Im wondering how I could get the uploaded data to smoothly display alongside.
Some background is this is a PFM app that displays the users transactions. The external API pulls transactions from the users bank, and comes back with a lot of data. I am allowing users to upload CSVs of transaction history as an alternative to bank sync, and would like both data types to coexist in the RG.
Wondering how to do this
Currently I save the API call to a custom state list, and display that data. This is in the datatype of the API call. both data sets will have common fields of amount, description, category and date.