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. 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 →
    • 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 →
      • 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 →
        • Can Apps Scripts Populate Link-To-Parent Fields?

          I am trying to populate a Link-To-Parent fields via Apps Script and nothing happens.

          If copied the format from Drop-down fields, Application User, and Application User Group fields (thinking they would all behave the same), but although the Scripts saves with no errors, and the records can be updated with no errors, the LTP field is not being populated.

          If this is possible, can you provide a sample of the code that I can use?

          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…)
            3 comments  ·  App Script  ·  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 →
            • 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 →
              • 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 →
                • App Script Padding For Child Records Numbers

                  I've been practicing with Apps Scripts and creating multiple child records.

                  From the documentation (see below), each child record will be created and numbered incrementally from 1 to the total number of records created (1 to 5).

                  QUESTION: How do you pad the sequence number as 01, 02, 03... instead of 1, 2, 3.

                  This is so column sorting is correct when more than 10 records exist.

                  Thanks

                  How do I create child records ?

                  // Create 5 child records
                  (1..5).each {
                  addChild “Child Table”, “Link to Parent”, [‘Status’ : ‘Active’, ‘Index’ : it ]
                  }

                  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  ·  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 →
                      • .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 →
                        • "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 →
                          • 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