cancel
Showing results for 
Search instead for 
Did you mean: 

API unable to find EPOTag table

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?

2 Replies
jking
Level 10
Report Inappropriate Content
Message 2 of 3

Re: API unable to find EPOTag table

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

Re: API unable to find EPOTag table

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.