sardoj/vtrestfulapi

API REST for Vtiger CRM

vtrestfulapi's Issues

When I accessed modules using GET request then have 500 internal server ERROR.

I already install VTRestfulAPI as zip in module. Then already got token response but when I get module data.

Using this http://vtigercrm.com/modules/RestfulApi/index.php?module=Accounts&token=mytoken

I got this error .

INFO VT - PearDatabase ->ADODB error Query Failed:SELECT vtiger_restfulapi.token AS vtiger_restfulapitoken,vtiger_restfulapi.ip AS vtiger_restfulapiip,vtiger_restfulapi.calls AS vtiger_restfulapicalls,vtiger_restfulapi.expiration_date AS vtiger_restfulapiexpiration_date,vtiger_restfulapi.user_id AS vtiger_restfulapiuser_id,vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,vtiger_crmentity.source AS vtiger_crmentitysource,vtiger_crmentity_user_field.starred AS vtiger_crmentity_user_fieldstarred,vtiger_restfulapi.tags AS vtiger_restfulapitags,vtiger_crmentity.deleted, vtiger_crmentity.label FROM vtiger_crmentity LEFT JOIN vtiger_restfulapi ON (vtiger_restfulapi.restfulapiid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_restfulapicf ON (vtiger_restfulapicf.restfulapiid = vtiger_crmentity.crmid ) WHERE vtiger_crmentity.crmid=? LIMIT 1::->[1054]Unknown column 'vtiger_crmentity_user_field.starred' in 'field list'

Please help me solved this :) Thank you

VTiger 7 compatibility

Hi,
I'm trying to test your module against vtiger 7.
To make it compatible the installation is missing
the table vtiger_restfulapi_user_field (used in VT for field tracking)

Proposal:

CREATE TABLE vtiger_restfulapi_user_field (
recordid int(25) NOT NULL,
userid int(25) NOT NULL,
starred varchar(100) DEFAULT NULL,
KEY fk_restfulapiid_vtiger_restfulapi_user_field (recordid),
CONSTRAINT fk_restfulapiid_vtiger_restfulapi_user_field FOREIGN KEY (recordid) REFERENCES vtiger_restfulapi (restfulapiid) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

vTiger 7.1 can not install module

hello
I can not install module for vtiger 7.1 I am trying to import from the zip file
and getting error:

dUnzip2: File 'manifest.xml' is not compressed in the zip.
FailedInvalid File provided for module import! Try Again.

:(

Compatibility ip v6

Please,

To correct issues with token and IP v6, you have to change field ip size to 40 chars length in database.

Cheers

VTiger 7 compatibility

• VT7 Compatibility (getColumnFields)
• Added product details for SalesOrder, PurchaseOrder, Quote, Invoice

https://github.com/sardoj/VTRestfulAPI/blob/master/src/modules/RestfulApi/actions/Api.php#L459

$m_result = $focus->column_fields;

changed in:

$m_result = $focus->column_fields->getColumnFields();

if($this->module == 'Invoice' || $this->module == 'Quotes' || $this->module == 'SalesOrder' || $this->module == 'PurchaseOrder') { 
                $recordModel = Vtiger_Record_Model::getInstanceById($id);
                $m_result["products"] = $recordModel->getProducts();
            }