How can we make it easier for you to develop on top of Wild Apricot?

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.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AlexSirota shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    4 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • AlexSirota commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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.

      • AlexSirota commented  ·   ·  Flag as inappropriate

        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

        "<apikey> "

        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.

      • AlexSirota commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base