Networks and files

The following generators produce values related to network locations and files.

For more information about these generators and how to configure them in the application, go to Networks and files in the generator reference.

File Type Extension

Populates the column with a file extension. For example, .txt or .docx.

Uses the General column configuration.

File Type MIME Type

Populates the column with a file MIME type. For example, text/plain or image/jpeg.

Uses the General column configuration.

IP Address

Populates the column with an IP address. For example, 192.168.1.100 or 2001:0db8:0000:0000:0000:0000:1a2b:3c4d.

{ 
  "name": string,
  "data_type": string,
  "generator": "IP Address",
  // Generator-specific fields
  "ip_address_version": "ipv4"|"ipv6", // Type of IP address to generate
  // End generator-specific fields
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

MAC Address

Populates the column with a MAC address. For example, 00:1A:2B:3C:4D:5E.

{ 
  "name": string,
  "data_type": string,
  "generator": "MAC Address",
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Project Name

Populates the column with the name of a project.

{ 
  "name": string,
  "data_type": string,
  "generator": "Project Name",
  // Generator-specific fields
  "include_random_project_number", boolean, // Whether to append a random number
  // End generator-specific fields
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

URL

Populates the column with a URL. For example, https://example.com.

{ 
  "name": string,
  "data_type": string,
  "generator": "URL",
  // Generator-specific fields
  "protocol": boolean, // Whether to include the protocol
  "domain": boolean, // Whether to include the domain
  "path": boolean,  // Whether to include the path
  "filename": boolean,  // Whether to include the filename
  "query": boolean,  // Whether to include a query
  // End generator-specific fields
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

User Agent

Populates the column with a user agent value. For example, Mozilla/5.0 (Windows NT 10.0; Win64; rv:110.0.

{ 
  "name": string,
  "data_type": string,
  "generator": "User Agent",
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}