Currencies
Returns all supported currencies in given account which should be used when saving monetary values with other objects.
Select
The add-in will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- Term supports the '=' operator.
For example, the following query is processed server side. Term can be Currencies.Name or/and Currencies.Code:
SELECT * FROM Currencies WHERE Term = 'Armenian Dram' SELECT * FROM Currencies WHERE Term = 'AFN'
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Id. | |
| ActiveFlag | Boolean | ActiveFlag. | |
| Code | String | Code. | |
| DecimalPoints | Integer | DecimalPoints. | |
| IsCustomFlag | Boolean | IsCustomFlag. | |
| Name | String | Name. | |
| Symbol | String | Symbol. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| Term | String | Optional search term that is searched for from currency's name and/or code. |