RDN Standard Lookup

The Standard Lookup feature in RDN provides predefined lookup services that cater to common data standardization needs. These lookups are designed to simplify everyday tasks such as validating and normalizing key information like Country, State, and Phone Number data.

With Standard Lookups, users can easily compare values across one or multiple columns, ensuring data consistency and accuracy. While users can view and access the lookup data, modifying existing columns or their associated values is not allowed. However, users can add new values to the lookup, and these added values will remain exclusive to their account, ensuring customization while maintaining overall consistency.

RDN offers the following Standard Lookup services:

  • RightWaveCountryLookup – Standardizes country names, codes, and related data.
  • RightWavePhoneLookup – Validates and standardizes phone numbers based on country codes.
  • RightWaveStateLookup – Provides state information based on state names.

RightWaveZipCodeLookup (Hidden Lookup) – Offers zip code and location-related data.

Key Features

  • View and Compare Data: Users can view lookup values and compare them across columns for consistency.
  • Add Custom Values: While you cannot edit existing lookup data, you can add new values to suit your needs.
  • Data Integrity: Standard Lookups maintain a consistent structure, ensuring your data remains accurate and reliable.
  • Predefined Data: Use lookups that are already set up for commonly used data, like countries and states, saving time and effort.

Use Cases

  • Data Standardization: Ensuring that country, state, and phone number data is uniform across all records.
  • Address Validation: Verifying and standardizing locations, such as cities, states, and zip codes, for accurate address data.
  • Phone Number Validation: Ensuring phone numbers are correctly formatted according to their country code.

Data Insertion and Integration

Users can insert new data into the Standard Lookup services:

  1. Manually: Add new entries to the lookup directly.
  2. Bulk Upload: Import data in bulk via CSV files, making it easier to update multiple values at once.

Additionally, users can integrate the lookup services into their systems via the API or utilize JavaScript functions for more flexibility in custom workflows.

API Details :

To access this service click on API details button, where user can use this service by using the example section. 

Headers: Users can get auth-key and Content-Type in the Headers section.

Query Parameter(s): It includes Parameter information.

Response

Instruction To Use: 

Example: We can run an example by clicking the Show Live Testcase button.

Edit: Users can add it by CSV and manually. Please note that the user can not add any new data in RWZiplookup as it is a hidden lookup.

Country Lookup List: After clicking on the edit option, the list  of RWcountrylookup will display like as below:

Delete: Standard lookup services cannot be deleted by users.

Check box uses: Upon selecting the “Show only my custom records” checkbox, the Custom Lookups created by the user will be displayed.

Export CSV: By clicking on the Export CSV button, users can export the data in CSV format.

Add Values Using Import CSV: We can add values in the Standard Lookup Service by Importing a CSV file. Added data is editable.

Add Single Record: Users have the ability to populate values in the Standard Lookup Service by utilizing the “Add Single Record” button to insert individual records.The added record is customizable.

RightWaveCountryLookup

This service helps you retrieve ISO Country Codes with ease. When you provide the country name (e.g., “United States”), the service returns the following data:

  • ISO_Name: Full country name (e.g., United States)
  • ISO_Code2: The two-letter country code (e.g., US)
  • ISO_Code3: The three-letter country code (e.g., USA)

Use Case: If you’re standardizing address data, you can use this lookup to convert country names into their corresponding ISO codes for consistency across your system.

RightWavePhoneLookup

The Phone Lookup service is designed to help you validate and retrieve phone-related information using the Country Code. For example, if you input Country_Code as “93” (which corresponds to Afghanistan), the lookup will return:

  • Country: The country name (e.g., Afghanistan)
  • ISO_Code2: The two-letter ISO code for the country (e.g., AF)
  • Country_Code: The country dialing code (e.g., 93)

Use Case: This service is helpful for validating phone numbers when you know the country code and need to confirm the country and its associated details.

RightWaveStateLookup

The State Lookup service allows you to retrieve state information based on the state name. For example, if you provide “Alabama” as input, the service will return:

  • Country: The country associated with the state (e.g., United States)
  • LongState: The state code (e.g., AL)

Use Case: This service can be used for standardizing state information in datasets, making sure all states are properly abbreviated, and ensuring consistency in your data.

RightWaveZipCodeLookup (Hidden Lookup)

This is a specialized lookup service that allows users to retrieve detailed information based on a Zip Code and City. For example, if you input:

  • Zip Code: 35004
  • City: Acmar

The service returns:

  • Zip Code: 35004
  • ZipCodeType: STANDARD 
  • City: Acmar
  • State ISO2: AL
  • State_Name: Alabama
  • Country ISO2: US 
  • Country: United States
  • LocationType: ACCEPTABLE 
  • Lat: 33.59 
  • Long: -86.49

Use Case: This service is ideal for address validation, location mapping, or any use case where you need detailed geographical information based on Zip Code and City. It helps ensure accuracy and consistency in locations across your system.

Benefits for Users

  • Data Standardization: Whether it’s for countries, states, or phone numbers, these lookups ensure all your data adheres to standardized formats.
  • Easy Integration: These lookup services are simple to use and integrate, whether you’re working manually, uploading bulk data, or utilizing APIs.
  • Customization: While the standard data cannot be modified, you can add new values that are exclusive to your setup, ensuring your specific needs are met without disrupting the overall system.

How to Use

  1. Input: Enter the key value (e.g., Country name, State name, or Zip Code) into the respective lookup field.
  2. Retrieve Results: Get standardized output, such as country codes, state abbreviations, and location data, for further use.
  3. Data Insertion: You can add your own new values if needed, but you cannot edit the core lookup values provided by RDN.

These services are designed to make managing and normalizing data straightforward, saving you time and effort while ensuring consistency across your systems.