Hi all,
This is probably a dumb question, but I kindly ask your help to understand the way forward…
I need to fetch data from an external source to a Grist table. The external source is read only, so I just need to import the table and keep it updated, automatically once per day.
The data from the external source has an alphanumeric primary key. I would like to create a Grist table that I could use as a reference from other tables.
I am searching for the simplest and automatic possible solution (eg. cron script?), we are in rather tight intranet, so I cannot use external services (eg. N8N).
I can fetch the data from my intranet only with something like:
curl -X GET "https://wauc-test.dipvvf.it/api/Personale?codiciSede=AB" -H "accept: application/json"
or simply browsing to:
https://wauc-test.dipvvf.it/api/Personale?codiciSede=AB
The response is a JSON string like this (this data is redacted of course):
[
{
"codiceFiscale": "RSSMRI84L20C546K",
"cognome": "ROSSI",
"nome": "MARIO",
"accountDipvvf": "rossi.mario",
"emailVigilfuoco": "rossi.mario@vigilfuoco.it",
"qualifica": {
"nome": "VCSC",
"gruppo": {
"codice": "1",
"descrizione": "VIGILI DEL FUOCO"
},
"codSettore": null,
"codice": "505",
"descrizione": "VIGILE DEL FUOCO COORDINATORE SCATTO CONVENZIONALE"
},
"sede": {
"id": "GE.2002",
"codice": "GE",
"codDistaccamento": "2002",
"descrizione": "Vattelapesca"
},
"specializzazioni": [
{
"codice": "AM3",
"descrizione": "AUTISTA DI 3^ GRADO",
"dataInizioValidita": "19/04/2021",
"dataFineValidita": "19/04/2031"
}
],
"turno": "A",
"saltoTurno": "2",
"tipoPersonale": {
"codice": "2",
"descrizione": "OPERATIVI"
}
},
...other records...
]
In this case the codiceFiscale
field is the primary key.
Thank you in advance,
Emanuele