cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.

Querying Experience Service Information

BenAtLmco
12-Amethyst

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!

ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

2 REPLIES 2

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

 

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.

Announcements

Top Tags