> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: CityNameFromIP

> Look up and return the city name associated with an IPv4 address in dot-decimal notation. Use for IP-based geolocation in ETL data pipelines.

## Description

Extracts the city name from a given IPv4 string (dot-decimal notation).

## Syntax

`CityNameFromIP(ipaddress)`

## Examples

`CityNameFromIP('128.193.8.81')` returns 'Corvallis'.

## Notes

The function uses GeoLite2 data created by MaxMind, available from [http://www.maxmind.com](https://www.maxmind.com/en/home)

## Return value datatype

String

## Impact of null value

If input is null, returns null.