MySQL integration with IP2Location
How to Query IP2Location for IPs stored in new MySQL and add geolocation data to a new table row
Steps to automate
Use Nekton workflow automation service.Preparation
Create Nekton account. You can also use your existing Google account
to sign in.
Create automation
-
Click on the "Create new workflow" button, and then add "Automated step".
-
Set the step description to "Query IP2Location for IPs stored in new MySQL and add geolocation data to a new table row" and then click on "Automate".
-
Provide the necessary parameters and click on the "Test it" button to check your automation. If you had issues with it, you can click on "Automate" again to try a different one.
Create a schedule (optional)
If you want to run this automation on a schedule, click on the gear button on the workflow editor
screen
to configure it. For example, you can run this flow every hour or every day.
Automate IP2Location integrations
IP2Location actions
Nekton can use any feature that is available in IP2Location API.
Using our advanced AI, you can easily create custom automations for IP2Location.
Here are some typical actions you can do in your automated workflows.
Lookup IP Address by Package
Finds geolocation info about an IP address like city, country, timezone. Select package for varying levels of information.
About IP2Location
IP2Location is a non-intrusive geo IP solution to help you to identify a visitor's geographical location.