If you use Avangate as your payment processing partner you may need to download their current currency rates so that you can present the same rate conversion to your customers on your site. Avangate implement a simple XML based API where the following URL returns an XML Document containing the rates.
https://secure.avangate.com/content/exchange-xml.php?CURRENCY=USD
With Data Synchronsiation Studio you can implement a Synchronisation Import job to import this in about 2 minutes. Simply connect with the XML Provider and Specify the URL and Item XML XPath of //currency
Add 2 Columns csymbol and crate
And that is it preview the Data and setup the Synchronisation job to your Database.
Would you like to try Data Sync and Ouvvi for your Data Integration projects?
or DOWNLOAD NOWRecent Blogs
- Data Sync Projects vs Traditional Blocky Workflows
- Data Sync Avangate/2Checkout Connector
- Data Sync Mailchimp Connector
- Deploying Ouvvi + Data Sync on Windows 10
- Email Address Validation via ZeroBounce
- Ouvvi DevOps
- Pivot DataSource Columns into Rows
- Summer 2018 Release
- Dynamics 365 - Slow Discovery Service
- Configuration Management
- Web API to Start SSIS Package
- Managing SSIS Packages
- Announcing Ouvvi V4!
- Migration from AWS to Microsoft Azure SQL DB
- For Each File Handler
- Ouvvi's New Connection Library
- Ouvvi v3 and Azure SQL DB Outage