search

jmsteen / plaid-django-demo

12 stars 1 forks source link

Issue getting Transactions #1

Open dforsyth09 opened 3 years ago

dforsyth09 commented 3 years ago

Hey John. First, thank you so much for uploading this. I've been pulling my hair out with the plaid api for a few days now when I stumbled across your youtube video.

I'm having an issue getting the transactions. The migrations are created. I can get my accounts just fine. When I click the Refresh Transactions link, it calls get_transactions, and I can see the transactions coming through if I add some print statements in the view. But then I get this error and I can't figure out why: "Category matching query does not exist."

I'm not sure if you know why that would happen or where I can start troubleshooting that. Again, thank you for uploading your code. Any help is greatly appreciated

flightoftheconcord commented 3 years ago

I'm running into this same issue. I am able to find and link accounts, but get the "Category matching query does not exist" when I try to refresh transactions, and cannot find where that error is coming from.

amjithtitus09 commented 3 years ago

Hi @dforsyth09 , @flightoftheconcord , the error is coming from "Category.objects.get(pk=transaction['builtin_cat_id'])" present in myfinance/views.py in the get_transactions() method.

The reason is simple, Category table is empty when this get is performed. You can either find a way to populate the Category table using the BuiltinCategories enum, or the drop the builtin_category field from Transaction model as a workaround. Hope this helps :)

mudkipAstronaut commented 1 week ago

you should be able to run python3 manage.py loaddata builtin_categories_data.json to populate the Category table and fix the issue