Crafting front end using Coherent Validation API

05:52 mins
D

Donald lui

Updated on Mar 27, 2025

Creating a Front End with Coherent APIs

Hey, how's it going? It's Donald from Coherent. Today, we want to talk about how we can use the Coherent APIs to craft a front end for us to use. From our previous video, we have created a Home Raider, which is an existing service on the Coherent platform.

Utilizing Coherent APIs

If you want to utilize the API, you can input various types of input and hit submit. To call the API, simply go to the endpoint and provide the required information.

Crafting a Front End for Coherent Spark

To craft a front end for Coherent Spark, we introduce a tool we internally use called Retool. Retool allows us to build a front end while the back end calls various types of inputs from Coherent Spark.

Understanding the Front End

  • The front end is built on Retool.

  • It includes inputs similar to those on the API itself, such as year built and territory.

  • Completing every field and hitting rate on Coherent will execute APIs and return results.

Building the Page

Often, the question arises whether you have to manually input every field. For example, when selecting a territory, various options appear. These dropdowns are inherited from the Excel file uploaded to the Coherent platform.

Using the Validation API

To achieve dropdown values dictated by Coherent Spark, call the validation API on our platform. This API extracts static and dynamic validations from the Spark service.

Backend of Retool

  • Create applications without going into details about individual text boxes.

  • Focus on fields like territory, where dropdowns show up due to the validation API.

Validation API Functionality

The validation API returns a list of validated fields for input. For example, in the Home Raider service, it returns valid values for each input, such as whole number and min-max value. For territory, it provides the entire option list.

Mapping Values in Retool

Within Retool, map values together by calling the home cat default value and returning the dropdown list from the API call. Another API call handles the execute function, mapping values to what Coherent Spark expects.

Executing the Application

  • Clicking the execute button sends the rating on Coherent.

  • The validation API helps set up the front end based on set validations and fields.

Dynamic Updates with Excel

The front end is dictated by the Excel file, allowing fields to update programmatically when the Excel file changes. For example, adding territory numbers in the Excel file updates the field automatically.

Conclusion

Using the Validation API and execute APIs provides an easy way to view available values without building them from scratch. Hope this helps, and see you next time.