JDBC Driver for Zoho CRM

Build 22.0.8462

Currencies

Get, add or update currencies to your organization.

Table-Specific Information

Select

The driver uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.

  • Id supports '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Currencies WHERE Id = '1234';

Insert


INSERT INTO Currencies (ISO_Code, Name, ExchangeRate) VALUES ('1234', 'hello','1.000');

Bulk Insert operation:

INSERT INTO Currencies#TEMP (id, Name, Symbol, IsActive, ExchangeRate, FormatDecimalSeparator, FormatThousandSeparator, FormatDecimalPlaces, PrefixSymbol, ISO_Code) VALUES ('4150868000000236307', 'cdata1','$','true','1.0000','period','comma','2','true','2');

INSERT INTO Currencies#TEMP (id, Name, Symbol, IsActive, ExchangeRate, FormatDecimalSeparator, FormatThousandSeparator, FormatDecimalPlaces, PrefixSymbol, ISO_Code) VALUES ('1234', 'cdata','$','true','2.0000','period','comma','3','true','3');

INSERT INTO Currencies (id, Name, Symbol, IsActive, ExchangeRate, FormatDecimalSeparator, FormatThousandSeparator, FormatDecimalPlaces, PrefixSymbol, ISO_Code) SELECT id, Name, Symbol, IsActive, ExchangeRate, FormatDecimalSeparator, FormatThousandSeparator, FormatDecimalPlaces, PrefixSymbol, ISO_Code FROM currencies#TEMP; 

Required fields: Name, ISO_Code, ExchangeRate.

Any field which is not read-only (ReadOnly = false in the table below) can be inserted.

Update


UPDATE Currencies SET symbol = 'hello', FormatDecimalSeparator = 'period', FormatThousandSeparator = 'comma',FormatDecimalPlaces = '2',prefixsymbol = 'true',exchangerate = '1.0000' WHERE Id = '1234';

Bulk Update Operation:

UPDATE Currencies SET symbol = '$',FormatDecimalSeparator = 'period',FormatThousandSeparator = 'comma',FormatDecimalPlaces = '2';

Required fields: Id.

Any field which is not read-only (ReadOnly = false in the table below) can be updated. NOTE: if Id field is not specified in the query, PostData will be created for each id ( driver will execute bulk update operation for each currency id).

Columns

Name Type ReadOnly Description
Id [KEY] String True

Represents the unique ID of the currency.

Name String False

Represents the name of the currency.

Symbol String False

Represents the symbol of the currency.

IsActive Boolean False

Represents the status of the currency.

ExchangeRate Double False

Represents the exchange rate of the currency.

FormatDecimalSeparator String False

The decimal separator separates the integer part of the currency from its fractional part.

FormatThousandSeparator String False

The thousand separator separates groups of thousands in a currency.

FormatDecimalPlaces String False

Represents the number of decimal places allowed for the currency.

ModifiedByName String True

Represents the name of the user who last modified the currency details.

ModifiedByid String True

Represents the ID of the user who last modified the currency details.

PrefixSymbol Boolean False

Represents if the currency has a prefix symbol.

IsBase Boolean True

Represents if the currency is the base currency.

CreatedAt Datetime True

Represents the date and time at which the currency was created.

ModifiedAt Datetime True

Represents the date and time at which the currency was last modified.

ISO_Code String False

Represents the ISO code of the currency.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462