Sorry to bother if it is something too simple or evident but i need help to use the directions API :
I would like to use an Excel formula to get the content of the page and extract “distance” and “duration”.
To do this I use =WEBSERVICE(url) function, and i cut the desired part of the raw output with some stxt etc.
It’s kind of artisanal but it’s the only way that i found without messing with macros where 'im lost,… and it works.
It works well with short results, but when they exceed 32k caracters, the result give an error instead of being written, even partially, and there is no way to access the needed information located in the first 400 characters.
So i need some way to shorten the result of the query :
- Is there any parameter in the URL that i could add to limit number of possible itineraries, etc. ?
- Is there any parameter in the URL that could give a result in an XML format, to isolate these parts directly from the formula ?
Sorry if there is some documentation giving these informations but i just couldn’t find it, and i did search quite a lot.
Thank you very much in advance for your insights if you can help me !