Python script for Google Sheets Neptyne plugin to find lat-lon with pdok

query_pdok.py

import re
import requests
import urllib


PDOK = "https://api.pdok.nl/bzk/locatieserver/search/v3_1/free"


def query_pdok(query):
    query_params = {
        "fl": "id nummeraanduiding_id centroide_ll huisnummer postcode",
        "fq": "type:adres",
        "df": "tekst",
        "start": 0,
        "rows": 1,
        "sort": "score desc,sortering asc,weergavenaam asc",
        "wt": "json",
    }
    params = urllib.parse.urlencode(
        {**{"q": query}, **query_params}, quote_via=urllib.parse.quote
    )
    return [
        re.findall(
            "\d+\.\d+",
            requests.get(PDOK, params)
            .json()
            .get("response")
            .get("docs")[0]
            .get("centroide_ll"),
        )
    ]