91 results found

1. 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 not defined'. If I change that to be DOMDoccument60 it compiles, but the following statement fails silently. The call to LoadXML does return an object, but the following call to SelectSingleNode fails silently. Nohting is returned to ContactsResultUrl. It remains an empty string.

   Dim contactsRequestDoc As DOMDocument
   Set contactsRequestDoc = LoadXml(url)
   ContactsResultUrl = contactsRequestDoc.SelectSingleNode("/ApiResponse/ResultUrl")
   

   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… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  API  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. 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 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Team 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

3. 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 attached.

   PS: You may also to check out the article linked on the second line of the log file, in case you weren't already aware of the issue with your site certificate.

   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… more

   • 

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Work in progress  ·  Team Mobile responded

   An 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.

4. 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, filter), token)[0];
   Logger.log(query);
   var resultID = query.Resultid
   Logger.log(resultID);

   sheet.getRange('A2').setValue(contacts.FirstName);
   sheet.getRange('B2').setValue(contacts.LastName);
   sheet.getRange('C2').setValue(contacts.Address);
   sheet.getRange('D2').setValue(contacts.City);
   sheet.getRange('E2').setValue(contacts.State);
   sheet.getRange('F2').setValue(contacts.Zip);
   sheet.getRange('G2').setValue(contacts.RenewalDate);
   sheet.getRange('H2').setValue(contacts.ExpireDate);

   }

   Having a hard time getting it to work. Any help would be apprciated.

   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,… more

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. 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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. 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 registrations

   Also I cannot see how the schedule for email announcements and reminders for an Event can be set via the API?

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   3 comments  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Team 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}

7. 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 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Dmitry Smirnov responded

   Could you please elaborate what kind of automation you would like to see?

8. 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 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Team 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.

9. 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 that our officers can quickly download members in their regions. I see on the Fields tab where I can turn on and off particular fields, but I don't see how I can narrow down the search of a field. (Example: Field Name = Region, search and pull only results for Pacific Northwest).

   I now that once I run the full database I can sort by anything that I want, but I was hoping there would be a way that I could run a report for specific criteria making it quicker and a smaller file.

   Like I said, I am sure that my questions verified that I do not know what I am doing! But any help would be greatly appreciated.

   Thank you.

   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… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  API  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   Team 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.

10. 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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. 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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  API  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close