2 Replies Latest reply on May 6, 2014 1:19 PM by dpierson

    API unable to find EPOTag table

    dpierson

      Hello,

       

      I am tring to produce a list of tags by running .../remote/core.executeQuery?target=EPOTag&select=(select+EPOTag.Name) but it returns with

      "Error 0 : Unable to find target table 'EPOTag' using databaseType."

       

      Attempting to look up the table with .../remote/core.listTables?table=EPOTag produces a similar error message

      "Error 0 : Table 'EPOTag' not found"

       

      Obviously the table exists, does anyone know why this table might be hidden from the API?

        • 1. Re: API unable to find EPOTag table
          jking

          listTables is not exposing SQL, it's the query system.  Run a listTables with no argument to see all the possible targets.

           

          For tags specifically I'm pretty sure there's a listTags command ... Do a core.help and look for 'tag.'

           

          Apologies I'm mobile at the moment no epo server to check myself.

           

          Good luck,

          Jon

          1 of 1 people found this helpful
          • 2. Re: API unable to find EPOTag table
            dpierson

            Right, so you can run .../remote/system.findTag? with no arguments to get the desired results.

             

            But it returns with more data than I require, I was thinking the the adhoc query would be cleaner but it doesnt seem to be able to access the EPOTag table.

             

            "listTables is not exposing SQL" I wasnt trying to expose SQL simply lookup a table, isnt that the purpose of this command? I did run it with no agruments but didnt find anything that would match what I needed.