Skip to main content

I am trying to write some basic calls for collecting reporting data from the Company object using the API and have found that it is not natively possible to collect converted ARR from the API. Support recommended that we create a custom field that holds converted_Arr and or the conversion rate. The problem with this is that it is useful to be able to just call any currency field and sort on normalized data before returning results. 

Example I want to pull the top 25 companies by ARR in base currency. I want the API to spit out 25 results, not all results, then convert them, then filter again. Also setting up a secondary converted field for every currency field is error prone and an unnecessary waste of database storage and computational resources. And it is prone to error since this would need to be stored individually in every native and custom object. 

 

I would love for it to be natively possible in the api to simply have a call include a .converted field transformation or derived field such as:

"select": "

    "Gsid",

    "Name",

    "Arr",

    “Arr.converted”,

    "CurrentScore.Name"

  ]

 

This would ideally convert to the corporate currency defined in the currency management. Alternately it would be helpful to be able to convert to any currency in the currency manager (ie Arr.USD, Arr.SEK, Arr.GBP).

 

This would ideally also function on all APIs with all objects.

Be the first to reply!