TrackVia API & App Scripts

How to access and use TrackVia's API or Application Scripts?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. List of Fields used in App Scripts

    It would be good to have a list of fields used in application scripts. So that if a table is changed and field name updated it is easy to identify what App Scripts will need changing as well.

    Best case scenario would be that the field renames flow into and change the app scripts like they do in calculated fields in tables.

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  App Script  ·  Flag idea as inappropriate…  ·  Admin →
    • getChildren function

      Regarding the getChildren function described in the app scripting documentation - I think it lacks some info. How do you use it properly?

      getChildren "child table name", "link to parent name"

      it's not only not working, but it doesn't make any sense: how would trackvia know which parent I am referring to if I only specify the link name, but not the value?

      for reference, this is what is written in the docs:
      Function: getChildren
      Description: Get the associated child records.
      Arguments:
      Name of the child table
      Name of the relationship
      Returns:
      List of found child records
      Example:

      List childRecords…

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  App Script  ·  Flag idea as inappropriate…  ·  Admin →
      • Finding records within a certain time interval

        Is there a way to find records in a table via scripting that have a date column value greater than a value (as opposed to just equal to it as the method seems to work now)?

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  App Script  ·  Flag idea as inappropriate…  ·  Admin →
        • create an api for an excel spreadsheet?

          I want to pull XML data from trackvia for the purpose of working with live views in an excel spreadsheet.

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
          • Which field types are not supported by app scripts? Can we change this?

            I was already aware that app scripts are unable to handle image/document fields(bummer), but it appears they may not support other calculated field types as well... some clarification on the subject would be nice. I would think you might want this published on your developer site as well.
            Thanks!

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              1 comment  ·  App Script  ·  Flag idea as inappropriate…  ·  Admin →
            • Add user last login date/time to get_users()

              Can you add the user's last login date & time to the get_users() method please?

              3 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
              • "Wrong data type provided for input." 400 error.

                Hi,

                I was unable to use the following API end points

                GET /openapi/views/123/records/12/files/message

                It returns "Wrong data type provided for input." 400 error.

                1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
                • Wrong data type provided for input.

                  Hi,

                  I was unable to use the following API end points

                  GET /openapi/views/{viewId}/records/{recordId}/files/{fieldName:.+

                  It returns "Wrong data type provided for input." 400 error.

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    2 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
                  • .Net, C#

                    Do you have a .net, c#, vb.net sdk?

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      2 comments  ·  API  ·  Flag idea as inappropriate…  ·  Admin →
                    • Supply sample JSON data for operations

                      Something that might be helpful is to link to sample Json data (request and response) for each method. This would help greatly to make sure we are posting the correct Json structure.

                      Not a big deal, but I'm running into issues with my Json serialization that I'm sending to create records and I believe it's the structure that's incorrect. It would be nice to check against.

                      5 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                      • 1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                        • How to access TrackVia's API

                          To access TrackVia's API, just create an account over at http://developer.trackvia.com. Once you're in the system, you'll get access to an auth token, documentation and code samples. More info at http://help.trackvia.com/knowledgebase/articles/424781-trackvia-api.

                          0 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Don't see your idea?

                          TrackVia API & App Scripts

                          Feedback and Knowledge Base