Currency: insert values directly into currency_currency_rate table with SQL or REST API?

[pocock (Daniel Pocock)]

Is it safe to use SQL to INSERT new rows directly into the table currency_currency_rate without going through the UI?

Alternatively, can this be done through the REST API?

[ced (Cédric Krier)]

@pocock

Is it safe to use SQL to INSERT new rows directly into the table currency_currency_rate without going through the UI?

No because you skip all the data validation.

@pocock

Alternatively, can this be done through the REST API?

You can use JSON-RPC or XML-RPC. You can also use proteus as facility.

But it is probably better to make a module like the currency_* to automate the fetch from the source.