Developers
Mostly about Wild Apricot API. Feel free to share examples of your code!
91 results found
-
Provide a working example using XML and Access 2016
I am converting an existing (working) application based on the excel example provided by Wild Apricot to work with Access instead of Excel. All I need from the API is to download a list of members. I've found that the Excel code does not work with Access. I've found many workarounds on various VBA boards, but I'm stymied at the final step of actually downloading the XML for the membership roster.
These three lines of code from the LoadContacts sub are the problem. The dim statement does not compile in Access. The error is that the 'user defined type is…
1 vote -
Single Sign On Very simple Ruby on Rails snippet
Hello,
I have been able to implement bare bones Wild Apricot single sign on steps in a blank Ruby on Rails project, thanks to Wild Apricot support! Please find attached a redacted and commented version of the code here for anyone who is trying to do similar with their own custom web app. This snippet prints out the ID of the user who is signed in.
Cheers!2 votesTeam Mobile responded
Great, thank you for contribution.
We put copy of attached file to API samples on github:
https://github.com/WildApricot/ApiSamples/blob/master/RubyOnRails/SSO/application_controller.rb -
Event registration types created via API cannot be edited in the web interface
It is no longer possible to edit an event registration type in the web UI if it was created via an API call. Attempting to load these registration types causes Uncaught Error: Invalid cancellationBehavior to be thrown in the console and the page spins forever without loading.
Unfortunately due to the asinine piecemeal implementation of the API it is only possible to set this field through the web interface. See the issue? Yet another reason why you should use your own dang API; you could catch these issues before they break your customers' workflow and piss them off.
Console log…
1 voteAn ability to setup cancellation options will be added to the API in the next release – approximately at the end of the month. It’ll fix this issue also.
Currently, we fixed all broken registration types (the cancellation option was set to “not allow”) but unfortunately new ones will be created with the same problem for now.
-
Monthly list of new users
I am attempting to create a google doc for our Printing/Mail vendor to easy grab info on the members that renwed or signed up in the last 30 days. The idea is the vendor would just open this share google doc once a month, run the report, export the data.
I am using your example from: https://github.com/WildApricot/ApiSamples/tree/master/GoogleScript
function getCardData(){
Logger.clear();var ui = SpreadsheetApp.getUi();
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var urls = urlBuilder();var token = getToken(ui, urls.getAuthServiceUrl());
var accountId = getDataFromApi(urls.getAccountsListUrl(), token)[0].Id;
var filter = '\'Renewal date last changed\' ge 2017-10-01 AND \'Mebership Status\' eq Active'
var query = getDataFromApi(urls.getCardDataUrl(accountId,…4 votes -
How can I sync WA API and Azure Active Directory?
We are looking at using WA with Office 365 to collaborate with our members. Office 365 uses the Azure AD environment which accepts most setups. My question is how we could export WA member data to Azure AD as 'B2B external partners' or, better yet, native AD accounts.
1 vote -
Event creation via API cannot set all fields
I am creating Events using the API and cannot see how the following fields can be set (I can set these as an Administrator in the website) .....
Show registrants who want to be listed
to everyone
to members only
Include pending registrationsAlso I cannot see how the schedule for email announcements and reminders for an Event can be set via the API?
2 votesTeam Mobile responded
Status update in case someone new will see this topic:
The section “Show registrants who want to be listed” have been added to API already.Schedule for email announcements and reminders can’t be set via API at the moment.
As a workaround, you could create a template event on the web, set the start date in the distant future and all settings you need. Then you can clone it via POST request:
api.wildapricot.org/v2/rpc{AccountId}/CloneEvent
The request body should be like this:
{“EventId”: 123456} -
Facebook at Work will be released soon and provides API access to manage login credentials. Is there any way to automate this process?
Facebook at Work will be released soon and provides API access to manage login credentials. Is there any way to automate this process?
https://developers.facebook.com/docs/facebook-at-work/provisioning/overview
1 voteDmitry Smirnov responded
Could you please elaborate what kind of automation you would like to see?
-
Sample Excel File for API Connect to WA Make Available for Excel for MAC [14851]
It seems that the Sample Excel file for importing data from Wild Apricot was developed in Excel for WIndows. The Import Data macro does not compile because of a Missing:Microsoft XML,v3.0 reference. This XML object is only available in Excel for Windows.
Wild Apricot states that it will not be supporting this Excel file at all. That leaves out all MAC users.
I have not been able to find any suggestions on line on how to run this Macro or replace the XML object.
1 voteTeam Mobile responded
The Excel file is just an example of API usage and anyone is free to take it and change in a way you want it to be.
-
Extend functionality of sample Excel file
I will start this post off by saying that I am not a designer or coder, and that will probably be evident by my questions!
I love the new contact record API and using the supplied Excel file I was able to pull our membership database.
My question is this: Is it possible to set up the file to pull just members from a specific region or state and not the entire pool of members? The file for the full membership was around 6mb and took several minutes to run. I'd like to be able to narrow the query so…
1 voteTeam Mobile responded
The Excel file is just an example of API usage and anyone is free to take it and change in a way you want it to be.
-
VBA example of doing updates via API v2
Does anyone have an example of doing updates via the new API version 2 in VBA? I was successfully able to make the PHP code work, but now want to do updates from an Access database.
0 votes -
Member Directory Not Updating
So, the member directory is no longer updating:
https://www.biawc.com/membership/member-directory/
I found what the original developer scripted but I'm guessing there is a new version of the API. Can anyone assist me in rewriting the script to get the member directory to update?
Thanks!
0 votes
- Don't see your idea?