Developers

Mostly about Wild Apricot API. Feel free to share examples of your code!

  1. Using API on MS Access 2016

    I extended the excel sample API V2 app to develop an attendance system for our club. For a number of reasons, we're working to move off of Excel and onto Access. The sample code from WA runs smoothly on Excel, but not on Access. The sample includes the following (in function GetOAuthToken)

    Dim httpClient as IXMLHTTPRequest
    Set httpClient = CreateObject("Msxml12.XMLHTTP.3.0")
    httpClient.Open "POST", url, False

    (where url = "https://oauth.wildapricot.org/auth/token")

    The client.open returns 'unauthorized'. I cannot find any documentation on the open method of the httpclient object. And I have no idea what extra authorization I need when working in…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Resolved  ·  3 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  2. "The remote server returned an error: (403) forbidden."

    I am using the sample visual studio c# program you have provided (see attachment). The program is failing in trying to access https://api.wildapricot.org/v2. Version2 is failing with a 403 forbidden error message. Any suggestions how I could solve this issue?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  3. Javascript not executing

    I'm trying to use javascript to hide/empty a span.class on my registration page. When I first type the code in the span empties just as I would assume it would. However once I save the page the javascript no longer executes.

    <script>
    $('span.levelRecurring:contains("No recurring payments")').empty();
    </script>

    Any ideas?

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Resolved  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. I have successfully integrated the WA API into Integromat

    Integromat.com is like Zapier or IFTT but a bit more powerful AND easy to use. I'm added an authorization Connector and two modules for retrieving and filtering Contacts. Using their Slack integration I can now ask for Integromat to calculate a Membership Report and report back to Slack. Next up is a "new member" notification.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  5. API endpoint for allowing users to cancel registrations

    The new feature added today to allow users to cancel their own registrations is a good start, but we need to be able to set it through the API for it to really be useful. Is there a plan to add this in the near future?

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  6. Postman collection

    I previously posted about whether anyone had written a Swagger file for WA API that could be used to connct Microsoft PowerApps to WA. New release of PowerApps supports using a Postman collection instead of a Swagger file. Has anyone built a Postman collection for WA API?

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  7. API calls to update contacts suddenly failing

    We have a Google Apps script that is used to update a custom contact field. This code has been working and unchanged for the past year, and has suddenly lost the ability to update contacts. Other API calls to get contacts, update event registrations, etc. are still working fine, but can't update any contact fields through the API. Attempts to do so result in an HTTP 500 error. We are still able to update contacts through the web interface.

    Relevant information pasted after the break.


    Error:
    [17-09-16 07:31:21:841 CDT] Exception: Request failed for https://api.wildapricot.org/v2/accounts/84576/Contacts/40772038 returned code 500. Truncated server response:…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  8. Swagger

    Has anyone built an OpenAPI (Swagger) file for connecting to WA APIs? I'm trying to make a sign-in kiosk with Microsoft PowerApps and it connects through a JSON OpenAPI definition.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  9. API Upload Pictures

    Hey WA Developers, I'm trying to work through some of the API documentation and I'm hung up on the "Uploading Pictures" documentation.
    https://help.wildapricot.com/display/DOC/Pictures+API+V2+call
    I've got a Google Script constructed to upload an image from Google Drive to my trial WA site and I can't get it to work! 400 response code. Anybody up for taking a look and pointing out what I am doing wrong? Thanks so much!

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Resolved  ·  1 comment  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  10. Contacts/me Returns null

    Hi!
    Using some of the sample code from the GitHub repo I've created a few custom PHP pages for events on a third party site. I'm trying to make the registration functionality work.
    The problem that I'm running into is the Contacts/me API call returns null even with a user logged in. I'm using the format:
    {baseAPIaddress}/{version}/Accounts/{accountID}/Contacts/me

    I am able to run Contact/{ContactID} and get the relevant data back. Do anyone know what might cause this?

    Thanks, Jason.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  11. api events

    I am having trouble adding a new event through the api. I get a 403 error. Here is my google script code if anybody would be so kind as to point out where I have messed up. :) Thanks so much.

    https://gist.github.com/portercar/945c29474fece0e208991ac27f724203

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Resolved  ·  1 comment  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  12. Export members data into Google docs

    How do I export Member data directly into a Google Doc (live)? Step-by-Step for newbies.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  How to  ·  Flag idea as inappropriate…  ·  Admin →

    If you need one time export, just make an export to Excel file (https://help.wildapricot.com/display/DOC/Exporting+members+and+other+contacts) and then upload this file to google drive.

    If you want to do it on regular basis, you could make some automation using google script. We have a sample code in google script (https://github.com/WildApricot/ApiSamples/tree/master/GoogleScript), which could be a good starting point for your project.

  13. daily member data import

    I would like to pick up membership data from a gold database (Adds, edits, deletes) and put into each chapters database (each chapter has a version of WA) - Thanks

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  How to  ·  Flag idea as inappropriate…  ·  Admin →
  14. Use of Event Registration IDs

    I am using the API to determine if members have registered or their registration has been cancelled for an Event.

    At the moment I cannot see any way of knowing that a registration has been cancelled from the API.

    So, I will need to check if the registrations have changed or not since the last time it was checked. This means saving the Event Registration IDs in a file.
    What is the valid range of a Registration ID?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  How to  ·  Flag idea as inappropriate…  ·  Admin →
  15. fieldvalues contact api

    I have an interesting issue you can help me with. I am using the Contacts API and calling it from a Javascript call using the WA API wrapper for jQuery. I got this code from the WA developer forum and loaded it into the files section to call locally from the WA install (rather than from the original location).

    http://iarpreiki.org/resources/js/waPublicApi.js

    I am using the API to create a URL that I will pass to an external SaaS system, so I need to collect various contact/membership field data.

    The testing page is at

    http://iarpreiki.org/Print-Your-Membership-Certificate -- the top HTML widget is where…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Resolved  ·  4 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  16. Profile last updated field differs in filter from value read in API ?

    Hi,
    we have a job that queries via the API searching with a filter on "Profile last updated". The query can return no results, it doesn't find any contacts changed since the last query run. However if we just iterate through the contacts and read the Profile last updated field it can be more recent shown in the API results than displayed in the WA web interface. It appears when reading via the API the "last login date" is used as the Profile last updated date if the last login is newer than the last profile update.

    Summary:
    Profile last…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Resolved  ·  0 comments  ·  How to  ·  Flag idea as inappropriate…  ·  Admin →
  18. Setting a Password when creating a new contact/member

    Hi,

    I need to create a contact through the API through a 3rd party server. I have no problem creating a contact. However, when I set a password and try to login after I have created the contact, I get an error saying that I have the wrong login information.

    Secondly, when someone signs up they get an email with a password sent to them. Is this possible as well through the API? When I create a contact through the API I want to be able to send them the password in their email so they can login.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →

    1. Creating contact

    • Newly generated password should be passed in $postFields instead of “12345678”
    • Method createWAContact should be modified to use a password

    Please see improved version of your code here: https://gist.github.com/DmitriySmirnov/8d65a1417d9ffdfc9efe762fa492bbcc

    2. Sending password
    Currently you can’t send such email using API, however there is a lot of PHP libraries for sending emails.

  19. I need to access the "group participation" data for the current user. Can anybody show me how to access the data?

    I need to access the "group participation" data for the current user. Can anybody show me how to access this data?

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →

    Group participation data can be foubd in the fiels with name ‘Group participation’. For example:

    var contact = getContactById( 123 )
    for( i=0; i<contact.FieldValues.length;i++) {
    var record = contact.FieldValues[i];
    if( record.FieldName == ‘Group participation’)
    var groups = record.Value;
    }

  20. API with non-administrative permissions

    Original title: Cannot access API from within site pages if not Administrator.

    Hi,

    I have written JavaScript/HTML in a WildApricot site page to display events as a compact list in a table.

    If I login to an administrator account it all works fine, if I login to a non administrator account I get error 403 returned from a get Events API call.....

    "Failed to load resource: the server responded with a status of 403 (Current token does not provide access to scope 'events_view'.)"

    Code snippet is:
    <script>

    generateTable();

    function generateTable()
    {

    var EventsList = getDataFromApi(&quot;<a rel="nofollow noreferrer" href="https://xxxxx.wildapricot.org/sys/api/v2/accounts/xxxxxx/Events?$sort=StartDate">https://xxxxx.wildapricot.org/sys/api/v2/accounts/xxxxxx/Events?$sort=StartDate</a> asc&amp;$filter=Tags in
    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    16 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Developers

Categories

Feedback and Knowledge Base