i can't create Criteria using Invoice_Date by PHP
Hi,
thank you for match information about zoho api.
today , i want to get invoice data of last month.
so i create a php code below using zoho-php-sdk v2.
- $zcrmModuleIns = \ZCRMModule::getInstance("Invoices");
- $from = '2019/07/31';
- $to = '2019/09/01';
- $criteria = '((Invoice_Date:After:'.$from.') and (Invoice_Date:Before:'.$to.'))';
- $response = $zcrmModuleIns->searchRecordsByCriteria($criteria);
but i get only error message like this.
ZCRMException invalid query formed Request
i want to know how i can get data.
- // this goes well
- $zcrmModuleIns = \ZCRMModule::getInstance("Leads");
- $criteria = '((Last_Name:equals:Example) or (Email:starts_with:example@example.com))';
- //this goes well
- $zcrmModuleIns = \ZCRMModule::getInstance("Invoices");
- $criteria = '(xxxxxUser:starts_with:example)';
Rregard.
thank you.