API - installation instructions

Please can someone help me out.  I want to install the api so i can use it in excel for a spreadsheet i want to develop but I can't find clear, easy to follow instruction on how to install it.

I've asked on other forums, but their responses are too technical to understand and say to install it, but they never say where to install it and other details I can't follow.

Please help me

Roz

Please stop creating identical threads. Your previous post was not answered, because when you say “install the Numista API into Excel” it's clear that you have no idea what are you talking about. First read more what is API. Then learn some programming language. Only then you will be able to “use Numista API to integrate website's data into Excel”.

Despite years of trying to learn, and a collection of learning difficulties, I cannot wrap my head around what to do.  which is why I posted here asking for help

So, while it might be clear to most.  To me this “programme” language might as well be written in Greek or Russian or something.  Nowhere have I found clear enough instruction in clear English that go step by step where to enter the information so i can get the results at the end.  Most site i have looked at for help and advice it just says to enter a certain line of text - but nowhere does it say where it has to be entered.

So don't assume people can understand things that might be obvious to you

For what do you even need the API for your excel document?

The problem is that an API is just an interface for a program to communicate with a server/other program, it's not a ready backed thing you can install like a normal program or add-on. Without you being able to speak any “Greek or Russian” the API access will be nearly useless to you.

Maybe some popular public data aggregation APIs can be relatively easily implemented into Excel but even then you have to adjust code in Excel itself to get any use out of those … there are no clear instruction for every use case.

As previously said, an API is intended for usage by computer programmers, not directly by users.

I'm still puzzled by your needs for communicating with Numista inside Excel. Are you interested in keeping an Excel spreadsheet synchronized with Numista servers, so that changing the spreadsheets sends an update to Numista, and updating your collection on Numista updates your spreadsheet?

If so, I guess that a competent computer programmer, with a good amount of time and trial-and-error, could do that with a RealTimeData server API or something like this (I'm not so sure because I've never programmed custom Excel features). Doing that would require a lot of hard work (and should be constantly maintained, so that changes in Numista's spreadsheets exports don't break nothing), either by the Numista team or volunteers.

I want/need a something that can work between numista and a spreadsheet i am creating to track my coin collection and ensure they both share some infomation with each other.

I have tried some different apps and software and none work for me.  I have for years and years to try and learn code, but my dyspraxic brain can't ‘get it’

Is there something wrong with using the Numista generated spreadsheet of your collection?

It's all the editing and moving of information i have to do after i've downloaded to fit the spreadsheet i'm using

If you have to adhere to your old sheet design then create a macro that does what you do all the time to a new Numista export. Faaaaaar easier then learning how to implement an use an API.

The API is not clear at all.. I was able to authenticate, but when I call a get method the response is: [error_message] => User authentication invalid or missing  after the previous call gives me The user #347256 is authenticated for 7776000 days.

rodrigo.gpt

The API is not clear at all.. I was able to authenticate, but when I call a get method the response is: [error_message] => User authentication invalid or missing  after the previous call gives me The user #347256 is authenticated for 7776000 days.

Hello,

The API endpoints related to the collections of members require two different authentication headers in your request:

• The header “Numista-API-Key: YOUR_API_KEY” like for any other Numista API endpoints
• The header “Authorization : Bearer YOUR_ACCESS_TOKEN”. The access token should be obtained from the OAuth authentication, and specifying the scope “view_collection” and/or “edit_collection” depending on the intended endpoint.

The error message your received is related to a missing “Authorization” header or an “Authorization” with an invalid access token: either a complete wrong value, an access token obtained for a different user, or a token obtained with insufficient scope.

Note that the access token you received is valid for 7776000 seconds, not 7776000 days.