Reference Data API

Reference API is a microservice designed to populate UI dropdown lists in real-time with relationship support. Try the link for a demo react-schema-form.

In the above form, you have to select a country before the province is populated from the reference API. Once a province is select, the cities in the province will be populated in real-time. The category and subcategory have a similar relationship.

Update Reference Table

SQL Update

Unlike most APIs with NoSQL databases, Reference API has a SQL database for storage. In the light-reference repository, there is ref.sql, which is the source for the production reference. To execute the ref.sql on test4 or prod4, follow the steps below. Copy the ref.sql to the remote server cd ~/networknt/light-reference scp ref.sql prod4:/home/[userid]/ref.sql ssh to the test4 or prod4 and copy the file into the MySQL docker container ssh prod4 docker ps docker cp ref. Read More »