Thank you to WildApricot for posting the sample code for an api connection to update a google spreadsheet. https://help.wildapricot.com/display/DOC/Sample+API+V2+applications

I'm now using google scripts to produce (update) 13 regional spreadsheets of members each that has been shared with a regional coordinator so that I don't have to do this manually.

Would love to hear how other organizations are using Google apps and integrating the wa api.

Also would love to collaborate on building some additional Google Code scripts. Example, allowing each regional coordinator to email (mail merge) via gmail the members in their regional spreadsheet.

I am also interested in collaborating on implementing media queries to enhance the responsiveness of the new themes.

Thanks,

All was going very well with the API V2 until I wanted to set up Bundles with the membership. I can create contacts and assign a membership level. But when I try to assign a create a Bundle Administrator or Bundle Member, nothing seems to take. The API says only a Bundle ID and NOT an email address like the Import can use. To automate this process, I don't/can't use the Import process.

Has anyone been successful in using the API to create a Bundle? (Administrator and/or Member)

Any help is greatly appreciated. Our trial is almost over and this is the last thing that would put us over the edge to purchase. Without it, I will have a hard time justifying the work to change providers.

Thanks.

As part of our first operational use of the API, I need to update two fields dynamically. For trials, I am using php cUrl, modeled on your sample application. I have no problems with GET, but PUT leaves me baffled.

Each time I run the script, the target fields are not changed - but the membership of the target contact goes from "active" to "membership not allocated".

Clearly my code is doing this: but how/why? Can anyone give me a clue as to what is happening?

Also, my debugging script shows a result JSON containing all the target contact's data. Is this as it should be? And can it be prevented (unnecessary data traffic, etc.)?

My cUrl code is (sorry about the bad formatting below):

$accountUrl = "https://api.wildapricot.org/v2/accounts/[account]/Contacts/";
$queryParams = array(

    'Id' => $contact,

    'Field values' => array(

        0 => array(

            'FieldName' => "fieldname1",

            'Value' => 'XXXXX'

        ),

        1 => array(

            'FieldName' => "fieldname2",

            'Value' => 'XXXXXX'

        )

    )

);

$url = $accountUrl.$contact;

$verb = "PUT";

$ch = curl_init();

$headers = array(

    'Authorization: Bearer ' . $token,

    'Content-Type: application/json'

);

curl_setopt($ch, CURLOPT_URL, &#39;<a rel="nofollow noreferrer" href="https://api.wildapricot.org/v2/accounts/[account]/Contacts/[contact]&#39;)">https://api.wildapricot.org/v2/accounts/[account]/Contacts/[contact]&#39;)</a>;

curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

curl_setopt($ch, CURLOPT_CUSTOMREQUEST, $verb);

if ($queryParams) {

    $jsonData = json_encode($queryParams);

    curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonData);

}

curlsetopt($ch, CURLOPTRETURNTRANSFER, true);

$jsonResult = curl_exec($ch);

if ( !$jsonResult ) {

    echo curl_errno($ch) . ': ' . curl_error($ch);

}

curl_close($ch);

Wanting to get some feedback if I am doing this correctly or there is a better way!

Goal: I have 13 SavedSearches and I want to create 13 separate Google SS (using Google Script) with the details of members (some custom fields I have created as well) returned by each SavedSearch.

Step 1: I use the api SavedSearch request to return the contactIds.

Step 2: Iterate through the returned list and make an api call to contacts using the contactId.

Here is the problem I am encountering. The limit on individual contact calls is 60 / minute. All my searches have more than 60 records. So the SS population stops at 60. :( (http://help.wildapricot.com/display/DOC/API+Version+2#APIVersion2-APIrequestlimits)

Thoughts?

Thanks!

I am evaluating Wild Apricot for a small non-profit. We are all volunteers who will be administering it, so I am investigating using the API to automate our workflow due to the fact that WA does not create a Contact for Guest registrations.

My question is related to the Create Contact or Update Contact operations. I can create a contact with the FirstName, LastName and Email fields and I can update those fields. However, I have been unsuccessful adding or creating additional fields, even the Phone built in field.

Can anyone help by sending me an example of the syntax for the submission? I started with the Google Sheets example on the WA website. It has been easy to use when I understand the correct syntax! That's what I need here.

This is a showstopper to us moving to Wild Apricot if we cannot automate this. It looks like it should be easy to do if I get the correct syntax.

BTW, for the most part, thew documentation is very good. I guess because the API is not supported is why there are limited examples. As read elsewhere in this forum, I agree that it may be shortsighted for WS to not support the API. It does help embed customers to their platform...

Any help is greatly appreciated.
Thanks.

I’ve been following your API v2 guides and snagged the PHP sample listed here:

https://github.com/WildApricot/ApiSamples/blob/master/PHP/sampleApplication.php

I was able to properly implement the getAccountDetails function and I created a getContactIdFromEmail function that tweaked the getContactsList function to filter on an email address.

Now I’m trying to update the FirstName of the Contact that I received. Here’s the code:

function updatePasswordByContactId($contactId, $email)

{

global $waApiClient;

global $accountUrl;

$url = $accountUrl . "/Contacts/Contact/{$contactId}";

$data = array("FirstName" => "Chaz2");

$result = $waApiClient->makeRequest($url, "PUT", $data);

return true;

}

I analyzed the CURL parameters to see that it is calling the URL:

https://api.wildapricot.org/v2/Accounts/73659/Contacts/Contact/25710546 ALIDCONTACTID

In a “PUT” with the following JSON data:

{"FirstName":"Chaz2"}

I tried using “First name”, “Email”, and “e-Mail” and nothing seems to work.

It simply will return an empty string which gets JSON decoded to NULL.

Help!

-Chaz

As far as I can tell, APIKEY authorization according to:
http://help.wildapricot.com/display/DOC/API+V2+authentication
is broken.

This example:

POST /auth/token HTTP/1.1

Host: oauth.wildapricot.org

Authorization: Basic XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Content-Type: application/x-www-form-urlencoded

granttype=clientcredentials&scope=contacts finances events

simply doesn't work, always returning a "scope xxxx is not available for current client" for every scope I've tried (from the table on the same page).

Is this just completely broken, or something is missing. I note that there is no place in the API for the "application name". I also note that I don't get an "authorization error", as I would get if I use an incorrect base64-encoded API key, so it must be authenticating correctly.

Has anyone used APIKEY authentication? If so, does someone have a simple cURL command that proves it works?

Hi - looking through recent posts in the forum regarding usage of the WA API V2 I get the impression that the API is basically unsupported by WA. e.g. two API issues I posted some days ago remain unanswered and a recent API V2 question from another user (GeePawHill) also remains without any replies.

So a basic question - do WA staff support the API through this forum? If not can anyone at WA advise what other avenues are available in order to get support for the API? e.g. should we be submitting API issues via the support channel? (email) Or some other forum?

I have two iOS clients projects currently underway but both are stalled waiting for API issue resolution.

Thanks

David

Hi - I've spent hours trying to figure why the POST below (in Swift) fails. Status code is HTTP 500 which according to the doc means "Wild Apricot's server has encountered an error and cannot fulfill the request." API Key and authentication are all good since GET requests to the same API work fine.

The event is very simple defined to have only fields first and last name and email. The event is public. I've triple checked all the Id's - event, contact, reg type id etc.

Any ideas much appreciated..

Thanks
David

Post URL is https://api.wildapricot.org/v2/accounts/{acctid}/EventRegistrations/

Post Body is - {"RegistrationTypeId":2394243,"Event":{"Id":1805601},"RegistrationFields":[{"Value":"John","FieldName":"First name"},{"Value":"Barrett","FieldName":"Last name"},{"Value":"fred@gmail.com","FieldName":"e-Mail"}],"Contact":{"Id":26450615}}

Response is -
Status 500
{"Message":"An internal error has occured. Please contact Wild Apricot support.\r\n Request ID:8bc7b4458b4c47b784f9c45dcf3f34ce."}

Swift Code
println("\nPOST Url ----------->(url!)\n")
let request = NSMutableURLRequest(URL: url!)
request.HTTPMethod = "POST"
let auth = NSString(format: "Bearer %@", accessToken)
request.setValue(auth, forHTTPHeaderField: "Authorization")
request.addValue("application/json", forHTTPHeaderField: "Accept")

let params /: [AnyObject]/ = [

"Event": ["Id": 1805601], //ev 4

"RegistrationTypeId": 2394243, // for ev 4

"Contact": ["Id": 26450615], //mem2

"RegistrationFields": [

["FieldName": "First name", "Value": "John"],

["FieldName": "Last name", "Value": "Barrett"],

["FieldName": "e-Mail", "Value": "fred@gmail.com"],

] /*,

"IscheckedIn": false,

"IsPaid": false,

"ShowToPublicIsPaid": true,

"Memo":"Important member",

"GuestRegistrationsSummary": ["NumberOfGuests": 1] */

] as Dictionary

var err: NSError?

var bodyData = NSJSONSerialization.dataWithJSONObject(params, options: nil, error: &err)

var bodyStr = NSString(data: bodyData!, encoding: NSUTF8StringEncoding)!

println("body ----------->(bodyStr)")

request.HTTPBody = NSJSONSerialization.dataWithJSONObject(params, options: nil, error: &err)

var response: NSURLResponse?

var error: NSErrorPointer = nil

var data = NSURLConnection.sendSynchronousRequest(request, returningResponse: &response, error: error)

var reply = NSString(data: data!, encoding: NSUTF8StringEncoding)

//println("\n\nerror ----------->(error)")

println("\nresponse ----------->(response!)")

println(reply!)

In Version 5.4, which was just released on June 15th, Wild Apricot has made changes to the authentication process https://help.wildapricot.com/display/DOC/API+V2+authentication for its API. We have moved from account-based authentication to the more secure application-based authorization. Instead of generating a single API key that provides complete access to your entire Wild Apricot account, you authorize individual applications, each of which are assigned separate credentials. If you've previously generated an API key for your account – prior to the 5.4 release – it will automatically be converted to an authorized application called Legacy API key.
If you are currently using an API key to authenticate your application, you can continue to do so, and no code changes are required.
If you are using Wild Apricot account credentials to authenticate your application, you must change the authorization header of your authentication token request. Specifically, you must, within the authorization header, set username to the client ID assigned to your application when you authorized it, and set password to the client secret assigned to your application. Currently, username is set to the application name and password is set to openwaapi_client (a constant). You will have until July 6, 2015 to make this change. On this date, the account-based authentication method will stop functioning.
As well, Wild Apricot has changed the possible scope https://help.wildapricot.com/display/DOC/API+V2+authentication#APIV2authentication-Supportedscopes values when restricting access using Wild Apricot's API. This is necessary to support the ability to restrict API key access to read-only functions. One of the new scopes – auto – will automatically detect the maximum allowed scope using the API key access level or the user's Wild Apricot account permissions, depending on which was used when requesting an authentication token. No code changes will be required because of this change as newly obsolete scopes will be automatically substituted by the corresponding new scope.