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

What will you do with the new API?

I'm excited for the API that will be coming out this month (according to this forum: http://forums.wildapricot.com/forums/308920-archive/suggestions/8831320-api-to-read-contact-member-records-2469 )

I see that there are a lot of people interested in the API and I was curious what others will be using it for? I will be using it to integrate Google Maps but perhaps there are some other cool things I can set up that I haven't thought of.

1 vote
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

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

    22 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...
      • jalvey09jalvey09 commented  ·   ·  Flag as inappropriate

        Thank you! Very nice database! I've got someone looking into the customization...thanks again for the quick response!

      • jalvey09jalvey09 commented  ·   ·  Flag as inappropriate

        I would love to see a copy of the Access Database you're referring to. I am using Access to standardize some of the fields prior to sending out reports, and this would be extremely beneficial to see! Thanks in advance for your help!

      • Dave GrimesDave Grimes commented  ·   ·  Flag as inappropriate

        Joy, here's the link: http://www.rmothg.org/wildapricot_api%20Distro.zip

        It uses the V1 API. I quit development with it when I found that the API would not allow any connection or grouping of contacts into their respective bundles. WA does still support the V1 calls, I think.

        There are several hundred lines of custom VB code included. It may or may not be easy to convert the app to V2, if V2 has the power you need.

        I have never investigated V2 because I am no longer the volunteer responsible for the club membership development.

        Good Luck,

        Dave, davegri@comcast.net

      • Scott SimmonsScott Simmons commented  ·   ·  Flag as inappropriate

        Could you also use this to bring up a Wufoo form in an event registration form and pre-file form fields such as name and email address? How about member ID if the user is logged into WA?

      • AIMS WebmasterAIMS Webmaster commented  ·   ·  Flag as inappropriate

        If you are still willing to share a link to the Access database you put together utilizing the API, that would serve as a great starting point for me. My programming skills are a bit rusty but with some working code to start with, I may have a chance :-).

        Thanks in advance.

      • metalartgatemetalartgate commented  ·   ·  Flag as inappropriate

        Just started working with the example Excel file and I am having some issues. I notice that so fields are always blank yet I know there is data in them. It seems that everything after the email address is blank.

        If I just paste the Result URL in the browser I get ALL fields with their data.

        Is anyone else seeing this problem?

        Thanks

        -gary

      • Dave GrimesDave Grimes commented  ·   ·  Flag as inappropriate

        I've ported the example Excel VBA code to Access 2010 so that I can download tblContacts, tblFields, and tblLevels to an Access application.

        This allows me to create custom reports from Access. The WA API does not allow us financial data yet, but with the contacts data allowed, I can create reports such as a Roster, New Members, Membership Cards, and customized labels. There's also built in functionality to create some of the reports via mail merge in Word.

        If anyone wants a copy of the .accdb, email me and I can give you the URL to the zip file via return mail.
        I have stripped out most of the code specific to my organization. However, the application still contains a large amount of VBA code. If you are unable to work with VBA programming, you will probably have problems that you cannot overcome. You must accept the download as is, without my support. I can, at my discretion, and if time permits, answer specific questions via email if you become stuck trying to understand/modify the program code. The program does contain fairly comprehensive help on functionality.

        Davegri

      • DotCreativityDotCreativity commented  ·   ·  Flag as inappropriate

        The team at DotCreativity http://dotcreativity.com is working on a number of great new enhancements that will soon be available.

        Here is a preview of things soon to come:
        * Google Maps Subscription Service

        * Zip Code Search Subscription Service
        * Email Notifications for profile updates
        * Custom profile URLs

        As well as a number of other ideas that we are still tinkering with. Send us an email http://dotcreativity.com/contact if you want to be notified when these items are ready to go or if you have something else in mind that you would like to have developed.

      • Alan ChurchillAlan Churchill commented  ·   ·  Flag as inappropriate

        Even better ;-)

        I got most of it working last night using XML and LINQ. I need to refine it but it did work fine.

        Thanks a lot for making it happen.

        Alan

      • Alan ChurchillAlan Churchill commented  ·   ·  Flag as inappropriate

        On the website, it has a sample for C# using JSON. If you copy it, it is not delimited correctly and comes across as a single string. You then have to go in and correctly format the code.

        Go to one of my posts that show code:

        http://savian.blogspot.com/2012/04/hash-sas-value.html

        You can copy that and place it into Notepad (or whatever) and it pastes formatted properly.

        Your C# sample needs the following tags around it before it is placed into the HTML:

        <pre style="WORD-WRAP: break-word;">

        ...paste code in here formatted...

        </pre>

        HTH,

        Alan

      • Alan ChurchillAlan Churchill commented  ·   ·  Flag as inappropriate

        Cool stuff. I have successfully cleaned up the c# code and executed the program successfully against our data.

        Good job guys.

      • Alan ChurchillAlan Churchill commented  ·   ·  Flag as inappropriate

        The new C# sample code is not put into the HTML correctly. It comes out as one big string and is impossible to format easily. I will have to go in and clean it up by hand.

        I love this new stuff and wanted to start coding immediately but we need pre tags or something in there so we can copy the code formatted.

        What am I missing?

      • Alan ChurchillAlan Churchill commented  ·   ·  Flag as inappropriate

        You can use server-side web service calls to WA and expose those services out to your website.

        For example, a WCF interface which the client consumes and the back-end web service makes the calls to WA. Just a thought.

      • Alan ChurchillAlan Churchill commented  ·   ·  Flag as inappropriate

        Interesting question. I may also just roll our own website and take it from there.

        We have articles due from officers once a quarter. I figure I can have a form for them to fill out their article then mash it with photobucket and create our newsletter using a template. May use Aspose.PDF to create a pdf version. Then generate the file and mail it out either using the WA service or on our own.

        WA would be preferred but the initial APIs are membership APIs. I think the full power will be realized when additional APIs come online so we can automate the creation of the emails, events, etc. For now, I will be playing around and getting infrastructure into place. We will automate list creation such as BOD members so we don't have to maintain those lists outside of the db.

        I am not a fan of the Excel export on WA since it dumps everything. I already have programs that cleans it all up and creates simple lists that we can hand out to our officers (many prefer hard lists). I will probably automate the data pull and avoid the export button as step #1 and wait for more APIs to be put into place.

        I have the Wufoo APIs in place already and will just extend off of that.

        All of my work is in C#/.NET, btw. Just an FYI on what people are using.

      ← Previous 1

      Feedback and Knowledge Base

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