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

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")

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 = 'http://oauth.wildapricot.org/auth/token';
$fields = array(
'grant_type' => "authorization_code",
'code' => CCGetParam("code",0),
'client_id' => '[client_id]',
'redirect_uri' => "https://[domain.com]/login2.php",
'scope' => 'contacts_me'
);

//url-ify the data for the POST
foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }

$fields_string = rtrim($fields_string, '&');

//open connection
$ch = curl_init();

$headers = array(
'Authorization: Basic '. 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);
===

So I am working on a client site that uses WA as their membership management system. Their site is actually located in WP and therefore I used iframes to integrate events, member directory, and so on. Problem is that I do not want a scroll bar and I do not want the iframe to get cut off at the height I set for it. I tried using height="auto" or Height="100%" but these shrink the iframe up and then it creates a scroll bar. Currently I have the iframe height set up high in pixels so it does not run out of room. Is there anyway around this issue?

I am continually getting 502 responses from the API but they are inconsistent. Some requests go through without a problem but at another time, the same request that worked, say 20min ago returns a a 502. I am trying to isolate the problem but i don't know where to start. I have not changed anything in the header, url, or the url parameters. It seems the API just stops processing my requests.

I'm using Postman and I have also written some PHP scripts based on the PHP samples provided on Github.

Has anyone had this experience? I would like to know how you fixed it, or learned to avoid it.

Thanks

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

A question on the Excel spreadsheet made available 6 months ago by Wild Apricot at https://github.com/WildApricot/ApiSamples/tree/master/Excel

I am having a problem with authentication. I put in the API key from authorized applications via copy/paste so I know it's right. Then I clicked download data and tried both the client ID/secret key and my admin username and password. Both times I get this error. I went through the VBA code a bit to review if I may be doing something wrong, but I don't see anything wrong.

Client is not authorized to use this grant type is an error I cannot find anything on in the API v2. Sort of befuddled, as this is the same thing that's done through PHP and that works great with the same API key.