FrontAccounting forum — REST API

Re: REST API

null@example.com (sumitg.mukti) — Wed, 09 Sep 2020 10:49:05 +0000

I want to give frontaccounting access in other website which is hosted on other server. In that website there should be login option where we can enter user name, password and company name. After clicking login button, he should access creating Direct sales invoice and Direct purchase invoice form. After entering the data in invoices it saves data, in database. How we can give this feature in frontaccounting. Can anybody explain this??

Re: REST API

null@example.com (yantz) — Tue, 20 Nov 2018 09:27:04 +0000

Hi! i've got the api up and running. i can list sales orders and sales invoice. is there anyway i can list which orders are delivered or pending delivery? i've tried using trans_type 13 in sales but it returned nothing. thank you

yantz

Re: REST API

null@example.com (neholtz) — Fri, 07 Sep 2018 03:23:11 +0000

@kvvaradha,

Hosting server currently running php 5.6. The only move beyond that available is php 7.0.31.

I am awaiting a callback from Hosting's escalated tech support as the Level 1 was unable to shed any light on the matter.

I will post their comments if/when I have their response.

Until then.....

Re: REST API

null@example.com (kvvaradha) — Fri, 07 Sep 2018 01:32:07 +0000

It's better to check with your hosting provider. It looks like some modules are not working inside php library. If possible upgrade your PHP version than try this.

Re: REST API

null@example.com (neholtz) — Thu, 06 Sep 2018 18:52:12 +0000

Downloaded, unzipped and uploaded apmuthu's unofficial version for PHP 5.3 to MY_FA_URL/modules/api24/.

Edited util.php with applicable credentials for my FA installation.

Tested on same Host with the following result for https://MY_FA_URL/modules/api/category:

MY_HOST_URL.com is currently unable to handle this request.
HTTP ERROR 500

I noticed the following:

1. There is no error.log generated under /modules/api/

2. In comparing the index.php from apmuthu's version to the June 26, 2018 one, apmuthu's had:

ini_set('html_errors', false);

include_once ('config_api.php');
foreach (glob("src/*.php") as $filename)
include $filename;

use FAAPI\Inventory;
use FAAPI\InventoryLocations;
use FAAPI\Category;
use FAAPI\TaxTypes;
use FAAPI\TaxGroups;
use FAAPI\Customers;
use FAAPI\Suppliers;
use FAAPI\BankAccounts;
use FAAPI\GLAccounts;
use FAAPI\Currencies;
use FAAPI\InventoryCosts;
use FAAPI\Sales;
use FAAPI\Dimensions;
use FAAPI\Journal;
use FAAPI\Purchases;

Where the later version only had the use FAFPI\ namespaces. In other words without the following:

ini_set('html_errors', false);

include_once ('config_api.php');
foreach (glob("src/*.php") as $filename)
include $filename;

So neither version will run for me.

It is important to note that my installed version of FA 2.4.4 is running perfectly fine on the same server with php 5.6.

Not sure of a path forward at this moment.

Re: REST API

null@example.com (neholtz) — Thu, 06 Sep 2018 18:21:09 +0000

@kvvaradha, I will try apmuthu's version shortly.

I was trying to see why this version was not performing under php 5.6 which is the version selected on my host.

Here is the log error.log file under /modules/api/

Quoting:

[06-Sep-2018 11:38:38] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/php/56/usr/lib64/php/modules/imagick.so' - /usr/php/56/usr/lib64/php/modules/imagick.so: undefined symbol: zend_new_interned_string in Unknown on line 0
[06-Sep-2018 11:38:38] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/php/56/usr/lib64/php/modules/pdo_mysql.so' - /usr/php/56/usr/lib64/php/modules/pdo_mysql.so: undefined symbol: mysqlnd_allocator in Unknown on line 0
[06-Sep-2018 11:38:38] PHP Warning: PHP Startup: pdo_sqlite: Unable to initialize module
Module compiled with module API=20131226, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
[06-Sep-2018 11:38:38] PHP Warning: PHP Startup: pdo_pgsql: Unable to initialize module
Module compiled with module API=20131226, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
[06-Sep-2018 11:38:38] PHP Warning: PHP Startup: magickwand: Unable to initialize module
Module compiled with module API=20131226, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
[06-Sep-2018 11:38:38] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/php/56/usr/lib64/php/modules/mailparse.so' - /usr/php/56/usr/lib64/php/modules/mailparse.so: undefined symbol: zend_new_interned_string in Unknown on line 0
[06-Sep-2018 11:38:38] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/php/56/usr/lib64/php/modules/oauth.so' - /usr/php/56/usr/lib64/php/modules/oauth.so: undefined symbol: zend_new_interned_string in Unknown on line 0
[06-Sep-2018 11:38:38] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/php/56/usr/lib64/php/modules/oci8.so' - /usr/php/56/usr/lib64/php/modules/oci8.so: undefined symbol: zend_new_interned_string in Unknown on line 0
[06-Sep-2018 11:38:38] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/php/56/usr/lib64/php/modules/uploadprogress.so' - /usr/php/56/usr/lib64/php/modules/uploadprogress.so: undefined symbol: zend_ini_string_ex in Unknown on line 0
[06-Sep-2018 11:38:38] PHP Parse error: syntax error, unexpected T_STRING, expecting T_CONSTANT_ENCAPSED_STRING or '(' in /home2/finishl4/public_html/erp/modules/api/index.php on line 2

End of Quoting.

Tech support from my Host has been unable to explain why calls to php 5.6 library modules are unable to be found. I am awaiting an escalated callback on the ticket.

Beyond that the question is if apmuthu's version for 5.3 will run under 5.6. I will try it and post results here.

neholtz

Re: REST API

null@example.com (kvvaradha) — Thu, 06 Sep 2018 00:41:00 +0000

@neholtz, try apmuthus repo files. And if you have the same issue. Just copy ten lines of index.php inside API directory

Re: REST API

null@example.com (neholtz) — Wed, 05 Sep 2018 19:20:53 +0000

Hosting Server php is 5.6

I also could not find anywhere within the api files where those namespaces were defined.

Re: REST API

null@example.com (apmuthu) — Wed, 05 Sep 2018 19:15:37 +0000

You can use my unofficial version for PHP 5.3.

Re: REST API

null@example.com (kvvaradha) — Wed, 05 Sep 2018 17:34:02 +0000

Can you check your PHP version.?

Is it greater than 5.3 ?

Because the index.php line no 2 is namespace use . If your PHP is lower than 5.4 it won't work with namespace.

Hope it helps you

Re: REST API

null@example.com (neholtz) — Tue, 04 Sep 2018 15:56:31 +0000

Downloaded and unzipped frontaccounting-2.4-api.module.1.7 as directed to /modules/api/ directory.

Changes variables in util.php to match my current test company.

Directed browser to : https://MY_FA_URL/modules/api/category/ as suggested.

Received a blank page with no results.

In the /modules/api/error.log file the following:

PHP Parse error: syntax error, unexpected T_STRING, expecting T_CONSTANT_ENCAPSED_STRING or '(' in /MY_FA_URL/modules/api/index.php on line 2

Stuck here. Help or suggestions appreciated.

Note: 'MY_FA_URL' replaced with actual URL to site.

Re: REST API

null@example.com (apmuthu) — Thu, 05 Jul 2018 14:02:19 +0000

All the $ variables need to be populated and then the sql needs to be extracted.
Read the Troubleshooting page in the Wiki.

Re: REST API

null@example.com (saramsht) — Thu, 05 Jul 2018 09:20:48 +0000

would you please explain more.
I want to post json object like below to insert an invoice:
{
"customer_id":2,
"order_date":"06/27/2018",
"ref":"001/2018",
"trans_type":"ST_SALESINVOICE",
"items":[
{"stock_id":103, "qty":5, "price":5555, "discount":0,"description":"no desc"}
]
}
I want to know how _parse_next function handle the next reference if there is no record in journal table with trans_type=ST_SALESINVOICE
When I post this object dbquery in references.inc 170+ does not respond:
$sql = "SELECT MAX(CAST(SUBSTR($ref_fld, ".(strlen($prefix)+1).",LENGTH($ref_fld)-".(strlen($postfix)+strlen($prefix)).") AS UNSIGNED))"
." FROM `$trans_table` tbl
LEFT JOIN ".TB_PREF."voided v ON tbl.`$tno_fld`=v.id AND v.type=$type"
." WHERE ISNULL(v.id)"
.($type_fld ? " AND tbl.`$type_fld`=$type" : '')
." AND `$ref_fld` REGEXP ".db_escape('^'.preg_quote($prefix).'[0-9]*'.preg_quote($postfix).'$');
$result = db_query($sql, 'cannot retrieve last reference');

Re: REST API

null@example.com (apmuthu) — Thu, 05 Jul 2018 08:36:09 +0000

Try to display the sql after the sql. The where clause addresses the issue of absence of voided entry.

Re: REST API

null@example.com (saramsht) — Thu, 05 Jul 2018 08:29:04 +0000

Because there is no record with required trans_type in journal table.