External Data lookup

[JoC]

Hi, I was wondering if it is possible to have a lookup field that gets it’s data from an external DB, preferable via a REST web service? eg. We have another mySql DB that contains a table with all streets of my country and with a REST service on top of it. Instead of having the user to enter the street name, it would be nice if I could specify the external source in the same way as the „linked fields” for internal data but without having to import and sync the data.

[yuri]

Hi

It's possible but needs coding. It's not a difficult task. You need to customize address field view (javascript), add new API methods that will lookup address data. That API methods will connect to your external rest api. Some caching is desirable.

[JoC]

Can you specify where to customize more in detail? I don’t find it
thx