asked on

cfinvode webservice results

I am working with smartermail's webservice functions. I believe that I have the invoke code written properly but I am getting in return what looks like the .NET methods that I need to retrieve my results.
Here is the sample code that I have thus far.

<cfinvoke
webservice="http://mail.ourppimarketing.com:9998/Services/svcMailListAdmin.asmx?WSDL"
method="GetMailingListsByDomain"
returnvariable="wsResults">

<cfinvokeargument name="AuthUserName" value=""/>
<cfinvokeargument name="AuthPassword" value=""/>
<cfinvokeargument name="DomainName" value="ourppimarketing.com"/>

</cfinvoke>

<cfdump var="#wsResults.ListNames#">

<cfset TempQuery = QueryNew("ListNames")>
<cfset newRow = QueryAddRow(TempQuery)>
<cfloop collection="#wsResults.ListNames#" item="a">
<cfset temp = QuerySetCell(TempQuery, "ListNames", trim (wsResults.ListNames))>
<cfoutput>#a#</cfoutput>
</cfloop>

<cfdump var="#TempQuery#">

And here is the page that will show the results from the code above.
http://www.ourppimarketing.com/wrapper/test.cfm

Any suggestions

ASKER CERTIFIED SOLUTION

duncancumming

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

clayo

ASKER

Ok so that seems to give the following result

String : [Ljava.lang.String;@28ed4b76 TypeDesc : org.apache.axis.description.TypeDesc@72f544f7

I am confused because I am trying to ge a list of the MailingLists from smartermail and I know that the list is called Test. Do you know why I would get the results above?

here is my code and the same link as above can be used to see the results

<cfinvoke
webservice="http://mail.ourppimarketing.com:9998/Services/svcMailListAdmin.asmx?WSDL"
method="GetMailingListsByDomain"
returnvariable="wsResults">

<cfinvokeargument name="AuthUserName" value=""/>
<cfinvokeargument name="AuthPassword" value=""/>
<cfinvokeargument name="DomainName" value="ourppimarketing.com"/>

</cfinvoke>


<cfdump var="#wsResults#">
<cfdump var="#wsResults.ListNames#">

<cfset TempQuery = QueryNew("ListNames")>

<cfloop collection="#wsResults.ListNames#" item="a">
      <cfset QueryAddRow(TempQuery)>
      <cfset QuerySetCell(TempQuery, "ListNames", trim (wsResults.ListNames))>
      <cfoutput>#a# : #wsResults.ListNames[a]#</cfoutput>
</cfloop>

duncancumming

Try:

<cfset QuerySetCell(TempQuery, "ListNames", trim (wsResults.ListNames[a]))>

Open in new window

clayo

ASKER

here is the code that I have entered

<cfset TempQuery = QueryNew("ListNames")>

<cfloop collection="#wsResults.ListNames#" item="a">
      <cfset QueryAddRow(TempQuery)>
      
<cfset QuerySetCell(TempQuery, "ListNames", trim (wsResults.ListNames[a]))>
      <cfoutput>#a# : #wsResults.ListNames[a]#</cfoutput>
</cfloop>

this gives me the same result.

String : [Ljava.lang.String;@6d1eae0f TypeDesc : org.apache.axis.description.TypeDesc@72f544f7

http://www.ourppimarketing.com/Wrapper/test.cfm

SOLUTION

_agx_

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial