A question on the Excel spreadsheet made available 6 months ago by Wild Apricot at https://github.com/WildApricot/ApiSamples/tree/master/Exc
A question on the Excel spreadsheet made available 6 months ago by Wild Apricot at https://github.com/WildApricot/ApiSamples/tree/master/Excel
I am having a problem with authentication. I put in the API key from authorized applications via copy/paste so I know it's right. Then I clicked download data and tried both the client ID/secret key and my admin username and password. Both times I get this error. I went through the VBA code a bit to review if I may be doing something wrong, but I don't see anything wrong.
Client is not authorized to use this grant type is an error I cannot find anything on in the API v2. Sort of befuddled, as this is the same thing that's done through PHP and that works great with the same API key.
Yes it is working - make sure you have the API under Site>Security>Authorized Applications setup. Make sure also there is no extra space at the end of the key.
Jaye Steinbrick commented
Is yours working? Every time I try to export data from this Excel file I receive "Something goes wrong: Invalid procedure call or argument. I know it's connecting because if I enter a false API Key it then says I'm not authorized.
I figured it out. Copying and pasting from the UI in a browser includes a trailing space as part of the copy and paste.
It looks like it's not capturing anythigng else but in fact the string is
note the extra space at the end. Excel was capturing the extra space. I'll put in some code to ensure there's no spaces in the API key before it is passed into the rest of the VBA. All good.
Also when I try to login with my regular admin credentials I get a different error error:Unauthorized.
I have to be doing something simple wrong. BTW this is a trial account I am using as a partner.