Currency exchanges / API
Hi, I am trying to update currency rates on a daily basis with an API from the following endpoint. https://api.exchangerate-api.com/v4/latest/USD I currently have a Table called Currenices -> Ex...
Forum Discussion
API_ImportFromCSV will let you combine your EditRequests into one call. You build it like it sounds - where the data object is like a CSV file - and as long as you're passing in the RID as one of the data points in each row - you can update the currencies in one go.
So depending on how you're handling it in Azure - you'll basically have to map the response from the Currency endpoint and associate each currency with the right Record ID - and the POST the import call back to Quick Base
Chayce Duncan | Technical Lead
(720) 739-1406 | [email protected]
Quandary Knowledge Base
So depending on how you're handling it in Azure - you'll basically have to map the response from the Currency endpoint and associate each currency with the right Record ID - and the POST the import call back to Quick Base
Chayce Duncan | Technical Lead
(720) 739-1406 | [email protected]
Quandary Knowledge Base
Hi Chayce,
Thanks for your responds.
It sounds like the best way, but I would then have to export the table from QB into Azure in order merge the tables.
Which API call would be the best for extracting an entire table into azure ?
The logic will look something like this:
A) Call Currency endpoint & create csv table
B) Export the QB table to Azure and join with the currency table
C) Create post request to QB with the merged table using API_ImportfromCSV
Best regards
Shadi
Thanks for your responds.
It sounds like the best way, but I would then have to export the table from QB into Azure in order merge the tables.
Which API call would be the best for extracting an entire table into azure ?
The logic will look something like this:
A) Call Currency endpoint & create csv table
B) Export the QB table to Azure and join with the currency table
C) Create post request to QB with the merged table using API_ImportfromCSV
Best regards
Shadi