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.

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.