How can we make it easier for you to develop on top of Wild Apricot?

Monthly list of new users

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.

4 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base