I finally have the the Webfocus RESTful adapter successfully installed and created the tables and custom reports to access the data. (Thanks Support for the help!)

[Roberto Trevino]

I am currently running the 'GET_ITEMS' fex report. All the information that I wanted to appear is there but I can't seem to find fields that would show me if a file is published/unpublished and shown/hidden.

Is there such a field and if so, is located in the table GET_ITEMS or in another table?

Thanks

[Roberto Trevino]

For those who are wondering, I think I figured out how to tell if a file (fex,reportcaster, other, etc...) is published or not by looking at the GET_ITEMS.ITEMS.OWNERNAME field.

If this field is equal to <blank> ' ' then it is published. Otherwise, if it has a username then it is unpublished and that user can publish it (or an admin level user can).