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

Google Script for Google Apps

Thank you to WildApricot for posting the sample code for an api connection to update a google spreadsheet. https://help.wildapricot.com/display/DOC/Sample+API+V2+applications

I'm now using google scripts to produce (update) 13 regional spreadsheets of members each that has been shared with a regional coordinator so that I don't have to do this manually.

Would love to hear how other organizations are using Google apps and integrating the wa api.

Also would love to collaborate on building some additional Google Code scripts. Example, allowing each regional coordinator to email (mail merge) via gmail the members in their regional spreadsheet.

I am also interested in collaborating on implementing media queries to enhance the responsiveness of the new themes.

Thanks,

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    12 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • DmitryDmitry commented  ·   ·  Flag as inappropriate

        Hi hhh,

        Getting contacts from API is really easy. If you want to use google spreadsheet sample, then this code

        var url = urls.getContactsListUrl(accountId) + '?$async=false&simpleQuery=John';
        var contacts = getDataFromApi( url, token, "GET");

        will return you a list of contacts with "John" in first name, last name, email etc. However if you need more precise filtering, please refer to our help site http://help.wildapricot.com/display/DOC/Contacts+API+V2+call#ContactsAPIV2call-Filteringtheresults

        Dmitry,
        API and Mobile developer at Wild Apricot

      • hhhhhh commented  ·   ·  Flag as inappropriate

        @cporter - I too am attempting to use the API for a similar recurring contact refresh to google sheets. Would be very appreciative of having a look at your code.

        @Stephen - did you find any answers?

        @Dimitry - appreciate the sample code you posted for create contact - if you have a snippet for get contact it would be so helpful to see.

        Thanks everyone!Love the WA

      • StephenStephen commented  ·   ·  Flag as inappropriate

        Could you post your code/sheet to Google Drive with any identifying information removed? That way you could post an access link here. I also would be very grateful for an opportunity to look at your code.

      • DmitryAdminDmitry (Software developer, Wild Apricot) commented  ·   ·  Flag as inappropriate

        If you don't mind sharing your code with everyone, you can use services like github and post here a link to repository. If this option is too technical, then you can try to share a zip archive on some cloud storage like google drive.

        PS Don't forget to remove private information from your coe before publishing (api key, client secret etc).

      • CPorterCPorter commented  ·   ·  Flag as inappropriate

        Me again, signed in properly now. Still don't know how to PM in this system though.

      • websitewebsite commented  ·   ·  Flag as inappropriate

        Hi Aaron, I am happy to share my code with you, but I can't figure out how to PM in this forum app. :( CPorter

      • Aaron LowndesAaron Lowndes commented  ·   ·  Flag as inappropriate

        CPorter do you think you could share your google spreadsheet and code with us? I am trying to create something that sounds very similar to what you describe. Much appreciated!

      • Wayne RohrsWayne Rohrs commented  ·   ·  Flag as inappropriate

        I have been trying to do the same thing with the Google spreadsheet but cannot get it to work with the contacts api. All the other apis I have tried work fine but the contacts api returns an undefined result. Is there some trick I have missed?

      Feedback and Knowledge Base

      Wild Apricot Inc. 144 Front Street West Suite 725, Toronto, Ontario, Canada M5J 2L7