SOAP Web Service

Hi Gareth,

I have no experience with soap, but some time ago I have implemented Hessian protocol interface for FA, however the code was never bundled with core FA sources.

Janusz

This is really good  start point to implement full soap API for FrontAccounting, thank you Gareth. We will put it with your permission also on our download page. I hope somebody over there will be interested in making it more complete, then we can make it available also from our repo as extension module .

Janusz

Hi All, I have created a Soap Web Services that integrate with Customer Contact table and it will automatically populate the customer information into FrontAccounting system. This release is based on "Import Customers module" that is available in "download" page.

Initially, this web services API come with 3 methods:

  1) get_debtors_masters (Query Customer Master Table)
  2) get_debtor_trans (Query the Customer Transaction Table)
  3) create_debtors_masters
       3.1) Insert Action - Create Customer Master, Branch, Person and Contact information.
       3.2) Update Action - Update Customer Master Table Only

You can used this web service to Sync Customers Contact Information with any e-Commerce and provide data integrity between
the two system.

PROBLEM:    I was unable to perform Security Role Checking by using this web services. Maybe someone can share with me how FrontAccounting security Access Level rules.

You can download this "Plugin" from http://www.anterp.com/downloads/fa_soap_web_services.zip

For installation and User Guide, please read the document file at readme.txt and FrontAccounting-Web-Service.pdf

I would like to heard your suggestion, kindly reply to this forums or email to me. Thanks & Enjoy it.

Hi Tomarnst,

I think you can use this plugin to sync your customer contact information into FA. It regardless what Shopping Cart you are using. You can call the interface as below:

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$_company_name = "ABC Co";
$_short_name = strtolower(ereg_replace("[^A-Za-z0-9]`~!#'\"", "", str_replace(' ', '', $_company_name)));
$_first_name = "Your Name";
$_last_name = "Lim";
//Create Debtor Master
$param = array("company"=> $_company,
                 "user_id"=> $_uid,
                 "password"=>$_upswd,
                 "id"=>"",
                 "company_name"=>$_company_name,
                 "short_name"=>$_short_name,
                 "first_name"=>$_first_name,
                 "last_name"=>$_last_name,
                 "address"=>"123, Jalan ABC, Malaysia",
                 "email"=>"abc@yahoo.com",
                 "phone"=>"60311111111",
                 "mobile"=>"6012222288",
                 "fax"=>"",
                 "tax_group"=>"GST Tax",
                 "tax_id"=>"GST8888",
                 "area"=>"Asia",
                 "country_code"=>"MY",
                 "currency_code"=>"MYR",
                 "customer_type"=>"Retail",
                 "payment_terms"=>"Cash Only",
                 "credit_status_id"=>"1",
                 "notes"=>"Good Customer");
$antResults=$soapclient->call("create_debtors_masters",$param);

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Hope it help...

This is really very interesting and I downloaded the source. It looks like the other method required would be: 
create_debtor_trans

You could then process an eCommerce shopping cart, add/edit the debtor to FA and then create an FA sales order or invoice (based on the trans type) depending on whether you track delivery of orders in FA or your eCommerce system ( I make sales orders and track deliveries in FA). For those of you using Virtuemart (like me), I understand there is a user class system so you can hook onto so you can make these calls to SOAP without touching the main Virtuemart source. Not sure if Magento has the same coding structure.

In addition to that, some procedures to Get and Create sales Items might be useful to keep product lists in Sync between eCommerce and FA.

tclim

Thanks so much for contributing this. I had seen the Vtiger contribution but am not quite ready to tackle the CRM side of my small business and did not realise that it included a generic API as REST meant nothing to me. Now I need to get my head around all of what you have done and of course once I stopped and thought I needed Purchase order integration as well. I had a quick look at your Vtiger integration demo and was impressed and will return.

I will continue the conversation on the other thread once I am ready to tackle this.

Rod

Hi kpimichael,

   This API was built using Soap WebService as the title have clearly mention about it. You can use it to import your Customers and  Contacts into FA. It will automatically populate the data into Debtor Master, Branch and Contact tables. You can extend the API by creating your own WebService API to suite your need. Please downloads the zip file from http://www.anterp.com/downloads/fa_soap_web_services.zip and read my documents FrontAccounting-Web-Service.pdf.

Hope it help.

tclim