SharePoint has a method of retrieving data from a foreign source and presenting it can BDC (Business Data Catalog). One method is using web services. So I've created a web service to expose my Notes data. It requires three methods: Finder, Specific Finder, and Index ID. It was no problem creating the Specific Finder and Index ID. However, the Finder is killing me. Seems it needs an array (or List) of objects that contain document data. I've tried several ways to get an array of object out of my web service so .NET could read it. The VARIANTARRAY_HOLDER couldn't be read by .NET. So the question is, has anyone gotten this to work? If you can help me get this working, I'll buy you dinner at Lotusphere....uuuug.

1. Bill12/12/2008 01:53:45 AM
Homepage: http://www.billbuchan.com

Trick is to define another class that contains your collection of whatever.

So working backwards

class whatever
public stuff as string
public otherstuff as integer
end class

class collectionOfWhatever

public myCollection() as whatever
sub new()
redim myCollection(0) as whatever '' So there's always something in it
'' required for nd7, not required for nd8
end sub
end class


class theWebServiceClass

public function getMyCollection as collectionOfWhatever

dim cow as new CollectionOfWhatever

'' do something meaningful with the cow.

set getMyCollection = cow
end function

end class


et voila. Remember - variants are bezelebubgs underpants - you can stuff anything in there but you might not want to go near it.

Shulas for the 500lb steak ?



---* Bill

---

2. Jeff Crossett12/12/2008 05:14:52 AM
Homepage: http://www.crossedconnections.org

Although it is based in R6, I show how the SOAP envelope should look to return arrays of objects.

{ Link }

---

3. Gary12/12/2008 11:12:02 AM

Wild Bill, I'm getting there. I had to add an "ADD" method to the collection class. But now I'm getting an object that .NET is reading. Still missing data but I'm sure there is a bug

---

4. Gary12/16/2008 01:58:47 PM

Bill, It's working . Your tip "Redim in the New" of the array in Domino 7 did the trick...along with getting around references to my Order Object. So dinner is on me.....well BillG
I'll post the code when I clean it up.

---