Power BI Connector for Zoho Inventory

Build 24.0.9062

Organizations

Get list of Organization

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

  • OrganizationId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Organizations WHERE OrganizationId = '3350895000000089001'

Insert

Insert can be executed by specifying the Name, CurrencyCode, PortalName and TimeZone 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 Organizations (Name, CurrencyCode, PortalName, TimeZone) VALUES ('Test', 'USD', 'newportal', 'PST')

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 Organizations SET Name = 'test2' WHERE OrganizationId = '3285934000000136008'

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM Organizations WHERE OrganizationId = '3350895000000089001'

Columns

Name Type ReadOnly References Description
OrganizationId [KEY] String True

ID of the organisation generated by the server.

AccountCreatedDate Date True

Date of creation of the account.

Name String False

Name of the Organisation.

Address String False

Billing address of the organisation

CurrencyCode String False

Code of currency.

Country String True

Country of Organization.

IsLogoUploaded String True

Boolean to check if logo of the organisation if available.

UserRole String True

Role of the user(s).

DateFormat String False

Format of Date.

FieldSeparator String False

Separator used to classify fields.

UserStatus String True

Status of the user.

ContactName String True

Name of the contact person of the organisation.

IndustryType String False

Business type.

CurrencyFormat String True

Format of currency.

CurrencyId String True

Id of currency.

CurrencySymbol String True

Symbol of currency.

Email String True

email.

FiscalYearStartMonth String False

Starting month of teh financial year.

IsDefaultOrg Boolean True

IsDefaultOrg.

IsOrgActive Boolean True

IsOrgActive.

LanguageCode String False

Language for use.

PortalName String False

Poratal name for the organisation.

PlanName String True

PlanName.

PlanPeriod String True

PlanPeriod.

PlanType Integer True

PlanType.

PricePrecision Integer True

PricePrecision.

TaxGroupEnabled Boolean True

TaxGroupEnabled.

TimeZone String False

Time zone in with the organization is located geographically..

OrgAddress String False

Billing address of the organisation

RemitToAddress String False

Shipping address of the organisation

IndustrySize String True

The size of the industry. The possibe values could be

使用できる値は次のとおりです。small scale, medium scale, large scale

ZiMigrationStatus Integer True

ZiMigrationStatus.

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