Method Community



QuickBooks geeks unite! MethodAPI is here!

We have a slight problem here at Method.  We have rebranded a "developer" as someone who develops their own system.  Afterall, Method is a platform that is all drag and drop, no programming.  But the old school way of thinking is that only a programmer can be called a developer.   This leaves those who actually know how to write code asking "Where do I fit into all this?  What's my title?"  So until we find a better name, "QuickBooks geeks" it is - and since I am certainly a geek, I have no problem using the title.

You should have seen me around the office this week showing off the little apps I was creating using the Method API.  Slick apps I'm telling you.  Like a VBA add in for Excel that instantly grabs a list of overdue QuickBooks invoices and plops them into Excel.  Or a cool little web page app that with 20 lines of code fires an invoice into QuickBooks in real time. I think the staff here were wearing sympathetic smiley faces while trying to figure out why I was so excited.

But that's understandable.  They aren't all programming geeks like me.  Furthermore, they haven't tried to make apps that use the QuickBooks SDK, or the QuickBooks Web Connector.  So they couldn't possibly understand why it is so cool that you can write a simple SQL statement from a web page, send it to a MethodAPI web service and viola! it updates QuickBooks.  But if you've kept with me to the end of paragraph 3 of this blog post......I'm thinking you just might get it too.

Who is this MethodAPI for?  Not your typical Method user.  This is for programmers (those of us who write code..yuk!!) that want to integrate their apps with Method.  So they could be those who want to write powerful import or export tools from a desktop app like Excel, or they could be web developers that want to integrate Method users' websites with Method and QuickBooks data.  In fact, when we were at the QB Enterprise Solutions Conference two weeks ago, I pretty much had every other software company come up to me at some point saying "hey, Paul, could you guys make that syncing engine available to us so that we could make web service calls instead of using the web connector?".

So, two weeks later, here we are.  We move fast.  MethodAPI is here, and it delivers a WOW - providing, of course, that you are a QuickBooks geek like me.

MethodAPI Documentation:

MethodAPI Samples for VBA / Excel:

MethodAPI Samples for ASP.NET:

Reply to this blog post with any comments, questions or complaints on the use of the “geek” word, I'm all ears. 

Couple images:

Here's a screen shot of the "Get Overdue Invoices" in Excel:

Here's a snippet of the VBA code:

Paul Jackson
Method Integration



Danny_Do_Couto said:

Yeah.....the "geek" really did come out of Paul when he showed me this.  Very cool stuff though! :)  Provided you understand what it is, you'll know why it's so exciting, especially for you old school coders.

September 25, 2008 11:47 AM

jvwalton said:

The Excel API works great and makes it easy to connect Excel with Method and therefore QuickBooks.  The days of trying to figure out the QuickBooks SDK to produce powerful QuickBooks reports are over.  Great addition to Method.  Thanks for providing this capability.

Joe Walton

October 6, 2008 4:16 PM

About Method_Paul

While studying at Queen's School of Business in 1999, Paul founded Alocet Incorporated, developing 'QXpress', which later became the top rated field service scheduling add-on for QuickBooks. Alocet Incorporated later went on to create Method Integration - an innovative small business management platform that allows users to create their own web apps for QuickBooks.