RE: [BizTalker] Biztalk 06 Std - Using the SOAP Adapter to call web services

[Bill Chesnut]

Patrice,

I just noticed that the WSDL is for Salesforce, if you are going to be doing lots with Salesforce and BizTalk it may be worth looking at the TwoConnect, they have a Salesforce BizTalk Adapter (http://www.twoconnect.com/Products/tabid/63/Default.aspx).

This may solve some of your issues.

Bill Chesnut
BizTalk Server MVP
Melbourne, Australia

-----Original Message-----
From: biztalkerlist@xxxxxxxxxxxxxxxxxxxxxx [mailto:biztalkerlist@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of pparuit@xxxxxxxxxxxxxx
Sent: Thursday, 10 January 2008 12:33 PM
To: BizTalker@xxxxxxxxxxxxxxxxxxxxxx
Cc: Bill Chesnut
Subject: RE: [BizTalker] Biztalk 06 Std - Using the SOAP Adapter to call web services

Hi Bill,

Sorry, missed that essential piece on info it's BTS06, here's the wsdl

BTW: thanks for the prompt reply.  

Cheers
Patrice



---- Bill Chesnut <lists@xxxxxxxxxxxxx> wrote: 
> Patrice,
> 
> What version of BizTalk are we talking about 2004, 2006, 2006 R2?
> 
> Any way you can attach the WSDL file, just interested in seeing what the object they send back are.
> 
> But off the top of my head I don't think there is a way to use the BizTalk SOAP adapter to do what you want.
> 
> Bill Chesnut
> BizTalk Server MVP
> Melbourne, Australia
> 
> -----Original Message-----
> From: biztalkerlist@xxxxxxxxxxxxxxxxxxxxxx 
> [mailto:biztalkerlist@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of 
> pparuit@xxxxxxxxxxxxxx
> Sent: Wednesday, 9 January 2008 10:05 PM
> To: Biztalker@xxxxxxxxxxxxxxxxxxxxxx
> Cc: pparuit@xxxxxxxxxxxxxxxxx
> Subject: [BizTalker] Biztalk Std - Using the SOAP Adapter to call web 
> services
> 
> Hi,
> 
> I have the WSDL file and the proxy classes to make a Web Service call to retrieve an array of objects. To retrieve rows two calls are required, one to retrieve a cursor object the next a call to retrieve an -array- of custom objects. See sample implementation below when not using Biztalk.
> 
> .
> .
>        Dim records() As apex.sObject
>         Dim qr As apex.QueryResult = Nothing .
> .       [WebProxy binding code here]
> .
> 
>         qr = WebProxybinding.query("select id, Name, AccountId from 
> Contact")
> 
>         records = qr.records
> 
>         Console.WriteLine(" -- Contacts -- ")
> 
>         'we can loop through the returned records
>         For i As Integer = 0 To records.GetUpperBound(0)
>             'Because we asked for accounts we will convert
>             'the SObject for each record into an Contact object
>             Dim contact As apex.Contact = CType(records(i), 
> apex.Contact)
> 
>             'Now we can access any of the fields we had in the query
>             'select clause directly from the account variable
>             Console.Write((i + 1).ToString() + ". ")
>             Console.Write(Contact.Id + ", ")
>             Console.Write(Contact.Name + ", ")
>             Console.WriteLine(Contact.AccountId)
>         Next
> 
> What I'd like to do is use the SOAP Adapter on a Send port to call the 
> service, I understand that a SOAP call can be made with a single param without too much fuss where the rows are returned in single Service call. But this interface requires two calls, one to get a cursor object and another to get an array of custom objects.
> 
> Using the abovementioned interface is it possible to get the rows and load them into a single message based on the object schemas (which have been pre-provided)? I do recall reading at one time that arrays were not supported when using the SOAP Adapter.

> 
> If not, is there an alternative means using Biztalk? Samples?
> 
> Here's hoping.
> 
> Regards
> Patrice
> 
> 
> to unsubscribe to this list, please send a message back to the list 
> with 'unsubscribe' as the subject. Powered by mailenable.com - List 
> managed by http://www.readify.net
> 
> 
> 
> 
> 
> 
> to unsubscribe to this list, please send a message back to the list 
> with 'unsubscribe' as the subject. Powered by mailenable.com - List 
> managed by http://www.readify.net
> 
> 



to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net




to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net