Skip to main content
Apr 23, 2021 6:17 PM UTC
Solved

Querying Experience Service Information

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!

BenAtLmcoAnswer
Apr 26, 2021 11:48 PM UTC

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.

2 replies

Apr 26, 2021 2:48 AM UTC

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

 

BenAtLmcoAuthorAnswer
Apr 26, 2021 11:48 PM UTC

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.