112 results found

1. Filtering Account Administrators

   How can I return a list of just account administrators?

   Using the API Browser, I tried both

   $filter=IsAccountAdministrator eq true

   and

   $filter="Administrator role.Id" eq 256

   both return this cryptic error:

   ErrorDetails: "One or more errors occurred."

   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

   2 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

   Submit Rating
   Team Mobile responded

   Filtering of account admihnistrators is not supported yet. If you are not sure that filtering for some field is supported, then you can look at contact field description. ‘Administrator role’ field has flag “SupportSearch”: false. That’s why filtering fails.

   We will implement such filtering in one of future updates.

2. API Event Registrations - Support filters beside list of ID's ?

   Does anyone know if the event registration call supports filters other than the list of ID's mention on the help page.

   Events can be filtered much like contacts but it does not specify for event registrations.

   I want to limit the list of registrations returned for a contact to only those today or later.

   3 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

   Submit Rating
   Team Mobile responded

   It is not possible in current version of API.

3. “AccessLevel” filter for events

   Creating a separate request based on a comment in another one: "Please also add the “AccessLevel” filter for events"

   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

   Submit Rating

4. API v2 Events - AccessLevel and Sorting

   Hi,

   I'm using the API v2 to extract Events for a custom event list in another site. So far, the API is working.

   I can get a list of event objects, but they seem to be in the order in which they were entered, not in the order of their dates! (date order should be the default sort, IMHO) Is there a way I can specify the sort order in the request URL?

   Also, the API returns ALL events regardless of access level: is there a way to restrict the returned set to be just public events?

   Thanks.

   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

   Submit Rating
   Team Mobile responded

   Sorting events via API have been published in 5.9 release.
   https://help.wildapricot.com/display/DOC/Events+API+V2+call

   AccessLevel filtering is not in our near plans, sorry. But user’s support can change this situation. So we are changing status of this idea back to “Collecting comments”.

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

   Submit Rating

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

   Submit Rating
   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

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

   Submit Rating

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

   Submit Rating
   Dmitry Smirnov responded

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

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

   Submit Rating
   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. 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

    Submit Rating
    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.

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

    Submit Rating

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

    Submit Rating