Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...


KeyFormatCNDDescriptionBeschreibung
1

ipAddress

string

M

IP address

IP-Adresse
2

country

object

M

Country of IP origin

Land der IP-Herkunft
3

state

string

C

States and provinces (that is, the first-level administrative division) in all countries where they exist

Bundesstaaten und Provinzen (das ist die erste Ebene der administrativen Gliederung) in allen Ländern, wo es sie gibt
4

city

string

M

City, localized spelling

Stadt in lokaler Schreibweise
5

longitude

string

M

The longitude of the identified location, expressed as a floating point number with range of -180 to 180, with positive numbers representing East and negative numbers representing West

Geographische Länge des ermittelten Ortes als Gleitkommazahl im Bereich von -180 to 180, wobei positive Zahlen Osten und negative Zahlen West bedeuten
6

latitude

string

M

The latitude of the identified location, expressed as a floating point number with range of -90 to 90, with positive numbers representing North and negative numbers representing South. Latitude and longitude are derived from the city or postal code.

Geographische Breite des ermittelten Ortes als Gleitkommazahl im Bereich von -90 to 90, wobei positive Zahlen Norden und negative Zahlen Süden bedeiten. Breite und Länge werden von der Stadt oder der Postleitzahl ausgehend ermittelt.

Schema

(info) BASEURL= https://www.payjet-cockpit.de/schemas

{
    "$schema": "http://json-schema.org/draft-07/schema#",
    "$id": "BASEURL/ipInfo.json",
    "title": "ipInfo",
    "description": "IP Information",
    "type": "object",
    "properties": {
        "ipAddress": {
            "type": "string",
            "oneOf": [{"format": "ipv4"},{"format": "ipv6"}]
        },
        "country": {
            "type": "object",
            "properties": {
                "countryName": {
                    "type": "string"
                },
                "countryA2": {
                    "type": "string",
                    "minLength": 2,
                    "maxLength": 2
                },
                "countryA3": {
                    "type": "string",
                    "minLength": 3,
                    "maxLength": 3
                },
                "countryNumber": {
                    "type": "string",
                    "minLength": 3,
                    "maxLength": 3
                }
            },
            "required": ["countryName", "countryA2", "countryA3", "countryNumber"],
            "additionalproperties": false
        },
        "state": {
            "type": "string"
        },
        "city": {
            "type": "string"
        },
        "longitude": {
            "type": "string"
        },
        "latitude": {
            "type": "string"
        }
    },
    "required": ["ipAddress", "country", "city", "longitude", "latitude"],
    "additionalproperties": false
}

Sample

{
    "ipAddress": "178.37.173.82",
    "country": {
        "countryName": "poland",
        "countryA2": "pl",
        "countryA3": "pol",
        "countryNumber": "616"
    },
    "state": "wielkopolskie",
    "city": "poznan",
    "longitude": "16.83739",
    "latitude": "52.4136"
}