Comments on aftergeek: Netsuite, ColdFusion, Java, and a lot of gray hair...

I was wondering if you are still working with CF a...

2008-01-30T01:57:00.000-06:00

I was wondering if you are still working with CF and Netsuite in any way?

I too am pulling my hair out - however I know little to nothing about java classes so your examples are fairly gibberish to me.

Any chance you could point me in the right direction ot simply login and then be able to pull a list of products from Netsuite?

If you are viewing the above, and lines are gettin...

2006-11-15T14:07:00.000-06:00

If you are viewing the above, and lines are getting cut off, click here. I haven't quite got a good way to do the posting of code yet.

// this is all in cfscript....sorry, but the java ...

2006-11-15T14:05:00.001-06:00

// this is all in cfscript....sorry, but the java classes and methods are fairly specific to Netsuite, but hopefully points in the right direction
RecordRef1 = CreateObject("java", "com.netsuite.webservices.platform.core_2_5.RecordRef"); // 2nd param is the fully qualified java class name
RecordRef2 = CreateObject("java", "com.netsuite.webservices.platform.core_2_5.RecordRef"); // 2nd param is the fully qualified java class name
RecordRef3 = CreateObject("java", "com.netsuite.webservices.platform.core_2_5.RecordRef"); // 2nd param is the fully qualified java class name
RecordType = CreateObject("java", "com.netsuite.webservices.platform.core_2_5.types.Recordtype");

aRecordRef = ArrayNew(1);

RecordRef1.setInternalId("1");
RecordRef2.setInternalId("2");
RecordRef3.setInternalId("3");

RecordRef1.setType(RecordType.customer);
RecordRef2.setType(RecordType.customer);
RecordRef3.setType(RecordType.customer);

ArrayAppend(aRecordRef, RecordRef1);
ArrayAppend(aRecordRef, RecordRef2);
ArrayAppend(aRecordRef, RecordRef3);

SearchMultiSelectField = CreateObject("java", "com.netsuite.webservices.platform.core_2_5.SearchMultiSelectField");
SearchMultiSelectFieldOperator = CreateObject("java", "com.netsuite.webservices.platform.core_2_5.types.SearchMultiSelectFieldOperator");

CustomerSearchBasic = CreateObject("java", "com.netsuite.webservices.platform.common_2_5.CustomerSearchBasic");

SearchMultiSelectField.setSearchValue(getJavaArray(aRecordRef));
SearchMultiSelectField.setOperator(SearchMultiSelectFieldOperator.anyOf);

CustomerSearchBasic.setInternalId(SearchMultiSelectField);

customerSearchBasic.setInternalId(new SearchMultiSelectField(rr, SearchMultiSelectFieldOperator.anyOf));

function getJavaArray(aArray) {
// Given a populated coldfusion array, return the equivalent java array of oJavaClass elements. The elements contained
// in aArray must be of the same java class as oJavaClass.
// PARAMETERS:
// aArray - Required. Array of any valid datatype. Convert this array to a java array.
// oJavaClass - Optional. Object of the datatype of which you want to convert aArray. If not passed, then the first element.
// of aArray will be used to determine the datatype.
// RETURNS: java.lang.reflect.Array
var i = 0;
var javaArray = CreateObject("java", "java.lang.reflect.Array");
var returnArray = "";

if (ArrayLen(Arguments) eq 2) { // Check if optional oJavaClass argument exists.
oJavaClass = Arguments[2];
}
else { // if optional oJavaClass not passed, use the first element of aArray.
oJavaClass = aArray[1];
}
returnArray = javaArray.newInstance(oJavaClass.getClass(), ArrayLen(aArray)); // create the java array of the same class as the object oJavaClass of the same length as aArray
for (i=1; i lte ArrayLen(aArray); i=i+1) { // create the java equivalent of the array
javaArray.set(returnArray, JavaCast("int", i-1), aArray[i]);
} // End for

return returnArray;
} // End function getJavaArray

Steven, I will post some sample code that replicat...

2006-11-15T14:05:00.000-06:00

Steven, I will post some sample code that replicates the above as best as possible. Also see my later post about manually running wsdl2java and compiling the stub classes instead of relying on ColdFusion to do it. I ran into issues with certain methods expecting datatypes other than what was documented. Also check out Ben Nadel's GetJavaClassMethods udf. It has been a lifesaver when it comes to debugging (I also posted a cfscript equivalent with error handling in the comments on his original post). This is how I finally figured out that the wsdl methods were screwed up and needed to be recompiled by hand. I passed the web service object to GetJavaClassMethods and dumped the results to see what datatype each method expected.

The key for the ColdFusion equivalent of these calls is using the CreateObject function.

For the above code, here is how I would recreate it (see next comment)...

What would these calls actually look like in ColdF...

2006-11-15T13:29:00.000-06:00

What would these calls actually look like in ColdFusion? I'm having some issues invoking web services with complex types, and it sounds like you've got this all figured out...