Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ENWORK and version Documentation
Section
Column
width900px
Table Filter
defaultBeschreibung
isFirstTimeEnterfalse
hideColumnstrue
sparkNameSparkline
hidePanetrue
datepatterndd M yy
id1624265083949_548533710
worklog365|5|8|y w d h m|y w d h m
isORAND
separatorPoint (.)
order0
Multiexcerpt
MultiExcerptNameipinfo
Table Transformer
dateFormatdd M yy
export-wordfalse
show-sourcefalse
export-csvfalse
id1624265083952_1227260180
transposefalse
worklog365|5|8|y w d h m|y w d h m
separator.
export-pdffalse
sqlSELECT * FROM T*

KeyFormat

...

CNDDescriptionBeschreibung
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=

Multiexcerpt include
SpaceWithExcerptEN
MultiExcerptNameBaseURL
PageWithExcerptWording
schemas

Multiexcerpt
MultiExcerptNameschema
Code Block

...

language

...

json
linenumberstrue
{
    "$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

Multiexcerpt
MultiExcerptNamesample
Code Block

...

language

...

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


Table of Contents