Stephen Kennicutt

← Online Help, Knowledge Base, & Idea Sharing for TrackVia

My feedback

  1. How can I download a View with header (to create a table file) using API?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  TrackVia API & App Scripts » API  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Stephen Kennicutt commented  · 

    Hello and thank you for your message! Due to concerns with load on our server, we don't expose a way to export a CSV via the TrackVia OpenAPI (you can imagine what would happen if we had numerous people programmatically exporting views with a large number of records on them). Depending on your goals, there are a number of options available to you in order to transform the data: First, you can pull in a 3rd party library to convert JSON to a CSV; something like https://www.npmjs.com/package/json2csv should do the trick. Second, you can write JSON to a .json file, and use an online tool to run the conversion for you. See https://json-csv.com/ for an example. Third, it sounds like you'd like to import the JSON into a SQL database. Depending on your flavor of SQL, it is possible to import JSON into a database, albeit with some effort (see https://stackoverflow.com/questions/39224382/how-can-i-import-a-json-file-into-postgresql for an example). Please feel free to reach out with any more questions or guidance!

    Stephen Kennicutt
    Integrations Engineer @ TrackVia

Feedback and Knowledge Base

(thinking…)