Skip to main content
B
BenAtLmco13-Aquamarine
13-Aquamarine
April 23, 2021
Solved

Querying Experience Service Information

  • April 23, 2021
  • 1 reply
  • 2113 views

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!

    Best answer by BenAtLmco

    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.

    1 reply

    D
    dsgnrClarK16-Pearl
    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

     

    B
    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.

      Terms & ConditionsCookie settingsAccessibility statement