Hi all, has anyone synced openrouteservice outputs into a Notion database using the Notion API? I want to log runs from directions, isochrones, or matrices in a table with fields like origin, destination, profile, distance, duration, plus a link or attachment for the GeoJSON.
My use case is a small field-service team that plans daily routes and needs a simple audit trail in Notion so non-technical teammates can review plans, tag jobs, and comment. Any tips on what to store, file vs text for GeoJSON, and practical size limits would be super helpful.
Hey,
what to store depends primarily on your use case, so I’m afraid there is nothing we could help you with.
As for the GeoJSON; if Notion provides any form of “geographical” data type, then that is preferrable.
If it does not, but supports JSON, then that is preferrable.
Otherwise, it depends again on your use case, but probably text is good enough.
Practical size limits again depend on your use case, especially on the extra information you are requesting (influencing the size of the GeoJSON) and the length of your routes/sizes of your isochrones/sizes of your matrices.
I’d suggest doing a few realistic test queries, estimating usage and then scaling accordingly.
Best regards