Location IQ
4 minutes to readWith the Location IQ extension, you can retrieve detailed geolocation data: latitude and longitude, as well as formatted addresses and location metadata. The extension uses the Google Maps Geocoding API to return accurate and structured data directly into your Caspio tables, with no coding required.
Using Location IQ
Prerequisites: Install the extension.- On the list of extensions, click Open next to Location IQ.
- On the Agents screen, click Create Agent.
- In the Details step:
- Enter a name for your agent.
- Select a profile for this agent. Click Next.
- In the Trigger step, choose the data source and the event type that will activate this agent. Click Next.
- In the Outgoing Data Items step, define the data that you want to send to the extension:
If… Then… If you want to obtain geographic coordinates by providing address data, - From the Geolocation conversion dropdown, select Standardize and convert an address into geographic coordinates.
- In the respective fields, provide fields storing the respective address data. Mandatory fields are: Address line 1, City, and Country.
- Click Next.
If you want to obtain address data by coordinates, - From the Geolocation conversion dropdown, select Reverse geocode lat/long values into a structured address.
- In the Latitude and Longitude fields, select the relevant fields from your data source.
- Click Next.
- In the Incoming Data Items step, map the geolocation results to your table fields. All fields are optional, so by configuring fields, you select which values will be returned by the extension.
- Save the agent by clicking Create.
Outgoing Data Items
Configure the fields that will be used to send data to the Google Maps API. The following two options are available as Geolocation conversion:
- Standardize and convert an address into geographic coordinates: Allows you to send address data to the extension in order to retrieve coordinates.
- Reverse geocode lat/long values into a structured address: Allows you to provide latitude and longitude to reverse geocode and retrieve the closest known address and place name.
The selected geolocation conversion type determines which fields are visible in the Outgoing data items section of the Agent configuration.
Incoming Data Items
Configure the fields in your Caspio table where the geolocation results from the Google Maps API will be stored. All fields listed below are available for selection. Provide the destination fields for the data that you want to receive, given the outgoing data items sent to the extension.
- Latitude: Latitude in decimal degrees.
- Longitude: Longitude in decimal degrees.
- Full formatted address: The complete, human-readable address returned by the API. Required when coordinates are selected as the input.
- Address line 1: The primary street address component.
- Address line 2: Additional address info such as apartment, suite, building, or floor.
- City: Name of the city or town.
- State or province: The region, state, or province.
- ZIP/Postal code: Postal or ZIP code of the location.
- ZIP+4: A 4-digit zip code suffix to identify a more precise location, such as a city block or individual building. Used only in the United States. This field gets populated only if Google Maps has data available.
- Country: Country name from the geolocation result.
- Location type: Indicates the precision of the result. Possible values:
- ROOFTOP: Exact street address
- RANGE_INTERPOLATED: Estimated between two known points (for example, along a road)
- GEOMETRIC_CENTER: Center point of an area (for example, a park or city block)
- APPROXIMATE: General area only
- Bounds: A Plus Code (Open Location Code) that defines a region around the coordinates, which can serve as a digital address.
- Partial match: Indicator for approximate or incomplete geocodes:
- true: The result may be inexact due to missing or ambiguous input.
- false: The result is an exact match.
- Request status: Displays the outcome of the request—either “Success” or a specific error message.
Resource Usage
This extension uses two types of resources:
- Credits – each geolocation task consumes 1 Credit. See Caspio Credits.
- Integrations calls – Each geolocation task triggers 3 integration calls:
- One to send the request
- One to store the response
- One to log the activity