NetSuite REST Azerion icon

NetSuite REST Azerion

Call NetSuite SuiteTalk REST operations.

Actions981

Consolidated Exchange Rate → Insert or update record

AI-generated

Summary

Update or insert a Consolidated Exchange Rate record in NetSuite via PUT /consolidatedExchangeRate/{id}.

Inputs

  • id (required) — External identifier. Required. Maps to the {id} in the URL path.
  • isDebugMode — Whether to include full request and response info in the output. Default: false.
  • authMethod — Authentication method. Options: oauth1 (default), oauth2.
  • X-NetSuite-Idempotency-Key — A user-defined unique idempotency key for asynchronous requests (RFC 4122 UUID format). Only one request executes per unique key.
  • replace — Comma-delimited names of sublists on this record. All sublist lines will be replaced with lines specified in the request.
  • replaceSelectedFields — If true, all fields to be deleted in the update request must be included in the 'replace' query parameter. Default: false.
  • customFields — List of custom fields to assign to the record. Multiple values allowed. Each entry includes field name, type, and value.
  • isPeriodClosed — If checked, the accounting period is closed. Default: false.
  • periodStartDate — The date on which the accounting period began. Type: dateTime. Default: empty.
  • isDerived — If checked, the exchange rate is indirect (set by system for subsidiaries more than one hierarchical level removed). Default: false.
  • isEliminationSubsidiary — If checked, the subsidiary is an elimination subsidiary; rates for this subsidiary cannot be edited. Default: false.
  • fromCurrency — From currency, specified by internal identifier or external identifier.
  • fromSubsidiary — From subsidiary, specified by internal identifier or external identifier.
  • toCurrency — To currency, specified by internal identifier or external identifier.
  • toSubsidiary — To subsidiary, specified by internal identifier or external identifier.
  • averageRate — Average exchange rate. Calculated from weighted average of exchange rates for transactions applied during the period to accounts with a general rate type of Average.
  • currentRate — Current (ending) exchange rate. Based on the currency exchange rate effective at the end of the reported period.
  • historicalRate — Historical exchange rate. Calculated from weighted average for accounts with a general rate type of Historical. Used for equity accounts.
  • postingPeriod — Posting period, specified by internal identifier or external identifier.
  • Prefer — Server behavior requested by the client. Use 'respond-async' to execute the request asynchronously.
  • X-NetSuite-PropertyNameValidation — Sets strictness of property name validation. Options: (empty), Error, Warning, Ignore. Default: empty.
  • X-NetSuite-PropertyValueValidation — Sets strictness of property value validation. Options: (empty), Error, Warning, Ignore. Default: empty.

Output shape

The NetSuite API response for the consolidated exchange rate record, typically containing the updated record details.

With isDebugMode enabled, full request and response information is included in the n8n item output.

Examples

Example 1: Insert or update a consolidated exchange rate record with specified rates and subsidiaries.

Set id to the external identifier, configure fromCurrency/fromSubsidiary, toCurrency/toSubsidiary, and set averageRate or currentRate as needed. Enable isDebugMode if full API interaction details are required.

Links

Discussion