1 Reply Latest reply on Jan 7, 2015 4:20 PM by yeayu

    API: Unknown column:Branch for table:EPOMasterCatalog

    epo909

      Hi,

       

      I have a web application that needs to query ePO via API. I need to fetch the current DAT in the repository so I've assembled the following query:

       

      target=EPOMasterCatalog&select=(select EPOMasterCatalog.ProductVersion)&where=(where (and (eq EPOMasterCatalog.ProductName "DAT") (eq EPOMasterCatalog.Branch "Current")))

       

      When executing the query the server returns:

       

      Error 0 :

      Unknown column:Branch for table:EPOMasterCatalog

       

      This is odd since EPOMasterCatalog does have a Branch column...

       

      I need to specify the brach otherwise the query return 2 dat versions from branches 'current' and 'previous'.

       

      I've also checked the API documentation and this seems the proper way to define a where with teh 'and' clause.

       

      Anyone have any ideas why this is failing?

       

      Thanks in advance.

      RD