Skip to main content
pshashipreetham
18-Opal
18-Opal
April 13, 2023
Question

Get Services used in a Mashup

  • April 13, 2023
  • 1 reply
  • 2141 views

Hi,

Is there a way to get service names that are used in a Mashup? Is there any snippet in Thingworx for this requirement?

 

Thanks,

 

1 reply

22-Sapphire I
April 13, 2023

If you export the mashup to xml you can find them in the xml

You can also pull the definition from the persistence provider, it would then be in JSON

There are no snippets

pshashipreetham
18-Opal
18-Opal
April 14, 2023

Hi @PaiChung ,

 

Mashup Data is stored somewhere in DB, that's how it loads all the services and bindings when we edit a mashup in the composer , isn't it?

Or Mashup's are stored in the form XML only in DB ?

 

Thanks,

17-Peridot
April 14, 2023

Hello,

 

There is a table called: mashup_model in the Thingworx platform DB model.

In this table you can find you mashup using the "name" column and you can find the service definitions in the "mashupContent" column as a JSON.

 

For this you would need to know the name of your thing though as the mashupContent JSON contains a bunch of other things as well.

 

There are also some Entities service definition tables as well, however I couldn't find the definitions for my test mashup there but you might have better luck.

I'm not entirely sure that this way would be recommended by PTC though, so do it at your own risk.

 

Regards,

Jens