Hi. According to some of the documentation it implies that I can use a custom fields' name to reference it. I can directly reference common fields as a $select parameter, but can only reference other fields using their custom-xxx tag, like this:

'$select' => 'First name, Last name, Email, custom-8097667,
custom-8097668, custom-8161502, custom-8097675, custom-8017535'

The custom field tag does not seem to appear anywhere in Membership fields area of the WA database though so the only way I can find it out is by trawling through json data manually.

Is there a better way to reference those fields, or to find out their custom-xxx reference (as I've mentioned, I've looked through the WA membership fields in the actual WA site and can see no obvious use of this custom-xxx referencing). The code snip below is part of the json returned on a full dump, and SystemCode is the only place that I can see that references the custom field number:
json data referencing a custom field:

[6] => Array
(
[FieldName] => Practice Address 1
[Value] => 40 Test Way
[SystemCode] => custom-8097667
)

I'm working with a tool called Cognito Forms that allow some fairly complex form functionality. One great feature is the ability to pass values to a form embedded on a Wild Apricot page.

We are currently working on a feature where a member navigates to a member-only page for expense reimbursement. The page loads an embedded form and pre-fills most of the information.

Right now, I am using the API to use the contacts/me call to load name and email, but I need the contact/{contact-ID} to get the address and phone.

After getting the script completed and pre-populating the form for my admin account, I found that this API call doesn't work for non-admins. After some digging, I found this thread: https://forums.wildapricot.com/forums/309658-developers/suggestions/18163003-fieldvalues-contact-api

I'm receiving the same error as above: "Current token does not provide access to scope 'contacts_view'.

Is this really true that a contact can't pull their own information via API? Not even their address? All of this JS is occurring within WA pages.

I've downloaded the Swagger file for administrative access and imported into PowerApps in an attempt to create a custom connector. It asks for several fields (see screen shot in attached file).

I'm not clear on two of the fields to fill in.

For Authorization URL, it is showing a default of:

https://YOUR_ORGANIZATION.wildapricot.com/sys/login/OAuthLogin

I'm not sure what I should replace YOUR_ORGANIZATION with.

It is also requesting a Refresh URL and I don't know what to put in there.

Any help would be appreciated. A documented PowerApps connector would be of general use to the WA community and I'd be happy to document the process if I can get it working.

• gurujeet

Perhaps someone in this forum can help answer this question. There aren't any OAuth exampels for PHP.

My code is failing on the last ajax call to the OAuth API. I am getting a NULL response from Wild Apricot.

Perhap someone can let me know what is wrong withthis code:

    $credentials = '[client_id]:[secret]';


//extract data from the post

//set POST variables

$url = &#39;<a rel="nofollow noreferrer" href="http://oauth.wildapricot.org/auth/token&#39;">http://oauth.wildapricot.org/auth/token&#39;</a>;

$fields = array(

    &#39;grant_type&#39; =&gt; &quot;authorization_code&quot;,

    &#39;code&#39; =&gt; CCGetParam(&quot;code&quot;,0),

    &#39;client_id&#39; =&gt; &#39;[client_id]&#39;,

    &#39;redirect_uri&#39; =&gt; &quot;<a rel="nofollow noreferrer" href="https://[domain.com]/login2.php&quot;">https://[domain.com]/login2.php&quot;</a>,

    &#39;scope&#39; =&gt; &#39;contacts_me&#39;

);

//url-ify the data for the POST

foreach($fields as $key=&gt;$value) { $fields_string .= $key.&#39;=&#39;.$value.&#39;&amp;&#39;; }

$fields_string = rtrim($fields_string, &#39;&amp;&#39;);

//open connection

$ch = curl_init();

$headers = array(

    &#39;Authorization: Basic &#39;. base64_encode($credentials) 

);

curl_setopt($ch,CURLOPT_HTTPHEADER, $headers);

curl_setopt($ch,CURLOPT_POST, 1);

curl_setopt($ch,CURLOPT_POSTFIELDS, $fields_string);

// Will return the response, if false it prints the response

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

//execute post

$result = curl_exec($ch);

===

I extended the excel sample API V2 app to develop an attendance system for our club. For a number of reasons, we're working to move off of Excel and onto Access. The sample code from WA runs smoothly on Excel, but not on Access. The sample includes the following (in function GetOAuthToken)

Dim httpClient as IXMLHTTPRequest
Set httpClient = CreateObject("Msxml12.XMLHTTP.3.0")
httpClient.Open "POST", url, False

(where url = "https://oauth.wildapricot.org/auth/token")

The client.open returns 'unauthorized'. I cannot find any documentation on the open method of the httpclient object. And I have no idea what extra authorization I need when working in Access. As noted, this code runs with no problem when working in Excel. Both Excel and Access are in Office 2016 on Win 10

We have a Google Apps script that is used to update a custom contact field. This code has been working and unchanged for the past year, and has suddenly lost the ability to update contacts. Other API calls to get contacts, update event registrations, etc. are still working fine, but can't update any contact fields through the API. Attempts to do so result in an HTTP 500 error. We are still able to update contacts through the web interface.

Relevant information pasted after the break.

Error:
[17-09-16 07:31:21:841 CDT] Exception: Request failed for https://api.wildapricot.org/v2/accounts/84576/Contacts/40772038 returned code 500. Truncated server response: {"Message":"An internal error has occured. Please contact Wild Apricot support.\r\n Request ID:b95421e2-dfb0-4318-8c3b-b52bcf2a4e58."} (use muteHttpExceptions option to examine full response)

Relevant code:

this.updateContact = function(id, field, value){
var data = {
"Id" : id,
"FieldValues" : [{
"FieldName" : field,
"Value" : value
}]
};
return this.put('Contacts/' + id, data);
};

this.put = function(url, data){ return this.send(url, 'PUT', data); };

this.send = function(url, method, data){
if (typeof method === 'undefined') { method = 'GET'; }

var requestParams = {
'method': method,
'headers': {
'Authorization': 'Bearer ' + this.token,
'accept': 'application/json',
},
}

this.apiURL = "https://api.wildapricot.org/v2/accounts/" + accountID + "/";

if(data){
requestParams.payload = JSON.stringify(data);
requestParams.contentType = 'application/json';
}

if(url.indexOf('http') != 0){
url = this.apiURL + url;
}
var responseJson = UrlFetchApp.fetch(url, requestParams);
return JSON.parse(responseJson);
};