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,
CPorter
shared this idea
Sample code is shared. If you still have questions, please create new thread on forum.
12 comments
-
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 -
Havalyn Hensley
commented
@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
-
Stephen
commented
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.
-
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).
-
CPorter
commented
Any suggestions?
-
AdminEvgeny Zaritovskiy
(VP Technology of Wild Apricot by Personify, Wild Apricot by Personify)
commented
It doesn't support private messages, sorry.
-
CPorter
commented
Me again, signed in properly now. Still don't know how to PM in this system though.
-
website
commented
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 Lowndes
commented
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!
-
Hi Wayne,
What are you trying to implement with contact api?
Could you please describe which URL's do you call and what response does API return?
-
Wayne Rohrs
commented
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?
-
Alexey Podolsky
commented
regarding responsiveness suggestions/ideas etc feel free to contact me directly via boblin@wildapricot.com
thanks!
