TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Currency Conversion / Exchange Rate
Hi Folks
Just wondering what everyone does on TeamDesk to pull live currency exchange rates to do currency calculations?
I imagine some kind of live feed for that. I have search the forums and it looks like it hasnt been discussed before which I find strange, but regardless... Anyone got any direction on this matter please? Maybe theres an RSS feed or something I haven't found yet, but i imagine many need live currency conversion

Date Created
3/8/2023 3:55:36 AM
Date Updated
6/7/2023 3:53:30 AM
basenine 3/8/2023 4:21:04 AM
Here’s a request from a while ago.
I’m not sure what the outcome was

Add Currency Features
calvin peters 3/10/2023 8:58:29 AM
This callURL example that TeamDesk put together as a demo for callURL action implementation I think has what you're looking for...maybe...
They just hppened to use a currency conversion API in the example.
JonnyGee 3/12/2023 2:59:20 PM
Hi Guys. Thanks for this, but I am not sure how I am suppose to integrate it into my dB.
For example.... I have a Purchase Order Table/Form that I want to have a column there, that pulls through the current exchange rate and the time, a Currency Type is selected from a dropdown.....
Also... Whats the difference between the XML, Json, Text Currencies?
calvin peters 3/13/2023 1:22:38 PM
>> Whats the difference between the XML, Json, Text Currencies?

Those are just the way data is packaged for retrieval.
XML loks alot like HTML values inside tags read like an information tree
<oem_body_style>Cargo Van</oem_body_style>

Tags are open <...> and then closed</...>
Everything between the two tags is referenced using the id inside the tag.. using Response() function in ASSIGNMENTS section like:

FROM: If(Response("drive_type")="4X4","4WD",Response("drive_type")="4X2","2WD",Response("drive_type")) TO: [your column name]
So this looks in the tag <drive_type> shown above and the formula If(...) conditionally rolls over the conditions inside to either put "4WD", "2WD" or in this case "FWD" into [your column name]. If I wanted data for "doors" stored in my column then Response("drive_type") would become Response("doors") and the surrounding formula would do the rest for 'normalizing' it for my use case.

JSON is a different way of storing and referencing data with key:value pairs. So in simple terms a 'key' is the reference for the 'value' you want to reference.
"Id": "XXXCVBG",
"Code": null,
"Digit": "35DJG",
"Year": "2016"
So in the top line key:value pair, the 'key' is "id" and it's 'value' is "XXXCVBG"

But the response is still handled in the ASSIGNMENTS section.

TEXT is just another data type to be dealt with.

Use Response() function inside your CallURL to map the reponse data to your column in your db.
<%=...%> are used to allow reference to various functions and formulas to help manipulate your reponse using TD.

The data type you get returned is determined by the API for your source different Google open source API's for example.

It appears that the db that example is aimed at has been depricated but the setup should help you understand this better.

Your db should have an "Integration API" link in your DATABASE tab in SETUP mode where you can use the builtin REST API Playground to experiment with some of this stuff to better understand it.

Also, the TeamDesk support is an absolutly invaluable resurce for assistance. Can't say enough about the team there. They have performed wonders in assisting me and they have never left me wanting when called upon.
Simply the best support team I've encountered.

Tell them where you're stuck and they will lean in hard (in my experience anyway).
They want you to succeed and they're there to help you do that.

Best of luck

Jorge Solá 6/7/2023 3:53:30 AM
Hi, Jonny.

I have a database where I pull from the Internet (from the current currency exchange rate in order to convert values in any currency to USD.

Let me know if you already figured out how to do it, If you didn't, I will explain in detail how I did it.
Back to Search Results