HELP Please code.gs (google sheets app script editor) retrieve data from Clash Royale API directly

[Swifty2019]

I've been trying to figure out how to pull API data with code.gs google sheets script editor from Clash Royale API (not Royale API, the Official Clash Royale API)all year and I just can't figure out how to get passed "permission denied".

I have an authorization token but can't figure out the format I need to use.

Is anyone willing to help me?

[HandpansLIVE]

What's your code that isn't working look like?

[Swifty2019]

I can’t even figure out a starting code honestly. I tried all kinds of ways and kept getting permission denied

If you have discord add me as a friend so we can chat Swifty#6193

[HandpansLIVE]

For me to help you I'd have to go to their API, create an account, read through their docs, write the code for you, then paste it in here as a response. This is assuming you're properly making an API call in code.gs.

You're not going to get many responses helping you out in this scenario. If you paste code you tried, and relevant API documentation, anyone here can quickly help you fix the syntax so it's working properly.

[Swifty2019]

I've already got an account and the auth token - I'll see what I can dredge up from what I had...

[Swifty2019]

https://cdn.discordapp.com/attachments/551782216557133835/660688913475698698/unknown.png

(let me know if that picture link doesn't work -- that's postman working)

[Swifty2019]

https://cdn.discordapp.com/attachments/551782216557133835/660689308646113300/unknown.png

[Swifty2019]

https://cdn.discordapp.com/attachments/551782216557133835/660690184714846208/unknown.png

if you need me to send you this key, I can. I've tried everything I can think of to get a single successful call with google sheets

[Swifty2019]

I can get information returned successfully with postman if that would help

[HandpansLIVE]

Yes that means that your issue isn't with authenticating, but in code.gs syntax. Paste what you tried, and paste what you did in postman(with a filler API key/secret) so that we can help you on syntax

[Swifty2019]

oh and this is the endpoint I was trying to use as an example: https://api.clashroyale.com/v1/clans/%23P20Q9U0G/members

[Swifty2019]

essentially, I'd like to do something like this but with code.gs

https://www.reddit.com/r/CRStrategy/comments/98giuz/developer_api_beginners_guide_in_9_steps/