Skip to content
This repository has been archived by the owner on Feb 2, 2023. It is now read-only.

How to add Api Key header #235

Open
Carlos-OL opened this issue May 13, 2022 · 1 comment
Open

How to add Api Key header #235

Carlos-OL opened this issue May 13, 2022 · 1 comment

Comments

@Carlos-OL
Copy link

Carlos-OL commented May 13, 2022

Hello.
Thank you so much for your code. It has proved to be extremely helpful for so many tasks.
I do have a question though. Which function should I use and how should I add a header to include my API key?

https://docs.opensea.io/reference/asset-listings

I have tried ImportJsonPost but it doesn't seem to work.
The URL in question is:

image

My current formula (not working) is:

=ImportJSONViaPost("https://api.opensea.io/api/v1/asset/0x8EE5DD62A654a60f6F17A99d544102f37B58dA26/256/listings","X-API-KEY=9d1749851941443d97XXXXXXXXX")

Thank you

@Gilles-H
Copy link

Gilles-H commented Sep 8, 2022

Hi Carlos. I was stuck with this too. Not sure if you've sorted it but looks like there are newer projects addressing this. Now using https://github.com/qeet/importjsonapi

=IMPORTJSONAPI("https//...", "$.*", "column1, column2, column3", "headers={'API-key':'mykey'}")

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants