CreateExchangeRateQuote
Creates an exchange rate quote for one or more currency pairs.
Stored Procedure Specific Information
The CreateExchangeRateQuote Stored Procedure requires following fields to execute:
- QuoteItems
EXEC CreateExchangeRateQuote QuoteItems='[{\"base_currency\": \"USD\",\"base_amount\": \"16.80\",\"quote_currency\": \"GBP\",\"markup_percent\": \"1\"}]'
Input
| Name | Type | Required | Description |
| Organization | String | False | The organization of the quote. Identifies the calling client. |
| QuoteItems | String | True | A JSON array of quote items. Each item requires base_currency and quote_currency, and optionally base_amount, markup_percent, and fx_id. |
Result Set Columns
| Name | Type | Description |
| Success | String | Whether the exchange rate quote was successfully created. |
| ExchangeRate | Double | The exchange rate from the base currency to the quote currency. |
| FxId | String | The FX identifier for the quote item. |
| BaseAmountCurrencyCode | String | The ISO-4217 currency code of the base amount. |
| BaseAmountValue | Double | The base amount value. |
| QuoteAmountCurrencyCode | String | The ISO-4217 currency code of the quoted amount. |
| QuoteAmountValue | Double | The quoted amount value in the destination currency. |
| ExpiryTime | Datetime | The date and time when the exchange rate quote expires. |
| RateRefreshTime | Datetime | The date and time when the exchange rate was last refreshed. |
| UpdateTime | Datetime | The date and time when the quote was last updated. |