coinbase error

[cafrit00]

Hello

thanks for this fantastic work , I have copied API key and secret key and have press F8 (run macro), I get an error msg "type miss match"
on Step 1: "Raw JSON data" is shown the following error :

{"error_nr":-2147483638,"error_txt":"The data necessary to complete this operation is not yet available.
","response_txt":0}

I don't understand why
to me is also not clear, do I have to do something else apart from entering API KEY and SECRET KEY ??

do you have a guide document ?

I just want to get my cryptocurrencies from my account.

thanks for your support.

Regards
Carlos

[krijnsent]

Hi Carlos,

if step 1 fails that means that the main issues is in ModWeb and has nothing to do with your authentication as that's only used in step 4. (Basically: the tests in that sheet build up from a simple raw reply to an authenticated processed one.). Somehow your connection to Coinbase doesn't resolve quickly, so it fails.
You could try to use the alternative method: go to WebRequestURL (in ModWeb) and uncomment 'Set objHTTP = CreateObject("MSXML2.XMLHTTP") and outcomment the 3 active lines above that. For me the CoinBase sheet works with my credentials, so I can't really reproduce your error :-(.

There is no real guide document, the main documentation is in the readme in this Github combined with the comments I put in the code.

In concept, the code works as follows for every exchange:

• from the sheet, mainly the PublicExchangeName & PrivateExchange functions are called (both placed in ModExchExchangeName). As the name suggests, Public is the public part of the API (no credentials needed) and Private the private part (with credentials).
• those functions in turn do some stuff, mainly building up the right API call info and are supported by a couple of blocks:
  -- ModJson & JsonConverter to process Json info
  -- ModWeb (function: WebRequestURL ) to send out information to the web call & receive a reply (raw JSON)
  -- sometimes ModHash for signing a request

Hope that helps, otherwise use F8 to step through the code and see where it crashes/goes to the wrong side of an IF statement.
Koen