DEV Community

# Crypto Profits Tracker (feat. Notion API) using Python

TnvMadhav⚡ on July 04, 2021

Crypto Boom of early '21 A crackle involving cryptocurrencies took off late 2020, and early 2021 saw a portion of it go mainstream. C...

Read full post

Ben Blaine • Oct 9 '21

I got an error

Traceback (most recent call last):
  File "/notion-crypto-integration-main/read.py", line 102, in <module>
    MyIntegration().UpdateIndefinitely()
  File "/notion-crypto-integration-main/read.py", line 20, in __init__
    self.getDatabaseId()
  File "/notion-crypto-integration-main/read.py", line 31, in getDatabaseId
    self.my_variables_map["DATABASE_ID"] = response.json()["results"][0]["id"]
KeyError: 'results'

TnvMadhav⚡ • Oct 10 '21

Hello Ben,

I can help you out!

Can we connect on twitter DMs? That way we can resolve things without bloating public threads

Ben Blaine • Oct 10 '21

Please do @benjiblaine

Ben Blaine • Oct 12 '21

Thanks for the help @tnvmadhav ! It's working now.

I simply forgot to remove the "<" and ">" in the my_variables.yml file 🤦‍♂️

TnvMadhav⚡ • Oct 15 '21

😄 Thank you for stating the solution to this problem Ben!

👍🏻 This will surely help others as well.

PS: I have also updated the post regarding the same.

Jane Doe • Sep 10 '21 • Edited

I got up to the last step and ran the python.3 read.py (I'm on mac) and received an index error: list index out of range

Any suggestions to get around this one?

Thank you!

TnvMadhav⚡ • Sep 12 '21

Apologies for the delayed response.

Sure. I would love to help. Can we take this to twitter DMs if you don't mind?

zaxkiller • Sep 17 '21

Got the same error, any suggestion?

Thank you!!

pierre fortin • Oct 14 '21

Got the same error

IndexError: list index out of range

Any ideas?

TnvMadhav⚡ • Oct 15 '21

Hi Pierre Fortin,

Can we take this to twitter DMs if you don't mind?

...that way we can prevent this public thread from bloating up!

pierre fortin • Oct 20 '21

Sure, but there's no option to DM you on Twitter though.

TnvMadhav⚡ • Oct 22 '21 • Edited

Hey Pierre Fortin,

Apologies for the delayed response.

Could you follow me on Twitter? and maybe when I follow you back, we could initiate DM!

Comment hidden by post author - thread only accessible via permalink

GioDsiyow • Sep 22 '21 • Edited

Hi! awesome what you could accomplish with a bit of python. I have the same problem as the first guy though--the script won't run, returning

KeyError: 'results'

this means that results don't exist right?

Robin Playe 🌐 • Aug 26 '21

Can't get this to work for the life of me. Could use a video tutorial

TnvMadhav⚡ • Aug 26 '21 • Edited

Thank you for your feedback! I will definitely improve on the setup instructions for my future products!

But for the time being, would you mind sharing where exactly you are stuck at?

Comment hidden by post author - thread only accessible via permalink

Robin Playe 🌐 • Aug 26 '21

I followed the instructions, but it's just not working for me. I'm able to download the zip file, launch the first python command, modify one of the file with my secret key and launch the final command, but my Notion page never updated with the API after that.

Note that I have no experience with Python, so I am following the instructions with minimal knowledge of what everything does.

TnvMadhav⚡ • Aug 26 '21 • Edited

Don't worry! Python is an incredible language and you would get better and better as you proactively try to find your weak spots and improve :)

I have a couple of questions:

Have you added any crypto currencies to your dashboard table under the 'Name' Attribute? If you haven't I would recommend adding a test coin first
Do you see any errors when you run python script?

Robin Playe 🌐 • Aug 26 '21

No at first, Yes later. Got the same result both times
I did it again from the beginning, here is the last block of text I get when I launch the last command "Traceback (most recent call last): File "C:\Users\linka\OneDrive\Documents\Backend\Notion\Python\Crypto Wallet\Binance\python3-notion-crypto-dashboard-bundle\read.py", line 102, in MyIntegration().UpdateIndefinitely() File "C:\Users\linka\OneDrive\Documents\Backend\Notion\Python\Crypto Wallet\Binance\python3-notion-crypto-dashboard-bundle\read.py", line 20, in init self.getDatabaseId() File "C:\Users\linka\OneDrive\Documents\Backend\Notion\Python\Crypto Wallet\Binance\python3-notion-crypto-dashboard-bundle\read.py", line 31, in getDatabaseId self.my_variables_map["DATABASE_ID"] = response.json()["results"][0]["id"] KeyError: 'results'"

TnvMadhav⚡ • Aug 26 '21 • Edited

Thank you for informing. I will be de listing the product for now and try to reproduce this.

I will get back to you soon.

Edit:
I am not able to reproduce this.

BTW, what is the output of print(response.json()) in the method getDatabaseId() ?

Can we take this in twitter dms?

Edit:
Issue is fixed ✅

Robin Playe 🌐 • Aug 26 '21

Sure! I'm not sure what your last question means but i followed you on twittter

Victor Delaune • Sep 21 '21 • Edited

Hey Madhav, thanks a lot for your work! What a useful tool.

Small question: how can I get the price in Euro € instead of USD $ ?

I track all my crypto investments in euro and it would be a big pain to change everything...

EDIT: I managed changing USDT to EUR in 51th line of the read.py code.

TnvMadhav⚡ • Sep 27 '21

Sorry, for being late.

Did it work out?

Jame Kane • Jan 14 '22

Traceback (most recent call last):
File "read.py", line 102, in
MyIntegration().UpdateIndefinitely()
File "read.py", line 21, in init
self.getNotionDatabaseEntities()
File "read.py", line 42, in getNotionDatabaseEntities
self.my_variables_map["NOTION_ENTRIES"].update({v["properties"]["Name"]["title"][0]["text"]["content"]: {"page": v["id"], "price": float(v["properties"]["Price/Coin"]["number"])}})
IndexError: list index out of range

I got this error

Leo Feroces • Jul 21 '23

I got the same error as @benjiblaine

Traceback (most recent call last):
  File "/Users/jeanduporte/Downloads/notion-crypto-integration-main/read.py", line 102, in <module>
    MyIntegration().UpdateIndefinitely()
  File "/Users/jeanduporte/Downloads/notion-crypto-integration-main/read.py", line 20, in __init__
    self.getDatabaseId()
  File "/Users/jeanduporte/Downloads/notion-crypto-integration-main/read.py", line 31, in getDatabaseId
    self.my_variables_map["DATABASE_ID"] = response.json()["results"][0]["id"]
IndexError: list index out of range

Any ideas?

Leo Feroces • Jul 21 '23

I did not forget to remove <>

AnesGroup • Nov 3 '21

i got an error

TnvMadhav⚡ • Nov 6 '21 • Edited

Hello,

I would love to help you out.

Can we connect using Twitter DMs so that this thread isn't bloated with minute details?

AnesGroup • Nov 6 '21

Sure @anesgroup on Twitter.
Thank you.

Comment hidden by post author - thread only accessible via permalink

TheShadowGit • Aug 27 '21

Hey Madhav, Thanks for the guide. I have imported your repository to my github. Now where do i edit and run the python file ? will it be on my desktop ? I just want to know because that will mean, I will have to always remember to run this script before looking at my tracker in notion ? is that how it is supposed to be ?

TnvMadhav⚡ • Aug 29 '21

Hey there,

Apologies for the delayed response!

Now where do i edit and run the python file ?

You just have to paste your notion integration secret token into the my_variables.yml file and run your python script!

I just want to know because that will mean, I will have to always remember to run this script before looking at my tracker in notion ? is that how it is supposed to be ?

Yes, as long as the script is running, the crypto data will be fetched and the notion database will be updated automatically!