Update the unit conversions for fields in the job. Currently, supported unit types include timezones and currency:

  • Supported timezones include all 38 observed UTC offsets around the world. For example, UTC_m12 refers to UTC -12 and UTC_p4 refers to UTC +4.
  • Supported currencies include USD, NZD, AUD, CAD, SGD, GBP, EUR, INR, CNY, JPY, and IDR.

For fields that use currency conversion, you can either choose to use the latest exchange rates we have available, or specify a reference datetime column to determine the desired historical exchange rates for each row. Daily historical rates are available starting from January 1, 2012. The latest rates are fixed for a 24-hour period and are refreshed every day at 00:15 AM UTC +0.

Click Try It! to start a request and see the response here!