Skip to main content
C
cbaurand12-Amethyst
12-Amethyst
January 31, 2023
Solved

Use an infotable passed as parameter in a java extension

  • January 31, 2023
  • 2 replies
  • 3449 views

I'm facing some problems when trying to use an infoTable in my extension.

The service is a utility service that is static:

 

 

 

public static void myService(Context cx, Scriptable me, Object[] args, Function func) throws Exception {
InfoTable iTable= (InfoTable) args[0];

...

 

 

 

in the metaData:

 

 

<FunctionDefinition description=""
name="myService
<ParameterDefinitions>
<FieldDefinition baseType="INFOTABLE"
aspect.dataShape="keysShape"
aspect.isEntityDataShape="true"
description="the key names" name="keys" ordinal="0" />
</ParameterDefinitions>
<ResultType baseType="NOTHING" name="result"
ordinal="0" />
</FunctionDefinition>

 

 

The call from the javascript;

 

 

 

let keys= Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({
 infoTableName: "InfoTable",
 dataShapeName: "keysShape"
});
keys.AddRow({key:"a string"});

myService(keys);

 

 

 

The problem if at this line:
InfoTable iTable= (InfoTable) args[0];

I get this exception:

Error executing service PrivateInitializeFastQueryCache. Message :: class com.thingworx.dsl.engine.adapters.ThingworxInfoTableAdapter cannot be cast to class com.thingworx.types.InfoTable (com.thingworx.dsl.engine.adapters.ThingworxInfoTableAdapter and com.thingworx.types.InfoTable are in unnamed module of loader org.apache.catalina.loader.ParallelWebappClassLoader @4e4efc1b) - See Script Error Log for more details.

Any Idea?

 

 

 

Best answer by cbaurand

Finally, I did that in the extension:

InfoTable users = ((ThingworxInfoTableAdapter) args[0]).getInfoTable();

 

And it works fine.

 

Any comment?

2 replies

A
alcubierre10-Marble
10-Marble
January 31, 2023

Try to convert to JSON when calling to service.

 

let keys= Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({
 infoTableName: "InfoTable",
 dataShapeName: "keysShape"
});
keys.AddRow({key:"a string"});

myService(keys.ToJSON());

 

from

https://community.ptc.com/t5/ThingWorx-Developers/Why-ThingworxInfoTableAdapter-cannot-be-cast-to-com-thingworx/td-p/523509

 

C
cbaurand12-AmethystAuthorAnswer
12-Amethyst
January 31, 2023

Finally, I did that in the extension:

InfoTable users = ((ThingworxInfoTableAdapter) args[0]).getInfoTable();

 

And it works fine.

 

Any comment?

    N
    nmutter16-Pearl
    16-Pearl
    February 1, 2023

    I am a little confused about your method signature. I know signatures like

    @ThingworxServiceDefinition(name = "Greeting", description = "Hello world")
@ThingworxServiceResult(name = "Result", description = "Result", baseType = "STRING")
public String Greeting(@ThingworxServiceParameter(name = "userToGreet", description = "The user you're greeting", baseType = "USERNAME") String 
userToGreet)throws Exception {
 return "Hello " + userToGreet + ". How are you?";
}

    And with this syntax you just define baseType as INFOTABLE.

    That service is from an example in the ThingWorx_Extension_Development_Guide  (I only found the guide for 8.3. Not sure where 9.x is - should be in helpcenter but had no luck) .

     

      A
      alcubierre10-Marble
      10-Marble
      February 1, 2023

      This is java extension. My example was a simple javascript service.

      N
      nmutter16-Pearl
      16-Pearl
      February 2, 2023

      your example is okay. I am confused about the java extension code from the original question.

      Terms & ConditionsAccessibility statement