I’m doing a series of rather large matrices to my local host, and I’m getting everything back ok. The file that is returned isn’t very conducive to import into excel or some other sort of spreadsheet without a lot of manipulation prior to the import.
Return from the api playground example.
{“distances”:[[0,87.53,1512.82,6400.59],[86.86,0,1482.67,6370.44],[1479.87,1450.08,0,4734.28],[6368.27,6338.48,4730.81,0]],“destinations”:[{“location”:[9.700817,48.476406],“snapped_distance”:118.92},{“location”:[9.207773,49.153882],“snapped_distance”:10.54},{“location”:[37.572963,55.801279],“snapped_distance”:17.45},{“location”:[115.665017,38.100717],“snapped_distance”:648.79}],“sources”:[{“location”:[9.700817,48.476406],“snapped_distance”:118.92},{“location”:[9.207773,49.153882],“snapped_distance”:10.54},{“location”:[37.572963,55.801279],“snapped_distance”:17.45},{“location”:[115.665017,38.100717],“snapped_distance”:648.79}],“metadata”:{“attribution”:“openrouteservice.org | OpenStreetMap contributors”,“service”:“matrix”,“timestamp”:1602960711004,“query”:{“locations”:[[9.70093,48.477473],[9.207916,49.153868],[37.573242,55.801281],[115.663757,38.106467]],“profile”:“driving-car”,“responseType”:“json”,“metricsStrings”:[“DISTANCE”],“metrics”:[“distance”],“units”:“mi”},“engine”:{“version”:“6.3.0”,“build_date”:“2020-09-21T01:00:26Z”,“graph_date”:“2020-10-03T09:59:07Z”}}}
Having said that, I notice that on the matrix playground page, the return is a very nice table. How did you do this? Is the code you use something I can download and use?
This would be so much easier to work with for imports.
Thanks, and forgive my noobishness.