Querying Experience Service Information

[BenAtLmco]

I was curious whether it is possible to query some basic information from an AR experience service in Thingworx.  Basically, I'd like to be able to call a service in Thingworx that returns some information on the AR experiences that have been published to an experience service on the same server.  Would it be possible to get a list of experiences that have been published?  Basic information about individual experiences such as the author, thingmark association, description, etc?  Any guidance would be greatly appreciated!  Thanks!

[dsgnrClarK]

Using https://<ES  server url>/ExperienceService/content/projects/ can get a json file that contains Project list and some properties.

https://www.ptc.com/en/support/article/CS281363

https://www.ptc.com/en/support/article/CS299144

https://www.ptc.com/en/support/article/CS330711

[BenAtLmco · Accepted solution]

There is a PTC.SCA.SCO.PostgresDatabase Thing on our Thingworx instance.  Adding an SQL Query script like below retrieves all projects published to the experience service associated with that Thingworx instance:

SELECT

*

FROM

idmapping

Posting for posteriority in case any is wondering how this was resolved.