Ask AI
Skip to main content

Get data format attribute type

Function: Get Data Format Attribute Type​

This action helps you understand the kind of information a specific field (called an "attribute") holds within one of your application's data structures (called a "data format"). For instance, you can use it to determine if a field is designed to store text, numbers, dates, or other types of data. This is useful when you need to ensure data consistency or perform operations that depend on the data type.

Input​

  • Data format: The main data structure you want to inspect. Think of this as a table or a collection of related information, like "Products" or "Customers."
  • Attribute: The specific field within the chosen data format whose type you want to find. For example, if your "Products" data format has fields like "Product Name," "Price," or "In Stock," you would select one of these. The available attributes will change based on the "Data format" you select.

Output​

  • Type: A piece of text that tells you the data type of the selected attribute. This could be "STRING" (for text), "NUMBER" (for whole numbers), "DOUBLE" (for numbers with decimals), "DATE" (for dates), "BOOLEAN" (for true/false values), or other specific types.

Execution Flow​

Real-Life Examples​

Here are some examples of how you can use the "Get Data Format Attribute Type" action:

Example 1: Checking a Product Name's Type​

Imagine you have a "Products" data format, and you want to confirm that the "Product Name" field is indeed set up to store text.

  • Inputs:
    • Data format: Products
    • Attribute: Product Name
  • Result: The action returns STRING, confirming that the "Product Name" field is designed for text.

Example 2: Verifying an Order Date's Type​

You're working with an "Orders" data format and need to ensure that the "Order Date" field is correctly configured as a date type before performing any date calculations.

  • Inputs:
    • Data format: Orders
    • Attribute: Order Date
  • Result: The action returns DATE, indicating that the "Order Date" field stores date values.

Example 3: Discovering a Price Field's Type​

You have a "Services" data format and want to know if the "Price" field can handle decimal values or only whole numbers.

  • Inputs:
    • Data format: Services
    • Attribute: Price
  • Result: The action returns DOUBLE, letting you know that the "Price" field can store numbers with decimal points.