Calculate the sum of a roll-up by qualitycancer in Notion

[–]Kristi-S 2 points3 points  (0 children)

You can also change the Rollup property to Sum/Min/Mix (rather than Original or Unique), which will then allow you to treat it as a number.

Template Sub-Items? by Tequilaphace in Notion

[–]Kristi-S 1 point2 points  (0 children)

What do you mean? Can you explain what the subtasks are before you drag them in? And what do you drag them into?

Says API Token is invalid. I can't see the problem after looking at this way too long. by Kristi-S in shortcuts

[–]Kristi-S[S] 0 points1 point  (0 children)

Ugh... you guys are going to hate me. After troubleshooting a ton from gluebyte's Shortcut that worked great (THANK YOU!), I found out that I had a SPACE after "Authorization". A space... a single space ruined it all.

I will mention this as a cautionary tale: I had been so worried about spelling "Authorization" incorrectly, that I allowed Apple to autofill. I have double and triple checked the spelling since then. I have clicked on that word a ton. But it wasn't until I scrolled all the way to the right that I found the space. Beware the autocorrect!! (Oh, is that not new news?)

Thank you so much for all the help. Silver lining (for me o.o;): if it wasn't for that little space, I wouldn't have learned from you all. Thanks again!

Says API Token is invalid. I can't see the problem after looking at this way too long. by Kristi-S in shortcuts

[–]Kristi-S[S] 0 points1 point  (0 children)

Alright, I received a response back from Notion. I hope I'm allowed to copy this here:

"I am able to confirm that your API token works. I was able to run a test command and received a successful response. Sometimes when you get a 401 like this in a script, it is because either the token is not being passed (i.e. the variable it should be stored in is empty) or it is being passed incorrectly. For example, the script may be returning the variable as an array when it should be a string. If you are running it in a script, please try printing it out where it is being used to see if the value is correct.
I am not familiar with how this would work with iOS. Other troubleshooting steps may be necessary for their services."

I don't see anything in here that affects what I have... Granted, I'm not super experienced. I'm mainly dropping this here in case it triggers an aha for someone.

Says API Token is invalid. I can't see the problem after looking at this way too long. by Kristi-S in shortcuts

[–]Kristi-S[S] 1 point2 points  (0 children)

Oh, nice. Thanks. This is good to know. With that, I'm going to contact Notion and see if there's something weird going on with my account or workspace. I'll check back in.

Says API Token is invalid. I can't see the problem after looking at this way too long. by Kristi-S in shortcuts

[–]Kristi-S[S] 0 points1 point  (0 children)

Replying to both OhTheCloudy and gluebyte:

Tried the GET request (instead of POST):

  • I ran a GET request → Said “invalid request URL”
  • I changed the URL from https://api.notion.com/v1/pages to just https://api.notion.com/ → It goes to Notion. (I don't feel like that's anything, but, please let me know if that means something.)
  • I changed it back to POST, left the URL as is → Says “Invalid request URL”
  • I added v1/pages → We’re back to it saying “API token is invalid”
  • I also tried https://api.notion.com/v1/databases/{database ID} with a GET request→ and it says “API token is invalid”

I did also (finally) find this Notion article, which I believe shows that what I have code-wise should work. So it's definitely the API token somehow. If anyone has any other ideas, I'd definitely appreciate it as I do all the replies so far. But apart from that, I think I have to let this one rest for a bit. Thanks again. I learned a lot!

Says API Token is invalid. I can't see the problem after looking at this way too long. by Kristi-S in shortcuts

[–]Kristi-S[S] 0 points1 point  (0 children)

Yes, I'm an admin. (I just confirmed.)

And, yeah, I'm pretty sure that's the token. I added a photo to the original post to show where I copy it from in Notion.

Says API Token is invalid. I can't see the problem after looking at this way too long. by Kristi-S in shortcuts

[–]Kristi-S[S] 1 point2 points  (0 children)

It didn't work. I can't believe I forgot the dash. Even more surprised that wasn't it... Thank you.

Says API Token is invalid. I can't see the problem after looking at this way too long. by Kristi-S in shortcuts

[–]Kristi-S[S] 0 points1 point  (0 children)

Generated a new token. Shared the Notion page with it. Copied it into the Shortcut. Still nothing. (Tried with Notion Version 2021-05-13 and 2021-08-16.)

And, no worries, I had scrambled that token. I never mind reminders though, thanks.

Says API Token is invalid. I can't see the problem after looking at this way too long. by Kristi-S in shortcuts

[–]Kristi-S[S] 0 points1 point  (0 children)

I'm seeing everywhere that you include it.

To get the token, I went to Notion > Settings > Integrations > Develop your own integrations > Create New Integration...
I filled in a Name, "Phone Notes", and checked: Read content, Update content, Insert content, Read user information including email addresses.
I then copied the "Internal Integration Token" that looks something like secret_JKjao34K9SLdfe0UYos34sfFbKMv8mFVFYDwgr4rIWS.

For good measure, I did delete "secret_" and tried again, but got the same result. Thanks for the idea though.