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.

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.

1- First thing you need to secure is access to is your domain’s DNS settings or Zone Files. If you run a query at say DNS STUFF.Com – you can find out where your DNS is hosted: dnsstuff.com

Notice that in the Parent section our public Name Servers listed as follows:
emily.ns.cloudflare.com. | 173.245.58.155
buck.ns.cloudflare.com. | 173.245.59.78

So for our website CloudFlare.Com is where we host our DNS.

2- Next, go to the Wild Apricot custom domain setup article < Click Here >
Once in your DNS Zone Files, you will need to edit the following files:
A) CNAME
Name: www
Value: sites.wildapricot.org

B) A record
Name: YourDomain.com
Value: 96.43.192.222

C) TXT record
Name:YourDomain.com
Value: v=spf1 mx include:wildapricot.org ~all

3- Finally, you will need to set custom domains in the Wild Apricot settings for both www and non-www YourDomain.Com. You’d need to decide which of the two would be your primary or default primary.

One thing to keep in mind is your MX or Email DNS Zone Files. As you may or may not know, Wild Apricot does not host or provide mail boxes/emails for your domain. So, please keep this in mind – so that you can either keep your existing Email provider or find a new one.

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 am querying now on the eventregistrations API and have the API query working through https://api.wildapricot.org/ui/home/RequestOAuthToken , but the result set fails a json_decode action with NULL - which I presume means it is not JSON structured. Not sure how to proceed with solving for this. I am running this through the php sample application, which works.. but when adapting to test for this eventregistrations query, the apparent JSON result fails the decode test and hence nothing is available to the foreach loop to extract the right information.

Running this query, which works fine..

https://l.facebook.com/l.php?u=https%3A%2F%2Fapi.wildapricot.org%2Fv2.2%2Faccounts%2F1234567890%2Feventregistrations%3FeventId%3D4344015%26fbclid%3DIwAR3fKL6K25MQZIrov9EYsXFhQVEzXKlPOzCDK7HxO0g7uEYdYRTy-6sHnGQ&h=AT1hreSFqkWarrlAM6Wfjd5qPxfJFJjTgzZ4vwNilhOyC8eVdE1dw15AbESS4gRo3ZudF6nWUQdqi6FCcIRDRjZTv4cGCpIh4ULxzTD9DWFJw0NgoyyXtU4ZrZTaToUYhN8o&tn=-UK-R&c[0]=AT0qQTLupLZd5d7sgyM9tb3J0rQ4JkLlK6SHLVNIbdCWpH8fFtgvHMjqT1uln6KtExBXEeDdnzEIozaPhA3jwQnEGwqT0code7yc6J38fMHF7nXFBAj1HpILaGi3uTjWCShzKRV1p_kiZzqPdSdSA1Vjni20A3doSA

.. gives this response > NULL bool(true) < when running the following code, which is adapted from the https://github.com/.../blob/master/PHP/sampleApplication.php same php code.

The code itself is the following snippet:

  $eventRegistrantsQueryResult = getEventRegistrantsList(); 

  echo '<br />';

  // this code outputs "NULL bool(true)" 

  var_dump(json_decode($eventRegistrantsQueryResult), true);

  // this code fails given the json_decode fails with NULL and hence is ignored

  $eventRegistrants =  $eventRegistrantsQueryResult['Id'];

  foreach($eventRegistrants as $eventRegistrant) {

     echo '<br />boink';

     echo sprintf("#%d - %s", $eventRegistrant['Id'], $eventRegistrant['DisplayName']);

  }

  function getEventRegistrantsList()

  {

     global $waApiClient;

     global $accountUrl;

     $urlEventRegistrants = $accountUrl . '/eventregistrations?eventId=4342345';

     return $waApiClient->makeRequest($urlEventRegistrants);

  }

Any ideas and/or suggestions?! 😉 Would be welcomed for sure! Have a great day/evening/morning/.. ahead!