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

[Patrice Paruit]

Bill,

Yeah I know there an adapter, I wanted to explore alternatives first as the method appears to be straight forward (at face value). If it's too painful this may have to be the way to go.

Cheers
Patrice

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

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



- ------------------------------------------------------------------------------
This email and any files transmitted with it are intended for the named recipient only. The information contained in this message may be confidential, legally privileged, or commercially sensitive. If you are not the intended recipient, you must not reproduce or distribute any part of the email, disclose its contents to any other party, or take any action in reliance on it. If you have received this email in error, please contact the sender immediately by return email and delete this message from your computer.
�������z��+%���W���֦z���Kh�������{.n����j�z˛���o)��W�i�^��f�j�o(m����0���v'�