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);
};

Hi,
we have a job that queries via the API searching with a filter on "Profile last updated". The query can return no results, it doesn't find any contacts changed since the last query run. However if we just iterate through the contacts and read the Profile last updated field it can be more recent shown in the API results than displayed in the WA web interface. It appears when reading via the API the "last login date" is used as the Profile last updated date if the last login is newer than the last profile update.

Summary:
Profile last updated date retrieved via API doesn't match the date shown in the web interface, it seems to match Last Login Date if that is more recent.

Search in the API seems to use the same date as Profile last updated as viewed from the web.

Any ideas?