Packages
Read, Insert, Update and Delete Packages.
Table Specific Information
Select
The connector will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.
- Id supports the '=' comparison.
- SalesorderId supports the '=' comparison.
- CustomerName supports the '=,LIKE' comparison.
- CustomerId supports the '=' comparison.
- PackageNumber supports the '=,LIKE' comparison.
- SalesorderNumber supports the '=,LIKE' comparison.
- StatusFilter supports the '=' comparison.
- StartDate supports the '=' comparison.
- ShipmentStartDate supports the '=' comparison.
- EndDate supports the '=' comparison.
- ShipmentEndDate supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM Packages WHERE Id = '3350895000000089001' SELECT * FROM Packages WHERE SalesorderId = '7538224323'
Insert
Insert can be executed by specifying the CustomerName, SalesorderId, PackageNumber and Date column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO Packages (CustomerName, Date, LineItems) VALUES ('test22''2022-07-01', [{\"quantity\":87}])
Update
Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE Packages SET CustomerName = 'new' WHERE Id = 3249056000000197079
Delete
Delete can be executed by specifying the Id in the WHERE Clause
For example:
DELETE FROM Packages WHERE Id = '3350895000000089001'
Columns
| Name | Type | ReadOnly | References | Description |
| CreatedTime | Datetime | True |
Time at which the package was created. | |
| CustomerId | Long | True |
Unique ID generated by the for the customer. | |
| CustomerName | String | False |
Name of the customer. | |
| Date | Date | False |
Date on which package is prepared. | |
| String | True |
Email of contact person. | ||
| IsEmailed | Boolean | True |
Package is emailed to the customer or not. | |
| LastModifiedTime | Datetime | True |
Time at which the package details were last modified. | |
| Mobile | String | True |
Mobile number of the customer. | |
| Notes | String | False |
Notes for package. | |
| Id [KEY] | Long | True |
Id of package. | |
| PackageNumber | String | False |
Name of the package | |
| Phone | String | True |
Phone number of the customer. | |
| SalesorderId | Long | False |
Unique ID generated by the server for sales order. | |
| SalesorderNumber | String | True |
Name of the sales order for which package is created. | |
| TemplateId | Long | True |
Unique ID generated by the server for the template used for package. | |
| TemplateName | String | True |
Name of the template. | |
| TemplateType | String | True |
Type of template. | |
| TotalQuantity | Integer | True |
Total quantity in the package. | |
| LineItems | String | False |
Details of the items in this package |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| StatusFilter | String |
Filter the packages by status. 使用できる値は次のとおりです。Status.All, Status.NotShipped, Status.Shipped, Status.Delivered |
| StartDate | Date |
Used for searching packages from specified date |
| ShipmentStartDate | Date |
Used for searching packages from specified date of Shipment |
| EndDate | Date |
Used for searching packages till specified date |
| ShipmentEndDate | Date |
Used for searching packages till specified date of Shipment |