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

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

How to create Thingworx extension for converting data from json object to infotable

RL_10230695
5-Regular Member

How to create Thingworx extension for converting data from json object to infotable

Hi Everyone,

 

I am having troubles while creating Java extension for converting data from JSON to INFOTABLE, I have tried multiple methods and no seem to work.

 

@ThingworxServiceDefinition(name = "JsontoInfo", description = "", category = "", isAllowOverride = false, aspects = {
"isAsync:false" })
@ThingworxServiceResult(name = "Result", description = "", baseType = "INFOTABLE", aspects = {
"isEntityDataShape:true", "dataShape:DemoDS" })
public InfoTable JsontoInfo(
@ThingworxServiceParameter(name = "input", description = "", baseType = "JSON", aspects = {
"defaultValue:{\"name\":\"Abcd\",\"salary\":25000,\"married\":true}" }) InfoTable input) {
_logger.trace("Entering Service: JsontoInfo");
_logger.trace("Exiting Service: JsontoInfo");
return input;
}

ERROR:  Unable to Invoke Service JsontoInfo on TestResJson2info : Cannot cast org.json.JSONObject to                        com.thingworx.types.InfoTable

 

if anybody Know any solution  regarding this, Kindly share it  ASAP.

 

Thanks & Regards 

Raviteja L.

4 REPLIES 4

We can convert JSON into INFOTABLE in javascript service itself.

Here some articles.

Why do you want to do this with Extension?

nmutter
14-Alexandrite
(To:RL_10230695)

@ThingworxServiceDefinition(name = "JsontoInfo", description = "", category = "", isAllowOverride = false, aspects = {
"isAsync:false" })
@ThingworxServiceResult(name = "Result", description = "", baseType = "INFOTABLE", aspects = {
"isEntityDataShape:true", "dataShape:DemoDS" })
public InfoTable JsontoInfo(
@ThingworxServiceParameter(name = "input", description = "", baseType = "JSON", aspects = {
"defaultValue:{\"name\":\"Abcd\",\"salary\":25000,\"married\":true}" }) JSONPrimitive jsonInput) {
    _logger.trace("Entering Service: JsontoInfo");
    // TODO convert jsonInput to infotable
    _logger.trace("Exiting Service: JsontoInfo");
    return new InfoTable();
}

With the code you provided the parameter input should be of type JsonPrimitive. In your JAva code you then have to convert your json into your wanted infotable (just marked as TODO).

jensc
17-Peridot
(To:RL_10230695)

There is a function for the InfoTable data type called ".fromJSON()", this is however a deprecated function:

 

http://support.ptc.com/help/thingworx_hc/javadoc/com/thingworx/types/InfoTable.html

 

So I am not sure if you can still use it to build your infotable data type from a JSON data type.

Hi @RL_10230695 ,

Using Java extensions to achieve something that can be done in a ThingWorx service is generally not recommended (outside of situations where you just can't achieve what you want with ThingWorx's internal libraries).

I'm saying this because I have witnessed quite a few applications with their logic built entirely in Java due to unclear reasons.

Since you have the same capabilities in Javascript, it makes no sense to build that logic in Java extension, as it's harder to maintain, deploy and modify later down the road.

If you're looking to convert a JSON to infotable, just iterate over the JSON rows and for each JSON row add a row in your infotable.

 

 

Top Tags