Connecting an Excel Sheet to Asana using PAT

Community Forum English Developers & API
,
1

Hello,

I’m trying to connect an excel sheet so that ever row generates a task when information is added to that row. I think I’m pretty close however my PAT keeps generating with a “:” in the middle of it (example: XXXXX:XXXXX) and I think this is what is causing the error as it doesn’t seem to be connecting with my actual Asana project.

Does anyone have any advice as to how to generate the PAT without the “:”?

Thanks!

Please read this before posting

  • If you received an error from the API that you’re looking for help with, please include the error in your post and be descriptive of the requests you made that received the errors. To be clear, we need the error in the JSON response from the API, not the error your code raised.
  • Do not share any API credentials. Please check that the code you’re pasting into the post does not contain any real OAuth tokens or personal access tokens. If you have exposed credentials, you should revoke them immediately.
2

Hi @Natasha_Teixeira,

I’m afraid it’s not possible; a PAT will always have that colon in it as it’s comprised of two parts that are separated by the colon.

What tool or technology are you using to do the connection? The colon shouldn’t be an issue in general.

3

Hi @Phil_Seeman

I’m trying to code (JAVA) in Google Extensions so that my excel sheet auto connects with my Asana project and generates a task per each row.

Basically, I’m trying to get around the lack of auto filling columns so that the ID codes we generate in Excel transfer over to Asana without having to copy/paste.

4

I’m not familiar with Google Extensions but if you’re doing the authentication in Java, I don’t know why a colon would be causing the problem. What issue are you having specifically and how have you narrowed it down to the comma as being the root cause?

Also, there’s an official Asana Java client library; are you using that, or could you? That would handle the auth for you. Or maybe you can at least look at the source code for the library and do the auth exactly as they’re doing it to avoid any issues.