Google Drive Link to Json Link App

A single point API for viewing true JSON datatypes.


This app explained:

When you use a "/view" link for a document file type on Google Drive, the link returns a "human-readable" version of the document. If the document contains a JSON object, curling the link will not return the object, but rather an HTML document containing uglified javascript. That code, when viewed in a browser, renders a view that looks like text on a page (or a Google Doc).


Systems utilizing JSON data by way of an HTTP link are expecting a JSON object, not an HTML document. By giving this hosted app such a Google Drive view URL, it will convert the link to a download/streaming link, load the contents into a buffer, and return it with the necessary headers to be interpreted as a json object.


As links can get to be quite long, you may also submit just the file ID from the URL. The file id is the string of numbers, letters, and sometimes symbols that is found between `/d/` and `/view` in the URL. For brevity, you may prefer to use just the file ID.


Try it out:



Try it out with just the File ID: