Power BI Connector for Zoho Inventory

Build 24.0.9062

Packages

Read, Insert, Update and Delete Packages.

Table Specific Information

Select

The 本製品 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 本製品.

  • 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.

Email 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062