Skip to main content
13-Aquamarine
April 23, 2021
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
13-Aquamarine
April 26, 2021

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

16-Pearl
April 26, 2021

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

 

Translate
BenAtLmco13-AquamarineAuthorAnswer
13-Aquamarine
April 26, 2021

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.

Translate